Table names for Variant Configuration (LO-VC) in CRM S/4 HANA

[ww_gtw-mc]

Hi experts,

we are looking for the table names that include the applied characteristics referring to one or more of these objects:

• Subscription Order (transaction type PRVO)
• Subscription Contract (transaction type PRVC)
• Materialnumber/-ID (CRMS4D_SERV_I-ORDERED_PROD)

The characteristics are set within the FIORI/WebUI in the product configuration when creating a subscription order with a configurable product.

FIORI App: Manage Subscription Orders
App-ID: TBT265SR

These characteristics are linked to materials over a configuration profile (transaction: PMEVC) where we defined them and set values if they were distinct. Configurable products can have one or more of these characteristics.

The characteristics and its values are stored in these tables:

1. CABN - Characteristics
2. CAWN - Values of Characteristics

Unfortunately these tables only contain the definitions and have no link to the mentioned objects.

Here are some articles referring to tables but none of them was the one in question:

• Table names in Variant Configuration
• Variant Configuration tables
• Characteristics Values

In table CRMS4D_SERV_I (contains data for subscription orders and contracts) there is a field called INT_OBJ_NO (internal configuration) which seems to be distinct (= every value appears once) but we are not sure if it is a link for what we are looking for.
We tried using the where-used-list but could not find the table.
Using the SQL-Trace (transaction ST05) we only find the line where it inputs the values but not the table name we are looking for.

Do you know the tables or have any advice?

Thanks in advance!

Regards Wolfgang

[ww_gtw-mc · Accepted solution]

We found the relevant tables and fields. To find the applied/assessed values for product configuration characteristics linked to a specific object like

• Subscription Order
• Subscription Contract
• Provider Contract

try the following:

1. query table CRMS4D_SERV_I and get INT_OBJ_NO | alternative: DFKK_VT_I and get CUOBJ
2. query table IBIN where INSTANCE = INT_OBJ_NO or CUOBJ
3. query table V_IBIN_SYVAL where IN_RECNO = INSTANCE
4. read characteristic name in ATINN and value in ATWRT

Hope this process graphics helps:

Regards

Wolfgang