ABAP QUERY PROGRAM OUTPUT SHOULD DISPLAY FROM SAP SCRIPT.

[Former Member]

THIS IS MY URGENT REQUIREMENT ...

I DONT KNOW ABAP QUERY PROGRAM ..

PLEASE SUGGEST ME A WAY ON THIS ....

Functional requirements

Introduction

The wish of the customer is a printable customer overview. All desired fields will be shown in a new query called ZZADDRSS_CO. Double entries are taken for granted because of the data taken from the sales area and because of multiple contact persons. The customer accepts this. It should be made possible that the user creates and saves its own variant.

A second overview is needed, another ABAP will be developed for this requirement. This ABAP will show all the customer data and this list will have the possibility to be printed.

Solution

New Query ZZADDRESS_CO

The desired fields of attachment 1 need to be shown in the query.

The selection criteria are shown in attachment 2.

The column names of the additional data have to changed in the query.

Customer Overview.

Functional specification.

On behalf of this customer overview a standard SAP transaction will be used (transaction VC/2).This transaction will be extended.

The fields are shown on screen with the described headers. Printing of the overview will be done via SAP script. The script makes use of a fixed layout of the data.

The selection criteria are specified in attachment 2.

The layout of the customer overview and the SAP Script are specified in attachment 3.

Specification.

The next steps need to be performed.

1. A routine per infoblock need to be created in Include RV77UNNN. In this routine the data is retrieved and written down to the screen and script,

Example LST1_901 . In include RV77SNNN you can find the standard infoblocks.

2. Adapt via transaction SE16 table TFRM.

3. Create a new view in the customizing (sales and distribution- Sales support-sales summary-Assign Reporting Views).Assign the new view to the infoblocks.(Example view 001 is assigned to block 901).

4. In customizing it is not possible to assign the correct window and element to the infoblock .so this is done via SE16 in table T182A.

5. Adapt script. Copy script SD-SALES-SUMMARY to a Z-SALES_SUMM.

Assign this new version to the new view in customizing. Create in the main window the element who writes the data on behalf of the print.

Attachment 1 Desired fields

Header: Address

~ Customer number KNA1-KUNNR

~ Title KAN1-ANRED

~ Name1 ADRC-NAME1

~ Name2 ADRC-NAME2

~ Name3 ADRC-NAME3

~ Name4 ADRC-NAME4

~ PO Box ADRC-PO_BOX

~ PO Box POSTAL CODE ADRC-POST_CODE2

~ PO Box city ADRC-PO_BOX_LOC

~ Telephone no1 ADR2-TEL_NUMBER 1ST RECORD

~ Telephone no2 ADR2-TEL_NUMBER 2ND RECORD

~ Fax number1 ADR3-FAX_NUMBER 1ST RECORD

~ Fax number2 ADR3-FAX_NUMBER 2ND RECORD

~ E-mail ADR6-SMTP_ADDR

~ Search item ADRC-SORT1

~ Notes ADRT-REMARK

Header: control data

~ VAT registration number KAN1-STCEG

Header: Payment transactions

~Bank country key KNBK-BANKS

~Bank key KNBK-BANKL

~Bank Account number KNBK-BANKN

Header: Marketing

~ Industry key KNA1-BRSCH

~ Industry code 1 KNA1-BRAN1

~ Industry code 2 KNA1-BRAN2

~ Industry code 3 KNA1-BRAN3

~ Industry code 4 KNA1-BRAN4

~ Industry code 5 KNA1-BRAN5

~Annual sales, currency, year KNA1-UMSA1, KNA1-UWAER, KNA1-UMAH

~ Yearly no of employees, year KAN1-JMZAH, KNA1-JMJAH

~ Fiscal year variant KNA1-PERIV

~Legal status KNA1-GFORM

Header: Correspondence

~ Our account number at customer KNB1-EIKTO

Header: sales

~ Sales office KNVV-VKBUR

~ Customer group KNVV-KDGRP

~ ABC-classification KNVV-KLABC

Header: Invoice

~Tax classification KNVI-TAXKD

