SAP ABAP中文资料Technical_Specification_example_【51SAP教育中心】

Technical Specification

Description: Author: Issue: Module: Creation Date:

Create the delivery detail list 03/08/2004 CN04 SD

Roger

Change History Reference LCJS-66EAWR LCJS-693ABQ Developer Date Roger Roger 13/12/2004 Description Change the output format sub-total on quantity and amount column Objects Changed Program: ZCNSD_DELIVERY_DETAIL Program: ZCNSD_DELIVERY_DETAIL 28/01/2005 LCJS-6AA4BC THOO-6CHAYA LCJS-6CR9A3 Roger Roger Roger 08/03/2005 19/05/2005 26/05/2005 Remove column unit Program: price include tax ZCNSD_DELIVERY_DETAIL Revise delivery detail list Transport the selection screen text Added simplified format Program: ZCNSD_DELIVERY_DETAIL Program: ZCNSD_DELIVERY_DETAIL Program: ZCNSD_DELIVERY_DETAIL THOO-6D4C37 THOO-6D4C37 D.Tiongco D.Tiongco 10.08.2005 29.08.2005 Additional Program: requirement; ZCNSD_DELIVERY_DETAIL Display the actual goods movement date, LIKP-WADAT_IST, instead of the delivery date. Dependent Developments (Where applicable)

Objectives CGL prints invoice collectively at the end of every month. Since the item printed on invoice is one single line item , CGL needs to attach an additional detail list to each invoice to let the customers know what they are charged for

126048425.doc

Page 1 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

Program Usage To execute follow the menu path below

It is used to print delivery detail information

Object List Additional Object Name zcnsd_delivery_detail Object Type report Description Delivery detail list Pre-conditions (Source of Inputs) Selection screen

126048425.doc Page 2 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

Selection screen parameters

Field name S_vbeln S_fkdat S_kunrg P_bukrs P_waerk P_thread P_zip P_deli P_po P_detail p_total P_del P_inv Type vbrk-vbeln vbrk-fkdat vbrk-kunrg t001-bukrs vbrk-waerk radiobutton radiobutton radiobutton radiobutton radiobutton radiobutton Radiobutton Radiobutton Description Invoice Document number Billing Date Payer Company Currency Thread plant Zip plant Sub-total by PO Detail mode Group mode Delivery detail list Invoice detail list Default RMB ‘X’ ‘X’ ‘X’ Sub-total by delivery ‘X’ Results

Delivery detail List- see attachment Delivery Detail List.HTM

126048425.doc

Page 3 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

Invoice detail list – see attachment Invoice Detail List.HT

Internal table T_delivery

Field Name Type Description matnr_color_cust C(62) Material color customer matnr_color C(30) Material color group matnr vbrp-matn material kondm vbrp-kondm color group vgbel vbrp-vgbel delivery number aubel vbrp-aubel sale order numbe Aupos Vbrp-aupos item number Fbuda Vbrp-fuda invoice date Bstkd Vbkd-bstkd customer material number artkx Vbrp-arktx material description Fkimg Vbrp-kimg invoice quantity Cmpre Vbrp-cmpre net price Netpr Vbrp-netwr net price without tax Netwr Vbrp-netwr amount without tax Mwsbp Vbrp-mwsbp tax value Amount Vbrp-netwr amount with tax Werks Vbrp-werks Plant kunrg Vbrk-kunrg payer Waerk vbrk-waerk Currency Umvkz vbrp-umvkz Unit conversion Umvkn vbrp-umvkn Unit conversion Vrkme vbrp-vrkme unit Meins vbrp-meins Base unit Name1 kna1-name1 name Stras kna1-stras street Name2 kna1-name1 Name2 Telf1 kna1-telf1 Telephone Orto1 kna1-ort01 district Land1 kna1-land1 Country 126048425.doc

Page 4 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

Landx Pstlz t005t-landx kna1-pstlz kna1-telfx country Postal code Telfx Stceg Str_suppl3 Lenshade Vbeln Zuonr fkdat brgew ntgew kdmat pack_no gewei Fax number Vat number Street4 Length and shade for zip Invoice number Vat invoice numbe billing date gross weight net weight customer material packing list number unit of weight kna1-stceg adrc-str_suppl3 C(30) Vbrk-vbeln Bseg-zunor vbrk-fkdat lips-brgew lips-ntgew lips-kdmat ysd_packdel_item-pack_no lips-gewei Main Prcoessing

1. START OF SELECTION

FORM Select_Data

There are two output format in the program, one is delivery detail list, the other is invoice detail list.

