CRM table and tables relationships

[Former Member]

Hi

I'm looking for table and table relationship in the CRM.

Sales tables especially (like VBAK, VBAP VBFA Etc' at SAP ECC)

Yaki Katz

SAP SD Consultant

[Former Member · Accepted solution]

hi,

CRMD_orderadm_h

crmd_orderadm_i

crmd_order_index

crmd_partner

CRMD_PRODUCT_I

and for relations crmd_link

Regards

Radek

[Former Member · Accepted solution]

Thanks

But I'm looking for connection between sales order to the contract (or other previous document) like VBAP-VGEL in the SAP ECC

Yaki

[Former Member]

Hi Yaki

I am also looking for this info. Have you managed to find it yet?

What I am trying to do is update approx 1200 (open) service orders with contract data so that our SLA functionality will work. Our new development only works for newly created Service Requests.

Cheers

Mark

[Former Member]

HI,,

Sales related tables in CRM.

CRMD_ORDER_INDEX- Index table

CRMD_ORDERADM_H- Order header table

CRMD_ORDERADM_I- Order Item Table

CRMD_ORGMAN Organizational Unit Set

CRMD_PARTNER Partners

CRMD_PRICING Business Transaction Pricing Parameter Set

CRMD_PRICING_I Transaction Item Price

CRMD_PRODUCT_I Transaction Item - Product

CRMD_SALES Business Transaction - Sales Set

CRMD_ORDERADM_H-GUID = CRMD_ORDER_INDEX-HEADER

CRMD_ORDERADM_H-OBJECT_TYPE = CRMD_ORDER_INDEX-OBJECT TYPE

CRMD_ORDERADM_I-GUID = CRMD_ORDER_INDEX-ITEM

CRMD_ORDERADM_I-HEADER = CRMD_ORDER_INDEX-HEADER

Regards

Srinu

[Former Member]

Thanks

But I'm looking for connection between sales order to the contract (or other previous document) like VBAP-VGBEL in the SAP ECC

Yaki

Edited by: Yaki Katz on Sep 23, 2008 1:54 PM

[Former Member]

HI,

In CRM all transaction will store at one table, that is CRMD_ORDERADM_H.

If you want to see the sales contract data go to the CRMD_ORDERADM_H , execute the table and in the selection screen you can give OBJECT_TYPE = BUS2000121 for contracts, BUS2000115 for sales.

Regards

Srinu

[Former Member]

I'm looking for the connection data u2013 in the CRM data base tables u2013 between sale order XXX item number AA to contract number YYY item BB

Regards

Yaki