Skip to Content
0
Former Member
Jul 12, 2007 at 09:41 AM

I Need A Clasical Report For The Following Specification Plz

27 Views

With out Using any ALVS .

SALESORDER REPORT

TABLES : VBAK,

VBAP,

KNA1.

INPUT FIELDS : Sales Document (RANGE)----


(vbak-vbeln)

Document Date (Date Received/Sent).(RANGE)----


(vbak-audat)

Sold-to party (PARAMETERS)----


(kna1-kunnr)

O/P FIELDS :

Sales Document----


(vbak-vbeln)

Document Date (Date Received/Sent)----


(vbak-audat)

Sales Document Item----


(vbap-posnr)

Short text for sales order item----


(vbap-arktx)

Material Number----


(vbap-matnr)

Cumulative order quantity in sales units----


(VBAP-KWMENG)

Requested delivery date----


(VBAP-CMKUA)

CUSTMER NUMBER(Sold-to party) -


(kna1-kunnr)

CUSTMER NAME -


(KNA1-NAME1)

CUSTMER CONTRY----


(KNA1-LAND1)

Net Value of the Sales Order in Document Currency----


(VBAK-NETWR)

Sales Organization----


(VBAK-KORG)

Name of Person who Created the Object----


(VBAK-ERNAM)

================================================================================

VBAK :

(KNA1-KUNNR)

Sales Document----


(VBAK-VBELN)

Document Date (Date Received/Sent)----


(VBAK-AUDAT)

Net Value of the Sales Order in Document Currency----


(VBAK-NETWR)

Sales Organization----


(VBAK-KORG)

Name of Person who Created the Object----


(VBAK-ERNAM)

VBAP:

Sales Document Item----


(VBAP-POSNR)

Short text for sales order item----


(VBAP-ARKTX)

Material Number----


(VBAP-MATNR)

Cumulative order quantity in sales units----


(VBAP-KWMENG)

Requested delivery date----


(VBAP-CMKUA)

KNA1:

CUSTMER NUMBER(Sold-to party) -


(KNA1-KUNNR)

CUSTMER NAME -


(KNA1-NAME1)

CUSTMER CONTRY----


(KNA1-LAND1)

====================================================================================================

TABLES : VBAK,

VBAP,

KNA1.

INPUT FIELDS : Sales Document (RANGE)

Document Date (Date Received/Sent).(RANGE)

Sold-to party (PARAMETERS)

O/P FIELDS :

Sales Document ....... VBAK-VBELN

Document Date (Date Received/Sent).....VBAK-AUDAT

CUSTMER NUMBER(Sold-to party)................VBAK-KUNNR

Net Value of the Sales Order in Document Currency.....VBAK-NETWR

Sales Organization......................................................VBAK-KORG

Name of Person who Created the Object..................VBAK-ERNAM

Sales Document Item ...............VBAP-POSNR

Short text for sales order item..........VBAP-ARKTX

Material Number.............................VBAP-MATNR

Cumulative order quantity in sales units............VBAP-KWMENG

Requested delivery date.................VBAP-CMKUA

CUSTMER NAME..................KNA1-NAME1

CUSTMER CONTRY..........................KNA1-LAND1