SAP Table

WRFV_TYPDIMVAL1 Generated Table for View

SAP table WRFV_TYPDIMVAL1 has 4 primary key fields being MANDT,ASSORTYP,ASSORDIM1,ASSORDIMVAL.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

WRFV_TYPDIMVAL1 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyASSORTYP Assortment Type CHAR 4 0 WRFDE_ASSORTYP
KeyASSORDIM1 Assortment Dimension CHAR 2 0 WRFST_DIM WRFDE_ASSORDIM
KeyASSORDIMVAL Value in an Assortment Dimension CHAR 4 0 WRFDE_ASSORDIMVAL
/ Relationships

WRFV_TYPDIMVAL1 foreign keys.

Table Field Check Table Description Check Field
WRFV_TYPDIMVAL1 ASSORDIM1 WRFST_DIM Assortment Dimensions MANDT
WRFV_TYPDIMVAL1 ASSORDIM1 WRFST_DIM Assortment Dimensions ASSORDIM
WRFV_TYPDIMVAL1 MANDT T000 Clients MANDT