Skip to Content
0
Former Member
Jul 12, 2006 at 04:34 AM

What can be the Tech design for the following functional points

48 Views

Hi All,

What can be the Technical Design preparation for the below Functional Design Points!

<b>1. Search table Z100

Select all records where

Status (Z100-ZSTATUS) = “G”

Date (Z100-ZDATE ) = current month minus 1

Total price (Z100-ZTOTPR) => $5000.

Select Z100-MATNR

List Z100-MATNR and ZTOTPR</b>

<b>2. Then, for each MATNR, list all equipment records where

Equipment type (EQUI-EQTYP) = “S”

List Material (EQUI-MATNR)

WBS (EQBS-PS_PSP_PNR)

UID (EQUI-UIINR)

Serial Number (EQUI-SERNR)</b>

<b>3. Then compare the equipment record WBS (EQBS-PS_PSP_PNR) to the Contract Line Item WBS (VBAP-PS_PSP_PNR)

From VBAP, select the Sales Document (VBAP-VBELN) and Contract Line Item (VBAP-POSNR)</b>

<b>4. Then compare the Sales Document on VBAP (VBAP-VBELN) to the Sales Document on VBAK (VBAK-VBELN).

From VBAK, select the UID indicator (VBAK-UID) and Contract Number (VBAK-BSTNK).</b>

<b>5. If VBAK-UID is initial, go no further. No entry is required to the table.

If VBAK-UID is not initial;

Create 3 new rows on table Z200</b>

<b>6. Select the UID number EQUI-UIINR

If no record exists in table with UID number, create three new rows in table Z200 populate fields per the following table mapping. The table mapping shows “default” values, or sources in SAP, and parameters if needed. </b>

Can anybody tell me what is the technical design we can write for above finctional design.

Thanks in advance.

Thanks & Regards,

Prasad.