I want the table names for these fields

[Former Member]

Customer ID.

Material Number

Cross company Purchase Order.

Delivery date (requested by the company who is placing the purchase order).

Qty requested.

Value of the Qty requested (Value of the Qty requested = Qty requested * Material unit price )

Currency

Total pieces shipped (during the time frame set on the report)

Balance Left ( Balance Left = Qty Requested - Total pieces shipped)

Value of the balance left Value of the balance left = Balance left * Unit price only if the Balance left is greater than cero,

if the balance left is lower than or equals cero, the value of the balance left show be cero.

% Delivery (% Delivery = Total pieces shipped / Qty requested).

[Former Member]

check in <b>VBAK & VBAP & KNA1</b> tables...

[Former Member]

Ravi,

An odd question.

These fields appear in hundreds (perhaps thousands) of database tables. Sometimes they have the same field name and sometimes they do not. SAP "tries" to use standardized names... but that is not always the case.

Where are you seeing this descriptions? In a certain transaction(s)? If so, what t-codes?

[Former Member]

HI

GOOD

check with following table

KNA1.

THANKS

MRUTYUN^

[Former Member]

Ravi,

An example of my point:

You want Customer ID - this COULD be "Sold-to party".

"Sold-to party" is KUNNR in table VBAK - the sales order header table.

"Sold-to party" is KUNAG in table LIKP - the delivery header table.

Please explain your specific needs in more detail.

[Former Member]

actually i want to develope report for Cross company order, we have to consider that a Purchase order contains several items as i listed already,

so please help me in this way

regards

ravi chand

[Former Member]

Ravi,

OK.

You can look to tables EKPO, EKKO for PO-related fields.

Look to SE84 under ABAP Dictionary > Fields > Table Fields - This is search tool for existing names. Or can create custom Y- and Z- fields, data elements, domains to meet your needs.

Please reward points.

[Former Member]

And it needs to be noted that these two KUNNR / KUNAG entities are the SAME, single business partner.