This website is not affiliated with, sponsored by, or approved by SAP AG.

Database tables for salesorders

CRM related discussion only

Moderators: Snowy, thx4allthefish, Lost Identity

Database tables for salesorders

Postby guess » Wed Oct 30, 2002 9:03 am

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
guess
 

Postby ppb » Wed Nov 06, 2002 5:41 am

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
ppb
 
Posts: 59
Joined: Fri Oct 25, 2002 5:51 am

Postby Loriannalea » Wed Nov 13, 2002 4:25 pm

Sales order ...

header table - VBAK (for sold-to party)

line item table - VBAP (for material ordered)

schedule line table - VBEP
Loriannalea
 
Posts: 31
Joined: Wed Oct 23, 2002 11:46 am


Return to CRM :: SAP CRM

Who is online

Users browsing this forum: No registered users and 3 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.