How to write FS [ Functional Specification ]
1. SO>LF>F2- Status : Sale order| Delivery |Invoice. Any Document number pass in ITEM
LEVEL
Solution: Sale Order number pass in VBAK and to get the Sale order number and we need to
pass in Delivery: LIPS- Reference document- Field – VGBEL so we get the delivery number
and pass in VBRP to get the Invoice number and Get the Status of Invoice.
2. Along with Status we require CITY| Postal Code| Email Id| Contact number.
Solution: We need to pass the Sale Order number in VBPA table and get the address
number and then pass to table ADRC to get the all the details of Postal code, Address and
City. But for Email Id we need to pass to ADR6 table
3. Require PO number, PO date and Payment terms.
Solution: We need to pass the SO to VBKD to get the Customer reference number,
Incoterm, Payment term, Exchange rate, Billing date.
4. Require Base Price, Condition type, Discount, TAX..etc.
Solution: In VBAK table we will get the Document Condition Number [ unique for every sale
document number] and this document condition number need to pass in table
‘PRCD_ELEMENTS’ we will get the condition types, take the Amount- ‘KBETR’ if equal to
PR00 - ‘KSCHIL’.
5. Require Material and Material Description.
Solution: SO/Invoice Number we need to pass VBAP/VBRP along with Item no: POSNR and
get the Material and Material Description.
ALSO, can get the material description in MAKT table
6. Require HEADER TEXT.
Solution: We need to pass the VBAK and to get the TEXT at Header level- TAX ID to Technical
team.
Z-Tcode: ZSALES
Selection screen (Input Screen)
Sales organization
Document date
Logic:
Sales order no: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN
Sales document date: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN
pass into VBAK-VBELN take sales document date VBAK- AUDAT
Sales org: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass into
VBAK-VBELN take sales org VBAK-VKORG
Dis Chan: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass into
VBAK-VBELN take Distribution Channel VBAK- VTWEG
Division: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass into
VBAK-VBELN take Division VBAK- SPART
Customer code: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass
into VBAK-VBELN take customer number VBAK-KUNNR
Customer name: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass
into VBAK-VBELN take customer number VBAK-KUNNR pass into KNA1-KUNNR take customer name
KNA1- NAME1
Customer City: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass
into VBAK-VBELN take customer number VBAK-KUNNR pass into KNA1-KUNNR take address number
KNA1-ADRNR pass into ADRC-ADRNR take City ADRC- CITY1
Material code: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass
into VBAP-VBELN take material VBAP-MATNR
Material name: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass
into VBAP-VBELN take material VBAP-MATNR pass into VBAP-MATNR take VBAP- ARKTX
Plant: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass into VBAP-
VBELN take material VBAP-MATNR pass into VBAP-MATNR take plant VBAP-WERKS
Qty: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass into VBAP-
VBELN take material VBAP-MATNR pass into VBAP-MATNR take quantity VBAP-KWMENG
Unit price: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass into
VBAK- VBELN take document condition no VBAK- KNUMV pass into KONV- KNUMV take KONV-
KBETR if KSCHL is equal to PR00
Total price: Qty * Unit price
Order status: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass into
VBUK-VBELN take order over all status VBUK- GBSTK
Delivery number: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass
the sales order number Into LIPS-VGBEL take delivery number LIPS-VBELN
Delivery date: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass the
sales order number Into LIPS-VGBEL take delivery number LIPS-VBELN pass into LIKP-VBELN take
delivery date LIKP- LFDAT
Delivery status: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN pass
the sales order number Into LIPS-VGBEL take delivery number LIPS-VBELN pass into VBUK-VBELN
take delivery status VBUK- GBSTK
Billing document number: Pass the sales org in VBAK -VKORG table get sales order number VBAK-
VBELN pass the sales order number Into LIPS-VGBEL take delivery number LIPS-VBELN pass into
VBRP-VGBEL take billing document number VBRP-VBELN
Billing document date: Pass the sales org in VBAK -VKORG table get sales order number VBAK-VBELN
pass the sales order number Into LIPS-VGBEL take delivery number LIPS-VBELN pass into VBRP-
VGBEL take billing document number VBRP-VBELN pass into VBRK -VBELN take billing document
date VBRK-FKDAT
Billing document status: : Pass the sales org in VBAK -VKORG table get sales order number VBAK-
VBELN pass the sales order number Into LIPS-VGBEL take delivery number LIPS-VBELN pass into
VBRP-VGBEL take billing document number VBRP-VBELN pass into VBUK-VBELN take billing over all
status VBUK- GBSTK
