Hi experts, this is requirement with this i have to design report, Please help me on this and send me code.
Interface
SAP billing document à local accounting packages
Slovakia
1. Specification
1.1. Selection panel
The selection panel should include following criteria:
Sales organisation VBRK-VKORG Required Allow for one or many.
Billing date VBRK-FKDAT Required Allow for one date or a date range.
Billing type VBRK-FKART optional If blank, then extract everything. Allow for one or many.
Sample of a selection panel:
1.2. File format
· ascii text
· fixed width
· no field delimitors
1.3. Output: Slovakia (VKORG = 1755)
Field na-me Field length Field charac-teristics Remarks
Customer ID 8 char VBRK-KUNRG Select the payer. Field VBRK-KUNRG has 10 chars, display only the last 8 chars (most right).
Billing Date 6 char VBRK-FKDAT VBRK-FKDAT has a format DD.MM.YYYY, in the output this needs to be formatted like DDMMYY
Payment Due date 6 char VBRK-FKDATVBRK-ZTERM Here the payment due date needs to be calculated:· Take VBRK-FKDAT and VBRK-ZTERM.· For the payment term found, lookup V_T052-ZTERM, and check the number of days V_T052-ZTAG1.· Add V_T052-ZTERM to VBRK-FKDAT.· Display DDMMYY.
Billing document number 7 char VBRK-VBELN VBRK-VBELN has 10 char, display only the last 8 chars (most right).
Goods amount 22 12 numright justified2 decimal placesdecimal separator = „.“000000000.00 KONV-KWERT Compare VBRK-KNUMV with KONV-KNUMV· If KONV-KBETR for condition MWST = 22,00% then add up all the items KONV-KPOSN with MWST = 22%· Select all conditions with KONV-KVSL1 = ERL, = ERF and = ERS and KONV-KINAK = ‘initial’ and KONV-KSTAT = ‘initial’· Sum up the condition values KONV-KWERT· Add up all the KONV-KWERT.
Vat amount 22 12 numright justified2 decimal placesdecimal separator = „.“000000000.00 KONV-KWERT Compare VBRK-KNUMV with KONV-KNUMV· If KONV-KBETR for condition MWST = 22,00% · Select all conditions with KONV-KVSL1 = MWS and KONV-KINAK = ‘initial’ and KONV-KSTAT = ‘initial’· Sum up the condition values KONV-KWERT· add up all the KONV-KWERT
Goods amount 19 12 numright justified2 decimal placesdecimal separator = „.“000000000.00 KONV-KWERT Compare VBRK-KNUMV with KONV-KNUMV· If KONV-KBETR for condition MWST = 19,00% then add up all the items KONV-KPOSN with MWST = 19%· Select all conditions with KONV-KVSL1 = ERL, = ERF and = ERS and KONV-KINAK = ‘initial’ and KONV-KSTAT = ‘initial’· Sum up the condition values KONV-KWERT· Add up all the KONV-KWERT.
Vat amount 19 12 numright justified2 decimal placesdecimal separator = „.“000000000.00 KONV-KWERT Compare VBRK-KNUMV with KONV-KNUMV· If KONV-KBETR for condition MWST = 19,00% · Select all conditions with KONV-KVSL1 = MWS and KONV-KINAK = ‘initial’ and KONV-KSTAT = ‘initial’· Sum up the condition values KONV-KWERT· add up all the KONV-KWERT
Goods amount 5 12 numright justified2 decimal placesdecimal separator = „.“000000000.00 KOMP-NETWR Compare VBRK-KNUMV with KONV-KNUMV· If KONV-KBETR for condition MWST = 5,00% then add up all the items KONV-KPOSN with MWST = 5%· Select all conditions with KONV-KVSL1 = ERL, = ERF and = ERS and KONV-KINAK = ‘initial’ and KONV-KSTAT = ‘initial’· Sum up the condition values KONV-KWERT· Add up all the KONV-KWERT.
Vat amount 5 12 numright justified2 decimal placesdecimal separator = „.“000000000.00 KONV-KWERT Compare VBRK-KNUMV with KONV-KNUMV· If KONV-KBETR for condition MWST = 5,00% · Select all conditions with KONV-KVSL1 = MWS and KONV-KINAK = ‘initial’ and KONV-KSTAT = ‘initial’· Sum up the condition values KONV-KWERT· add up all the KONV-KWERT
Total amount 12 numright justified2 decimal placesdecimal separator = „.“000000000.00 Add up the 6 previous fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.