I_MATLBSDBEFOREPRODNCOMPTP

CDS View
17 Fields 3 CDS Views

After Production Cmpnt in Mat.Bsd Cmpstn

I_MATLBSDBEFOREPRODNCOMPTP is a CDS View in S/4HANA. After Production Cmpnt in Mat.Bsd Cmpstn. It contains 17 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_ChmlCmplncPckgdProdComp2 view_entity from CONSUMPTION Components of Multi Component Product
C_MatlBsdBeforeProdnCompTP view from CONSUMPTION Before Production Cmpnt in Matl.Bsd Cmpstn
R_DngrsGdsMlticmpProdCompTP view_entity from TRANSACTIONAL DaGds Mlticmp Prod Component - TP

Fields (17)

KeyField CDS FieldsUsed in Views
KEY MatlBsdCompUUID MatlBsdCompUUID 2
KEY MlticmpProdCompUUID MlticmpProdCompUUID 1
_ChmlCmplncInfo _ChmlCmplncInfo 1
_CompChmlCmplncInfo _CompChmlCmplncInfo 1
ActiveMatlBsdCompUUID ActiveMatlBsdCompUUID 1
ChmlCmplncInfoUUID HostChmlCmplncInfoUUID 1
ChmlCompIsRemoved ChmlCompIsRemoved 1
ChmlCompositionUUID ChmlCompositionUUID 1
ChmlCompQty ChmlCompQty 2
ChmlCompQtyAsText ChmlCompQtyAsText 1
ChmlCompQtyUnit ChmlCompQtyUnit 1
CompChmlCmplncInfoUUID ChmlCmplncInfoNavgnLink,ChmlCmplncInfoUUID,CompChmlCmplncInfoUUID 1
CreatedByUser CreatedByUser 1
CreationUTCDateTime CreationUTCDateTime 1
LastChangedByUser LastChangedByUser 1
LastChangeUTCDateTime LastChangeUTCDateTime 1
MatlBsdCompProductionType MatlBsdCompProductionType 1

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.

-- After Production Cmpnt in Mat.Bsd Cmpstn
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATLBSDBEFOREPRODNCOMPTP (
    MATLBSDCOMPUUID,
    MLTICMPPRODCOMPUUID,
    _CHMLCMPLNCINFO,
    _COMPCHMLCMPLNCINFO,
    ACTIVEMATLBSDCOMPUUID,
    CHMLCMPLNCINFOUUID,
    CHMLCOMPISREMOVED,
    CHMLCOMPOSITIONUUID,
    CHMLCOMPQTY,
    CHMLCOMPQTYASTEXT,
    CHMLCOMPQTYUNIT,
    COMPCHMLCMPLNCINFOUUID,
    CREATEDBYUSER,
    CREATIONUTCDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGEUTCDATETIME,
    MATLBSDCOMPPRODUCTIONTYPE,
    PRIMARY KEY (MATLBSDCOMPUUID, MLTICMPPRODCOMPUUID)
);

Learn More