7/30/2019 SPEC10_ Pre-Sales Register

1/12

Functional Specification Document:Development ID: FS_TS_SD_REP_003

Pre-Sales Register

SD

R Sengupta

Version 1.0 18/12/2007 Submission of 1st version R Sengupta SD PwC

1.0 27/12/2007 Technical Specification Arnab Mandal ABAP PwC

Page 1 of 12

7/30/2019 SPEC10_ Pre-Sales Register

2/12

I. DOCUMENT PUR POSE : ..................................................................................................................................................3

II. OPTIONS CONSIDERED: .................................................................................................................................................3

III. DESCRIPTION OF GAP RESOLUTION: ......................................................................................................................3

IV. FIELD MAPPING .............................................................................................................................................................3

V. INPUT SELECTION SCREEN & OUTPUT LAYOUT: .................................................................................................6

VI. SAP SCRIPT SPECIFICATION: .............................................................................................................................. .......7

VII. CUSTOM TRANSACTION / MODULE SPECIFICATION: ............................................................................... .......8

VIII. PROGRAM/OBJECT DETAIL: ............................................................................................................................. .......8

IX. PROCESS/PROGRAM LOGIC: ......................................................................................................................... ...... .......8

X. ERROR HANDLING AND VALIDATIONS:NA .............................................................................................................9

XI. CUSTOM DATA DICTIONARY OBJECTS:NA ...........................................................................................................9

XII. SAPSCRIPT TECHNICAL SPECIFICATION:NA ............................................................................................. ...... .10

XIII. CUSTOM TRANSACTION / MODULE POOL TECHNICAL SPECIFICATION:NA ................................ ...... .11

< SCREEN HEADER INFORMATION. TOBEFILLEDBY TECHNICAL RESOURCE> ............................................................................. ...... .11

..............................................................................................11

XIV. USER EXIT / ENHANCEMENT TECHNICAL SPECIFICATION:NA .................................................. ..............11

< TABLE EXITS. TOBEFILLEDBY TECHNICAL RESOURCE> ............................................................................................... ..............12

Page 2 of 12

7/30/2019 SPEC10_ Pre-Sales Register

3/12

Standard SAP does not provide a Pre-Sales Register in the way ECL & LIL generates the same

Since, this is not possible through standard SAP in a manner, which suits the need of ECL & LIL, a development

is the only option.

An ALV Report design which will be triggered after a Pre-Inquiry/Inquiry/Quotation has been created in the

system. Data Flow Diagram:

Fields in the table will be as mentioned above -

01 DocumentType

02 Document

Type Name

Pick-up the document type fromVBAK-AUART

03 Document

No04

Valid From

05Valid To

06 Documentdate

07

Sold-to-

Party Code

08 Sold-to-Party name

Page 3 of 12

7/30/2019 SPEC10_ Pre-Sales Register

4/12

09

Payer Code

10Payer Name

11

Country

12

Region

13Ref Doc No

14 Ref DocDate

15

Scheme No

16 SchemeName

17 Source ofFund

18Schemevalue

19

Currency

19

20 MaterialGroup

21 MaterialCode

22 Materialdescription

23Quantity

24

Sales Unit

25Quantity

26Base Unit

27

Basic price

Page 4 of 12

7/30/2019 SPEC10_ Pre-Sales Register

5/12

28 Doc

Currency29 Exchange

Rate30 Value in

Local

Currency

31 LocalCurrency

BED

ECS

S.E-Cess

VAT

CST

InspectionCharges

Gross value

Mat Pricing

Group

Usage

Page 5 of 12

7/30/2019 SPEC10_ Pre-Sales Register

6/12

Page 6 of 12

VBAK- KUNNR

7/30/2019 SPEC10_ Pre-Sales Register

7/12

A New transaction Z_PRESALES_REGISTER needs to be created.

Table:Screen:

Page 7 of 12

7/30/2019 SPEC10_ Pre-Sales Register

8/12

Table:Screen:

The selectionscreen has 4ranges :SO

Date,SO Customer,Division and Maetrial of which only Date is mandetory.There are 2obligatory parameters :sales organisation and distribution channel.

According to the selection criterion given,first Sales Document header data are fetched fromVBAK and Item Data are fetched from VBAP.Document Type Description is fetched fromTVAK.Then Sold-to-party and Payer data are fetched form VBPA and KNA1.Scheme Details areobtained from KNVV.Also the Pricing Details are fetched from KONV.

All these header and item data are now merged to form an internal table to dispaly the list ofdocuments in ALV.

Page 8 of 12

YSD_PRESALES_REGISTER

Executable

Customer Production Program

SD

YDSD

YPRESALES

NA

VBAK,VBAP

NA

NA

7/30/2019 SPEC10_ Pre-Sales Register

9/12

The code is attached below-

X.

XI.

Page 9 of 12

7/30/2019 SPEC10_ Pre-Sales Register

10/12

XII.

7/30/2019 SPEC10_ Pre-Sales Register

11/12

XIII.

7/30/2019 SPEC10_ Pre-Sales Register

12/12

< Table Exits