Z-REPORTS

[Former Member]

hi

pls tel me wats the role of sd consultant in z reports

i know somewhat.

can anyone send me how to do them in realtime and giv me some examples.

regards

sridhar

[Former Member · Accepted solution]

Incase of Z report for SD, the SD consultant will require to provide the table & field name & the logic for linking the tables to meet the requirement.

A Sample is provided below & table joints provide the logic how to link the tables.

<b>Initial Screen</b>:

Fields | Table-Field | Remark | Table Joint

Sales Organization | VBAK-WAERK | Single Selection

Distribution Channel | VBAK-VTWEG | Multiple Selection

Division | VBAK-SPART | Multiple Selection

Sales office | VBAK-VKBUR | Multiple Selection

Sold to Party | VBPA-KUNNR | Multiple Selection | VBAK-VBELN=VBPA-VBELN

Material | VBAP-MATNR | Multiple Selection | VBAK-VBELN=VBAP-VBELN

WBS Element | VBAP-PS PSP PNR | Multiple Selection | VBAK-VBELN=VBAP-VBELN

Sales Order Type | VBAK-AUART | Multiple Selection

Billing Type | VBRK-FKART | Multiple Selection | VBAK-VBELN=VBFA-VBELV & VBRK-VBELN=VBFA-VBELN

Period

<b>Main Screen</b>:

Header

Sales Organization | VBAK-VKORG

Period

Item Level:

Sold-to-Party | VBPA-KUNNR where VBPA-PARVW = AG

Distribution Channel | VBAK-VKWEG

Division | VBAK-SPART

WBS Element | VBAP-PS_PSP_PNR

Sales Office | VBAK-VKBUR

Sales Doc type | VBAK-AUART

Sales Doc No | VBAK-VBELN

Material | VBAP-MATNR

Mat Desc | VBAP-ARKTX

Qty | VBAP-KWMENG

UOM | VBAP-MEINS

Doc Currency | VBAK-WAERK

Delivery No | LIKP-VBELN

Billing Document Type | VBRK-FKART

Billing Document No | VBRK-VBELN

Billing Document Line No | VBRP-POSNR

Quantity | VBRP-FKIMG

Price - Base Price

Price - Service Tax

Price - Education Cess

Price - VAT

Price - Other taxes

Price - Total

Accounting Document Number | BKPF-BELNR

Table Joints at Item Level:

VBAK-VBELN = VBPA-VBELN

VBAK-VBELN = VBAP-VBELN

VBAK-VBELN = VBFA-VBELV (For Delivery)

VBAK-VBELN = VBFA-VBELV

LIKP-VBELN = VBFA-VBELV

VBRK-VBELN = VBRP-VBELN

VBRK-XBLNR = BKPF-XBLNR

• some details are missing, please try to identify & use it as per your requirement.

Regards,

Rajesh Banka

Reward Points if Helpful

[Former Member]

This message was moderated.

[Former Member]

Dear Sridhar,

SAP has made own standard reports by studying various industries .Some time Client has different requirment which cannot be mapped by Standard SAP System.So as a SD Consutltant you have to modify the standard reports with additional Z reports.

Exa-Status Management will change as per client.You have to make a new Z*** Staus Profile to map particular industry requirment.

Hope you will clear about Z reports now.

With Best Regards,

Rajendra Sonawane

[Former Member]

hi

pls provide the ans for it

regards

sridhar

[Former Member]

Hi,

Z reports are created when the reporting requirement given by client can not be fulfilled with SAP standard report.

A functional consultant's role is to analyse the exact bussiness requirement for generating the desired report.Analyse the bussiness impact so you can determine the priority to develope the report.

Second thing is analyse the feilds and transactions from which the data is to be captured in report.After this you have to prepare functional specification which is to be given to ABAPer to develope the report.

Functional specs are nothing but giving linkage between tables and fields for the desired fields.Depending on this specs ABAPer will write the code.

Now for example If your customer wants a daily report of Taxes involved in the billing document,then SAP does not have a standard report for this so you will have to create a Z report for this requirement.

Reward points if useful

Regards,

Amrish Purohit

[Former Member]

Hi Sridhar,

U must viewed the list of reports provided by SAP in last reply.

My client required divison wise,customer wise,area wise sales report,so we prepared Z-reports for meetinfg these requirements,as these r not provided by SAP standards.

regards,

vandana

[Former Member]

hi vandana

thank u for the reply.

i am new to this forum. so i didn't see ur previous reply.

could u pls send me the spec u have given for the specified report.

regards

sridhar

[Former Member]

hi vandana

could u pls send me the zreports that u hav created.

regards

sridhar

[Former Member]

Hi

Pls refer below to create Z reports

Copy the program from the existing report, make the necessary changes like instead of picking the data from the condition table, pick the data from the KONV table/sales table.

Some of the Standard reports in SD are:

Sales summary VC/2

Display Customer Hierarchy VDH2

Display Condition record report V/I6

Pricing Report V/LD

Create Net Price List V_NL

List customer material info VD59

List of sales order VA05

List of Billing documents VF05

Inquiries list VA15

Quotation List VA25

Incomplete Sales orders V.02

Backorders V.15

Outbound Delivery Monitor VL06o

Incomplete delivery V_UC

Customer Returns-Analysis MC+A

Customer Analysis- Sales MC+E

Customer Analysis- Cr. Memo MC+I

Deliveries-Due list VL04

Billing due list VF04

Incomplete Billing documents MCV9

Customer Analysis-Basic List MCTA

Material Analysis(SIS) MCTC

Sales org analysis MCTE

Sales org analysis-Invoiced sales MC+2

Material Analysis-Incoming orders MC(E

General- List of Outbound deliveries VL06f

Material Returns-Analysis MC+M

Material Analysis- Invoiced Sales MC+Q

Variant configuration Analysis MC(B

Sales org analysis-Incoming orders MC(I

Sales org analysis-Returns MC+Y

Sales office Analysis- Invoiced Sales MC-E

Sales office Analysis- Returns MC-A

Shipping point Analysis MC(U

Shipping point Analysis-Returns MC-O

Blocked orders V.14

Order Within time period SD01

Duplicate Sales orders in period SDD1

Display Delivery Changes VL22

[Former Member]

hi, srdhar,

Z reports are created when the existing coding could not meet the requiremtn of the client, some time we achive the requiremtn of the client using standard includes provided by sap in various ares like for sales orders, delivery document, billing documents etc...and using these standard includes we cannot fill the gaps we find, then abapers create z reports writing the code.