specification

[Former Member]

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 Name:

Development Class:

Message Class:

Program Type: Executable

Program Location:

Development Type:

(List Report, SAPscript) Report

Processing Type:

(Batch, BDC, IDOC, real-time, near real-time etc.)

Frequency:

Trigger:

Volume:

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 PBED_{BDZEI = PBIM BDZEI FOR ALL ENTRIES IN IT_MARC WHERE PBIM}MATNR = 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 VBAP_{VBELN = VBUP}VBELN AND

VBAP_{POSNR = VBUP}POSNR FOR ALL ENTRIES IN IT_MARC WHERE VBAP~MATNR =

IT_MARC_{MATNR AND VBUP}GBSTA <> ‘C’.

7. LOOP AT IT_MARC.

Read the details and display the report.

END LOOP.

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

Window

Program Symbol

1.9 SAPscript:

<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

1.15 Assumptions

<Assumptions if any, if any of the above details are incomplete>

1.16 Comments

Check the Excel sheet for issues to be clarified

[Former Member]

and my mail id venugopal_p84@yahoo.com