~Terms of payment key KNVV-ZTERM

~

Header: Contact Persons

~Title KNVK-ANRED

~Name KNVK-NAME1

~Advertising material KNVK-NMAIL

~Martial Status KNVK-FAMST

~Notes KNVK-PARAU

~Function KNVK-PAFKT

~Department KNVK-ABTNR

Header: Partnerroles

~Personnel Number KNVP-PERNR

~Name of employee PA0001-ENAME

Header: Additional Data

~Attribute 1 KNA1-KATR1

~Creation date KNA1-ERDAT

~Attribute 2 KNA1-KATR2

~Change date of field KNA1-KATR2 CDHDR-UDATE

~Attribute 3 KNA1-KATR3

~Attribute 4 KNA1-KATR4

~Attribute 5 KNA1-KATR5

~Attribute 6 KNA1-KATR6

Attachment 2 Selection fields

~Customer number

~Sales office

~Personnel Number

~Sales Organization (default NL01)

~Industry key

~Industry codes (1 till 5)

~ABC- classification

~Creation date

~Attribute 1

~Attribute 2

~Attribute 3

~Attribute 4

~Attribute 5

Attachment 3 Customer overview + SAP Script

Customer master data sheet: 11490 Page1

Requested by karen Dunnewold Date: 25.08.2004

Address

(Default SAP script ADDRESS statement)

Title

Name1

Street + number

PO Box city

Country

Search term: ADRC-SORT1

Telephone 1: ADR2-TEL_NUMBER 2: ADR2-TEL_NUMBER

Fax 1: ADR3-FAX_NUMBER 2: ADR3-FAX_NUMBER

E-mail: ADR6-SMTP_ADDR

Notes: ADRT-REMARK

PO BOX

ADRC-PO_BOX

ADRC-POST_CODE2 ADRC-PO_BOX_LOC

T005T-LANDX (T005T-LAND1 = ADRC-COUNTRY)

Control data

VAT registration number: KNA1-STCEG

Payment transactions

Country: KNBK-BANKS Bank-key: KNBK u2013 BANKL Bank account: KNBK-BANKN

Marketing

Industry KNA1-BRSCH Industry Description

Industry code1 KNA1-BRAN1 Industry Description

Industry code2 KNA1-BRAN2 Industry Description

Industry code3 KNA1-BRAN3 Industry Description

Industry code4 KNA1-BRAN4 Industry Description

Industry code5 KNA1-BRAN5 Industry Description

Figures

Annual Sales KNA1-UMSA1, KNA1-UWAER in KNA1-UMAH

Employees KNA1-JMZAH in KNA1-JMJAH

Legal status KNA1-GFORM description

Customer master data sheet 11490 Page 2

Requested by karen Dunnewold Date: 25.08.2004

Contact Persons

KNVK-ANRED

Mailings: KNVK-NMAIL Notes: KNVK-PARAU

KNVK-ANRED

Mailings: KNVK-NMAIL Notes: KNVK-PARAU

Correspondence

Our account number at customer KNB1-EIKTO

Sales

Sales office KNVV-VKBUR Description

Customer group KNVV-KDGRP Description

ABC-classify KNVV-KLABC

Currency KNVV-WAERS

Invoice

Terms of payment key KNVV-ZTERM Tax classification KNV1-TAXKD

Description

Partner (Leave SAP default)

Partnerrole Number Name

KNVP-PARVW KNVP-KUNNR NAME1

KNVP-PARVW KNVP-KUNNR NAME1

Additional data

Attribute1 kna1-katr1 Description

Attribute2 kna1-katr2 Description

Attribute3 kna1-katr3 Description

Attribute4 kna1-katr4 Description

Attribute5 kna1-katr5 Description

Attribute6 kna1-katr6 Description

[Former Member]

hi narayana

i think u need to write a driving program and a provided with a smatform u sit along with the SD consultant.

ur further views can be shared.

Rgs,

Venkat.

[Former Member]

So you want someone to do your work for you?

If you don't know what to do go back to your client/team lead/functional consultant and tell them and ask for help.

Gareth.