Current Position:Home > Report containing details of Payment released to Vendor -----PLS HELP ME

Report containing details of Payment released to Vendor -----PLS HELP ME

Update:10-11Source: network consolidation
Advertisement
Hi All,
Pls Help me .
My client asking create new report.
they gave some fields also.
But, problem is my abap people asking which table will come data.
but i didn't have idea which table its take output.
pls help me
<<< Vendor Code >>>
<<< Vendor Name >>>
<<< Vendor Address >>>
<<< Vendor City >>>
Please find enclosed the details of payments released to you from << from selection date >> to << upto selection date >>
Document No     
Cheque no     Date of Release
Vendor Invoice no
Vendor Invoice Passed for (MIRO Value)
PO no.     
Basic Rate from PO     
GR No.     
Material & Description     
Qty Invoiced (MIRO qty)     
Qty Received (MIGO qty)
in above 4 feilds related to FI .
Pls help me what are the table can i give
thanks
supriya

The Best Answer

Advertisement
hi,
select table ADRC:
sample (join with lfa1)
      SELECT name1 city1 post_code1 street
             INTO CORRESPONDING FIELDS OF ITAB
             FROM ADRC AS A INNER JOIN LFA1 AS L
              ON  AADDRNUMBER = LADRNR
              WHERE L~LIFNR = P_LIFNR
               AND A~DATE_TO  GE SY-DATUM.
or use one of the function modules from my 1st post
plz reward usefule answers
thanx and regards
Andreas
  • Report containing details of Payment released to Vendor -----PLS HELP ME Update:10-11

    Hi All, Pls Help me . My client asking create new report. they gave some fields also. But, problem is my abap people asking which table will come data. but i didn't have idea which table its take output. pls help me <<< Vendor Code >>> &

  • Payment Release for Vendor Update:10-11

    Dear Gurus, Please help on the below issue.I had made standard release for payment configuration and assigned the workflows.When am doing vendor invoice work flow is triggering but getting an error. Error in workflow Customizing of payment release Me

  • Payment Advice to Vendor Report Format Update:10-11

    Dear Sap Guys,   This is the First time i am posting my queries i am currently in client place. I would like to get report format for Payment Advice to Vendor Report Format And Asset Accounting Documents with Depreciation configurationDear Rupa, Plea

  • Vendor payments release workflow!!! Update:10-11

    Hi all Can somebody explain to me how we setup standard workflow so that all vendor invoices greater than 100.000 can be blocked for payment automatically & released by some other user? I tried to give the document type "KR" to the workflow

  • Work Flow Setting for Vendor Payment Release using TCode F-53 Update:11-30

    Hi Experts, We want to 3 level payment release strategy for Vendor using Workflow in F-53 Regards, Gaurav.http://help.sap.com/saphelp_46c/helpdata/en/6e/1217de9f0411d189b80000e829fbbd/frameset.htm Goto Accounts Payable (FI-AP) and in that "Vendor Dow

  • Error while assigning user for release approval path for payment release Update:10-11

    Hi everyone,      I am trying to assign user for payment release in SPRO. I have defined upto 'Define relevant document types for release for payment', after that while assigning user in terms of position for release and save it, i am getting error '

  • Vendor changes tracking, Payment term filtering, Vendor listing Update:10-11

    Hi All, Need somebody help on the following points, 1-  While changing the vendor via "process vendor and Bidder" (Business partner maintenance) transaction in EBP, the selection of payment term is restricted.  That is in SPRO I can see lot of p

  • AUtomatic Payment Program - Unable to make payment to Foreign Vendor having bank account in home country and home currency Update:10-11

    Hi We have company code in India. Payment method C is configured. Now we have a requirement that we have to make a payment to a vendor in Bangladesh who is having Bank account in India in INR. Already I have ticked the foreign payments as shown below

  • Line item not relevant for payment release Update:10-11

    Dear Expert, When I select payment block : 'Payment Request' in FB60. Error Message appear "Line item not relevant for payment release". I also have set payment block in master vendor and  OBB8. Can you tell me why the error message still appear

  • Overview of payment term per vendor? Update:10-11

    Dear all, My customer is using report s_alr_87012093 as an overview for vendors. Now they want to see an overview over what payment term is used per vendor, to see if all payment terms are correct or not. Is it possible to get that overview in that r