hi frnds,
it is a standard progrm using the logical database pfy. to retrive data.
i have to add 5 more fileds along with footer approved by and page break(shown below) to the output list.
please help me with ur inputs.
Header Data:
*Note:
Keep the header data same as standard payment list.
Summary Data:
*Note:
Following fields are only those needs to be added in customized program. For the rest, please refer to the standard program
· Vendor Chinese Name
· Check/TT No.
· PO No.
· Purchasing Group
· Reference
· Due Date
Footer Data:
*Note:
The Footer Data need to be display at the bottom of each page:
· Review By
· Prepared By:
Breaking:
· Page break when information overflow
ZH Name C 20 As standard As standard ADRC- NAME1NAME2 Display vendor Chinese name:Select NAME1NAME2 from ADRCWHERE ADRC-ADDRNUMBER=REGUH- ADRNRAND ADRC-NATION = CIf no data can be retrieved, leave the field as blank.Wrap if the name exceed the limit. Insert the field under Vendor English Name in payment list.Refer to the attached for layout, Highlighted is place should be inserted to :
Check/TT No. C 8 As standard As standard PAYR-CHECT Display Check/TT number of this payment documentSelect CHECT from PAYRWhere PAYR-LAUFD = REGUH-LAUFDAnd PAYR-LAUFI= REGUH-LAUFIAnd PAYR-VBLNR= REGUH-VBLNR which is displayed in current payment listInsert the field in header line 1 of layout pop-up.
PO No. C 10 As standard As standard BSEG-EBELN Display the PO number of invoice documentSelect EBELN from BSEG Where BSEG-BELNR=REGUP-BELNRBSEG-GJAHR=REGUP-GJAHRAnd BSEG-BUZEI= REGUP-BUZEIInsert the field in position line 1 of layout pop-up.
Purchasing Group C 4 As standard As standard EKKO-EKGRP Display purchasing group in order to identify the buyer in charge of related POSelect EKKO-EKGRP from EKKO where EKKO-EBELN =BSEG-EBELN Where BSEG-BELNR=REGUP-BELNRBSEG-GJAHR=REGUP-GJAHR And BSEG-BUZEI= REGUP-BUZEIInsert the field in position line 1 of layout pop-up.
Reference C 10 As standard As standard BKPF-XBLNR Display physical invoice number of each invoice document in SAPSelect XBLNR from BKPF Where BKPF-BELNR=REGUP-BELNRBKPF-GJAHR=REGUP-GJAHRInsert the field in position line 1 of layout pop-up.
Due Date C 10 As standard As standard Calculated Display due date for the invoice document.Refer to the calculated logic of the field RFPOSXEXT-FAEDT in program SAPLKKBL (T-Code:FBL1N)Insert the field in position line 1 of layout pop-up.