It will select data from the table vbrk and vbrp and not considered cancelled invoice. in delivery detail list (p_del = ‘X’ ) it only consider the invoice document type F2, otherwise F2, G2 and RE will be included, The selected data is put into internal table t_delivery. Base on t_delivery data,

 Get customer material, gross weight and net weight from table lips by delivery

and item number  Get packing list number from table ypp_delnote_item by delivery number and

item number  get customer address detail data from table kna1 and address table by customer

account  get VAT invoice number bseg-zunor from bseg by billing document number  get the material pricing group description from t178t for grouping by color group

purpose.  Get the country description from t005t by billing country

 Call READ_EXCHANGE_RATE function to get exchange rate if billing currency

126048425.doc

Page 5 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

is different from entered selection criteria currency

 Vbrp-netwr and Vbrp-cmpre is calculated base on the exchange rate result.  Select purchase order from vbkd according to the reference sales order number

in each billing item.  if v_zip radio button is selected (true value) , run subroutine get_length_shade to

get length and shade by using VC_I_GET_CONFIGURATION function

FORM GET_LENGTH_SHADE

 Get the cuobj object number from delivery item detail. The value of cuobj is used

to call function ‘VC_I_GET_CONFIGURATION’ function to get length and shade value.

if p_detail is true, run subroutine write_data_detail if p_total is true, run subroutine write_data_group 2. END OF SELECTION

FORM WRITE_DATA_DETAIL

 List out each line item from t_delivery internal table. if p_deli is true, at the end of

delivery note, sub-total the quantity and amount, else sub-total the quantity and amount at the end of purchase order number. if p_zip is true, display length and shade  If p_deli = ‘X’, sort internal table t_delivery by delivery number, and calculate the

total for each delivery number  If p_po = ‘X’, sort internal table t_delivery by customer purchase order, and

calculate the total for each customer PO

FORM WRITE_ITEM

 Print report item, if p_inv = ‘X’, the tax and total amount column will not be

showed FORM WRITE_TOTAL_LINE

 Print total line for each customer PO or delivery note, if p_inv = ‘X’, the tax

and total amount column will not be showed FORM WRITE_TOTAL_ALL_LINE

 Print total line for each customer, if p_inv = ‘X’, the tax and total amount

column will not be showed

FORM WRITE_DATA_GROUP

 List out each line item from t_delivery internal table base on material number

and material color group sorting.

FORM WRITE_TOTAL_LINE_GROUP  Print total line for each customer

126048425.doc

Page 6 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

3. TOP OF PAGE

 Header information will be different depends on the v_detail value

FORM WRITE_HEADER_DETAIL

 Print report column header for detail format, if p_inv = ‘X’, the tax and total

amount column will be hidden FORM WRITE_HEADER_GROUP

 Print report column header for group format

Additional change : LCJS-66EAWR Dated: 13/12/2004  Change the output format, keep consistent with coats standard  Format Quantity field with corresponding unit variant  Format amount field with corresponding currency unit

Additional changes: LCJS-693ABQ Dated: 28/01/2005  add two sub-total on quantity and amount column by delivery note number or PO number

Additional changes: LCJS-6AA4BC Dated: 08/03/2005  Remove column of unit price include tax

Additional changes: THOO-6CHAYA Dated: 19/05/2005  modify the format of delivery detail list

o add billing date(vbrp-fkdat), invoice no(vbrk-vbeln)., sale order number(vbrp-aubel),item number(vbrp-aupos), customer material number(lips-kdmat), packing list(ypp_delnote_item-pack_no),gross weight(lips-brgew), net weight(lips-ntgew), unit field(vbrp-vrkme).

 add invoice detail list , which format is same as delivery

o detail list except following points:

include credit memo(billing type G2 and RE) remove tax column

Additional changes: LCJS-6CR9A3 Date 26/05/2005  Transport the selection screen text

Testing invoice number 2000001144, Company code: HK10

126048425.doc

Page 7 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

Invoice number 2000000981, Company code:CN20

Additional changes: THOO-6D4C37, DJDT 10.08.2005

Program:

ZCNSD_DELIVERY_DETAIL

I added a simplified format which excludes the item number, customer material, packing list number, gross and net weights. Also, extended the purchase order display length from 15 to 18.

Testing Run the program ZCNSD_DELIVERY_DETAIL thru transaction code SA38. Use variant THOO-6D4C37. Toggle between simplified and detailed formats. Check the column alignment of the record and total lines.

126048425.doc

Page 8 of 9

SAP问答：http://www.sapzhidao.com SAP培训：http://www.51sap.cn

Additional changes: THOO-6D4C37, DJDT 29.08.2005

Program:

ZCNSD_DELIVERY_DETAIL

Additional requirement; Display the actual goods movement date, LIKP-WADAT_IST, instead of the delivery date.

126048425.doc Page 9 of 9