hi to all iam learning abap sorry to ask this type of questions can u expalin the following specification .
i got a job as fresher in sap-abap . i want to know how the specs are that why i asked to explain this spec
pls give me the over view i.e what is the purpose of this report what is the business flow in this pec
pls find the spec below
1 TECHNICAL SPECIFICATIONS REPORT
1.1 Development Attributes
Program ID: ZSDRM014
Program Type: Executable
(List Report, SAPscript) Report
(Batch, BDC, IDOC, real-time, near real-time etc.)
1.2 Program Description
Entegris supply chain staff are keenly aware of the need to keep inventory levels as low as possible to manage costs and operate in a lean manner. With this in mind, they currently use various SAP reports to track inventory. None of these reports provide good visibility to inventory being built or scheduled to be built.
With this in mind, Entegris supply chain staff would like to create a report showing projected inventory builds vs. historical consumption, to be used as an analysis tool to identify possible exception situations.
1.3 High Level Processing Logic
1. Get materials from MARC with the selection criteria where MATNR IN S_MATNR AND DISPO IN S_DISPO AND DISGR IN S_DISGR AND PRCTR IN S_PRCTR.
2. Get consumption details for the last 30 days from MSEG for the selected materials and MKPF-BUDAT is between current date 30 and current date and the movement type is 261, 262, 601 or 602.
SELECT MENGE FROM MSEG FOR ALL ENTRIES IN IT_MARC WHERE MATNR = IT_MARC-MATNR AND BWART IN (261,262,601,602) AND MKPF-BUDAT BETWEEN SY-DATUM 30 AND SY-DATUM.
3. Get the quantity of the currently open production orders from the view CAUFV with the AUTYP = 10 and STLBEZ = selected materials. (To get the open orders check CAUFV-GETRI(Confirmed date) = space )
SELECT GAMNG FROM CAUFV FOR ALL ENTRIES IN IT_MARC WHERE AUTYP = 10 AND GETRI = SPACE AND STLBEZ = IT_MARC-MATNR.
4. Get the quantity of the planned orders from PLAF for the selected materials
SELECT GSMNG FROM PLAF FOR ALL ENTRIES IN IT_MARC WHERE MATNR = IT_MARC-MATNR
5. Get the monthly forecast from PBED and PBIM for the current month
SELECT PLMNG FROM PBED INNER JOIN PBIM ON PBEDBDZEI = PBIM BDZEI FOR ALL ENTRIES IN IT_MARC WHERE PBIMMATNR = IT_MARC-MATNR AND PBED~PDATU in Current Month.
6. Get the Open sales order quantity from VBAP for the selected materials. ( to get the open sales order check VBUP-GBSTA(Over all status) <> C.
SELECT ZMENG FROM VBAP INNER JOIN VBUP ON VBAPVBELN = VBUPVBELN AND
VBAPPOSNR = VBUPPOSNR FOR ALL ENTRIES IN IT_MARC WHERE VBAP~MATNR =
IT_MARCMATNR AND VBUPGBSTA <> C.
7. LOOP AT IT_MARC.
Read the details and display the report.
8. On double Click on a row, Display the Production Ordesr, Production Order Quantity , Planned Orders and Planned Order Quantity for the selected row.
If value is entered on the Difference Quantity field on the selection screen, Restrict the output with the entered percentage difference.
1.4 Sorting Sequence / Summing Requirements
1.5 Selection Screen Fields
Label Type, Parameter or Select-Option Related DDIC field Default Value Required /Optional Validation/Field Edits/Check table/Matchcode
MRP Group Select-option T438M-MTART
Profit center Select-option CEPC-PRCTR
Material number Select-option MARA-MATNR
MRP Controller Select-option T024D-DISPO
Difference Quantity(%) Parameter
1.6 Output Fields
Output Label Related SAP table-field (if any) Length Output Characteristics
MRP Group MARC-DISGR
Profit center MARC-PRCTR
MRP Controller MARC-DISPO
Material number MARC-MATNR
Last 30 days of consumption MSEG-MENGE
Total quantity of currently open production orders CAUFV-GAMNG
Total quantity of planned production orders PLAF-GSMNG
Difference (column 6 + column 7 column 5)
Monthly forecast for the current month PBED-PLMNG
Total quantity of currently open sales orders VBAP-ZMENG
Fixed lot quantity for the material MARC-BSTFE
Safety stock for the material MARC-EISBE
1.7 Database Tables Used
Table/Database Name Table/Database Description Read (Y/N) Update (Y/N) Key Fields How the table is used in the program
MDKP Y N
MARD Y N
1.8 SAPscript: Identify SAPscript existing objects/elements directly manipulated in this development.
<SAPscript objects here can include Layout Sets, Styles, Fonts, Texts, Windows, Page Windows, Symbols, Text Elements >
Object Type Original Name How Manipulated
Layout Set N/A
<How are the above changes used to deliver the desired output?>
1.10 External Files Used
<For example, if this report automatically writes to file>
File Name File Description Usage
1.10.1 External File Layout <file name>
Field Name Key Declaration Description
1.11 Components External to Program Used
Component Location Component Name Component Description/Usage
1.12 Error Conditions
<Detailed error conditions useful for testing the functionality of the developed process On-site>
Error Condition Error Result/Message Error Resolution
1.13 Key Technical Test Conditions
<Test data including the expected output result. Should also include various input test conditions>
Num Test Condition Expected Results
1.14 Sample Test Data
Field Value Set 1 Value Set 2 Value Set 3
<Assumptions if any, if any of the above details are incomplete>
Check the Excel sheet for issues to be clarified