Question:
I am trying to do an info set query, as a table join using basis tables. The info I am hunting for is "which customer has ordered this product" , so I need the table for CRM Sales order header and item. Anyone happen to know what these tables for Sales order header and item are?? I would use the data structures, but u cannot join two data structures.
Thanx
maija
Answer:
Hello Maija,
maybe you should have a look at these tables:
crmd_orderadm_i (item data for business transactions)
crmd_orderadm_h (head data for business transaction)
where ...i-header = ...h-guid
I don't know the database table for the partnersy, but you can read it
for the header with function module
crm_partner_read_ow giving guid of header in parameter iv_ref_guid
and setting desired ref_kind and partner functions to read...
Kind regards,
Peter
Answer:
Sales order ...
header table - VBAK (for sold-to party)
line item table - VBAP (for material ordered)
schedule line table - VBEP