The below fields are required for selection criteria and report columns
Dynamic-- Report to show line item data of rejected lines o Order type - S & O --VBAK- AUART o Document date (provide range for selection criteria) - S & O --VBAK- AUDAT Creation Time o Sold to customer number - S & O --VBAK- KUNNR o Sold To Name – O KUNNR into KNA1 and get NAME1 o Sold To address – O -- KUNNR into KNA1 and get ADDRESS
o Local chain number - S & O Pass Sold to KNVH – where Customer hierarchy type KNVH- HITYP is “A” and Hierarchy assignment KNVH-HZUOR is “1” & find KNVH- HKUNNR o Local chain name - O Pass chain number in KNA1 and find NAME1 o SAP quote number S & O --VBAK- VBELN o Customer PO number S & O -- VBKD-BSTKD o Sales Office S & O --VBAK- VKBUR o sales group customer is associated to - S& O --VBAK- VKGRP o Product number rejected S& O --VBAP- MATNR o Product name rejected - O --VBAP- ARKTX o Quantity ordered – O --VBAP- KWMENG o Material Status – S & O --Get material and plant from VBAP table and pass in MARC table to field MARC- MMSTA
o Material status description O o Rejected information (rejection code) – S&O o Plant S & O --VBAP- WERKS o plant name O o Pass WERK into table T001W and get “NAME1 of PLANT
o Email recipient --Multiple email ids option S & O From: SAP BATCH Subject: Chain name & execution date Excel Attachment with dynamic fields according to the output.
thanks for such a informative list appreciated keep it up see sap community network about the latest news.
ReplyDeletethax u very much sir..its very use for me.where i learn SAP ABAP Basis.
ReplyDelete2.6.1 Reports
ReplyDeleteThe below fields are required for selection criteria and report columns
Dynamic--
Report to show line item data of rejected lines
o Order type - S & O
--VBAK- AUART
o Document date (provide range for selection criteria) - S & O
--VBAK- AUDAT
Creation Time
o Sold to customer number - S & O
--VBAK- KUNNR
o Sold To Name – O
KUNNR into KNA1 and get NAME1
o Sold To address – O
-- KUNNR into KNA1 and get ADDRESS
o Local chain number - S & O
Pass Sold to KNVH – where Customer hierarchy type KNVH- HITYP is “A” and Hierarchy assignment KNVH-HZUOR is “1” & find KNVH- HKUNNR
o Local chain name - O
Pass chain number in KNA1 and find NAME1
o SAP quote number S & O
--VBAK- VBELN
o Customer PO number S & O
-- VBKD-BSTKD
o Sales Office S & O
--VBAK- VKBUR
o sales group customer is associated to - S& O
--VBAK- VKGRP
o Product number rejected S& O
--VBAP- MATNR
o Product name rejected - O
--VBAP- ARKTX
o Quantity ordered – O
--VBAP- KWMENG
o Material Status – S & O
--Get material and plant from VBAP table and pass in MARC table to field MARC- MMSTA
o Material status description O
o Rejected information (rejection code) – S&O
o Plant S & O
--VBAP- WERKS
o plant name O
o Pass WERK into table T001W and get “NAME1 of PLANT
o Email recipient --Multiple email ids option S & O
From: SAP BATCH
Subject: Chain name & execution date
Excel Attachment with dynamic fields according to the output.
*S = Selection screen
*O = Output screen
anybody please do the program.
ReplyDeletearyan.ad007@gmail.com(send here)
Very nice site. Regards Pranay Sahay
ReplyDeletegood work done
ReplyDelete