cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

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

ww_gtw-mc
Explorer
4,571

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:

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

View Entire Topic
chetan_099
Explorer
0 Kudos

you can try using FM VC_I_GET_CONFIGURATION with INT_OBJ_NO from CRMS4D_MAGR_I table to read teh VC details. You can also try FM CUAB_DISPLAY_CD_CONFIGURATION to get the data.

If you are looking for tables specifically please look into these FMs for the info. I believe the tables are same in CRM S/4 HANA as SD S/4 HANA

ww_gtw-mc
Explorer
0 Kudos

Hi Chetan,

thanks for the hint.

CRMS4D_MAGR_I is for positions in master agreements which we are not using on this particular project.

Regards

Wolfgang

chetan_099
Explorer
0 Kudos

Yes you are right. For Subscription objects is it is CRMS4D_SERV* tables