cancel
Showing results for 
Search instead for 
Did you mean: 

tables names for below items

Former Member
0 Kudos

HI All,

i want the table names for below items :

customer number , customer name , slaes order number , item , quantity , tottal value and schedule date.

i need to select these items. any body pls tell me the table names .

Regards,

pandu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Pandurangarao,

For your future requirements,

You may also check the same (i.e. Table Name/ Field Name/ Program Name/ Screen Field) by yourself.

There are few requirements:

1. You have to decide from where (i.e. Document..???, say Sales Order in VA02) you want to fecth the data for your requirement.

2. Go in to that document (say, you wanna all data to be fetch from Sales Order; then VA02).

3. Click one within the field and Press F1. This will open an Overview window. In to the same window, down there, you will find on e Tab: Technical Information. Click the Tab.

4. Now, you may get all technical informations for your inputs.

Best Regards,

Amit

Answers (4)

Answers (4)

Former Member
0 Kudos

165 unresolved unresolved questions!! And now still asking this one...

My recommendation to all is not to answer such questions, asked by such people...

Former Member
0 Kudos

Dear,

Field Name = Table Name = Name

KUNNR = RF02D = Customer Number

NAME1 = ADDR1_DATA = Customer Name

VBELN = VBAK = Sales Order

POSNR = VBAP = Item

KWMENG = RV45A = Quantity

NETWR = KOMP = Total Value

PRGBZ = RV45A = Schedule Line

Regards,

Sandip Shaktavat

Former Member
0 Kudos

Hi,

Please find the table name and the field names for the requested.

Customer Number KNA1-KUNNR

Customer Name KNA1-NAME1

Sales Order Number VBAK-VBELN

Sales Order Item Number VBAP-POSNR

Quantity VBAP-ZMENG

Total Value VBAK-NETWR

Schedule Date VBEP-EDATU

Thanks,

Mahesh.

kenneth_chong
Participant
0 Kudos

KNA1 :- customer number, customer name

VBAK :- slaes order number

VBAP :- item , quantity , tottal value

VBEP :- schedule date.