specification

Former Member — Tue, 18 Sep 2007 08:06:17 GMT

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.

Object Type Original Name How Manipulated

Layout Set N/A

Window

Program Symbol

1.9 SAPscript:

1.10 External Files Used

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

Error Condition Error Result/Message Error Resolution

1.13 Key Technical 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

1.16 Comments

Check the Excel sheet for issues to be clarified

Re: specification

Former Member — Tue, 18 Sep 2007 08:07:20 GMT

and my mail id venugopal_p84@yahoo.com

topic Re: specification in Application Development and Automation Discussions

specification

Re: specification