_CHMLCMPLNCINFO

_CHMLCMPLNCINFO is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID 1
_RespUnitForDangerousGoods _RespUnitForDangerousGoods 1
ChmlCmplncInfoType ChmlCmplncInfoType 18
ChmlCmplncInternalName ChmlCmplncInternalName 13
ChmlCmplncProdIsResearched ChmlCmplncProdIsResearched 16
DngrsGdsRespUnit DngrsGdsRespUnit 2
MaterialIsBaseProduct MaterialIsBaseProduct 2
MaterialIsDisposed MaterialIsDisposed 7
MaterialIsEmissionRelevant MaterialIsEmissionRelevant 7
MaterialIsProduced MaterialIsProduced 23
MaterialIsSold MaterialIsSold 23
MaterialIsSourced MaterialIsSourced 23
MaterialIsTransported MaterialIsTransported 23
ProdStewardshipRespUnit ProdStewardshipRespUnit 2
Specification ChemicalComplianceInfo,Specification 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _CHMLCMPLNCINFO (
    CHMLCMPLNCINFOUUID,
    _RESPUNITFORDANGEROUSGOODS,
    CHMLCMPLNCINFOTYPE,
    CHMLCMPLNCINTERNALNAME,
    CHMLCMPLNCPRODISRESEARCHED,
    DNGRSGDSRESPUNIT,
    MATERIALISBASEPRODUCT,
    MATERIALISDISPOSED,
    MATERIALISEMISSIONRELEVANT,
    MATERIALISPRODUCED,
    MATERIALISSOLD,
    MATERIALISSOURCED,
    MATERIALISTRANSPORTED,
    PRODSTEWARDSHIPRESPUNIT,
    SPECIFICATION,
    PRIMARY KEY (CHMLCMPLNCINFOUUID)
);