CRVM_A

Transparent Table Application Table
5 Fields 2 CDS Views

Link of PRT data to a material

CRVM_A is an SAP database table in S/4HANA. Link of PRT data to a material. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaterialPRTByInternalKey view inner BASIC Material PRT by internal key
P_ProdnRoutingMatlPRTAssgmtDEX view_entity inner BASIC

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objty CR_OBJTY Object Type
KEY objid CR_OBJID Object ID
KEY matnr MATNR Material
KEY werks WERKS_D Plant

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Link of PRT data to a material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRVM_A (
    MANDT,  -- Client [MANDT]
    OBJTY,  -- Object Type [CR_OBJTY]
    OBJID,  -- Object ID [CR_OBJID]
    MATNR,  -- Material [MATNR]
    WERKS,  -- Plant [WERKS_D]
    PRIMARY KEY (MANDT, OBJTY, OBJID, MATNR, WERKS)
);

Learn More