10-24-2007 8:44 AM
HI
CAN ANYBODY TELL ME THE ddic TABLES FOR FIELDS TOTAL AMOUNT,CUSTOMER INFORMATION,EXCISE INVOICE NUMBER,INVOICE DATE,QUANTITY,UNIT,LST AMOUNT,CST AMOUNT
TAHNKS N REGARDS,
SUDHA
10-24-2007 9:04 AM
konv, "Conditions (Transaction Data)
kna1, "General Data in Customer Master
vbpa, "Partner function table
t005u, "Taxes: Region (Province) Key
tvko, "Organizational Unit: Sales Organizations
tspat, "Organizational Unit: Sales Divisions: Texts
tvtw, "Organizational Unit: Distribution Channels
vbak, "sales doc header
vbap. "Sales doc Item
vbrk-vbeln, "INVOICE NO
vbrk-fkdat, "INVOICE DATE
vbrp-fkimg, "INVOICED QUANTITY
vbrp-netwr, "amount
vbrk-kunrg, "customer (use this to fetch customer info from kna1)
konv-kwert, "LST AMOUNT /cst amount
Total amount... u need to put logic for tat....
LSt and cst amount can be filtered on the logic. based on vbrpwkreg and vbrpregio_auft...
regards,
musarrat
Plz reward points for helpful answers