Skip to Content
0
Former Member
Nov 17, 2006 at 05:42 AM

new design

78 Views

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.