I_CHMLCMPLNCREQ

CDS View
52 Fields 11 CDS Views

Chemical Compliance Request

I_CHMLCMPLNCREQ is a CDS View in S/4HANA. Chemical Compliance Request. It contains 52 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_ChmlCmplncReqRequesterUserVH view from CONSUMPTION Chemical Compliance Request Requester User Value Help
C_ChmlCmplncReqRequesterVH view from CONSUMPTION Value Help for Requester of a Chemical Compliance Request
I_ChmlCmplncReqRelevantStep view_entity from COMPOSITE Relevant Step for a Compliance Request
I_ChmlCmplncReqTP view from TRANSACTIONAL Chemical Compliance Request
I_PckgdReqFromLogsTrigger view from COMPOSITE Packaged Requests from Logistics Trigger
I_UnpckgdReqFromLogsTrigger view from COMPOSITE Unpackaged Requests from Logistics Trigger
P_ChmlCmplncReqIntNmMigration1 view_entity from COMPOSITE View for scilent data migration for CRQ internal number
P_ChmlCmplncReqMigration view from COMPOSITE Silent Data Migration for Chemical Composition
P_ChmlCmplncReqMigration view inner COMPOSITE Silent Data Migration for Chemical Composition
P_ChmlCmplncReqUnprocessedCT view from CONSUMPTION Count of unprocessed requests per Product
R_ProductComplianceRequestTP view_entity from TRANSACTIONAL Product Compliance Request - TP

Fields (52)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncRequestUUID ChmlCmplncRequestUUID 3
_BusinessProcess _BusinessProcess 1
_BusinessUserProcessor _BusinessUserProcessor 1
_BusinessUserRequester _BusinessUserRequester 1
_ChemicalCustomerMaterial _ChemicalCustomerMaterial 1
_ChmlCmplncInfo _ChmlCmplncInfo 2
_ChmlCmplncInfoProd _ChmlCmplncInfoProd 1
_ChmlCmplncReqCmplncProc _ChmlCmplncReqCmplncProc 1
_CreatedByUser _CreatedByUser 1
_LastChangedByUser _LastChangedByUser 1
_MultiComponentProduct _MultiComponentProduct 1
_OriginProcess _OriginProcess 1
_OriginType _OriginType 1
_Product _Product 1
_RequestedApplication _RequestedApplication 1
_RequestedMarket _RequestedMarket 1
_RequestedPlnt _RequestedPlnt 1
_RequestedPurpose _RequestedPurpose 1
_RequestedSlsOrg _RequestedSlsOrg 1
_RequesterUser _RequesterUser 1
_RequestStatus _RequestStatus 1
_RouteSegment _RouteSegment 1
_Supplier _Supplier 1
BusinessSystemName BusinessSystemName 1
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID 1
ChmlCmplncBusinessProcess ChmlCmplncBusinessProcess 2
ChmlCmplncInfoUUID ChmlCmplncInfoUUID 3
ChmlCmplncProdUUID ChmlCmplncProdUUID 2
ChmlCmplncReqBPProcessor ChmlCmplncReqBPProcessor 1
ChmlCmplncReqBPRequester ChmlCmplncReqBPRequester 1
ChmlCmplncReqCmplncProc ChmlCmplncReqCmplncProc 2
ChmlCmplncReqDetails ChmlCmplncReqDetails 1
ChmlCmplncReqLogisticDocCat ChmlCmplncReqLogisticDocCat 1
ChmlCmplncReqOriginProc ChmlCmplncReqOriginProc 2
ChmlCmplncReqRequester ChmlCmplncReqRequester 1
ChmlCmplncRequestDueDate ChmlCmplncRequestDueDate 1
ChmlCmplncRequestOriginType ChmlCmplncRequestOriginType 2
ChmlCmplncRequestPrgrsStatus ChmlCmplncRequestPrgrsStatus 2
ChmlCmplncRequestRemark ChmlCmplncRequestRemark 1
CreatedByUser CreatedByUser 2
CreationUTCDateTime CreationUTCDateTime 2
DngrsGdsLogsPackgInstrnUUID DngrsGdsLogsPackgInstrnUUID 1
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport 1
LastChangedByUser LastChangedByUser 2
LastChangeUTCDateTime LastChangeUTCDateTime 2
Material Material 2
MultiComponentProduct MultiComponentProduct 1
ProdCmplncLogsDocument ProdCmplncLogsDocument 1
ProdCmplncLogsDocumentItem ProdCmplncLogsDocumentItem 1
ProdCmplncLogsDocumentUUID ProdCmplncLogsDocumentUUID 1
ProductComplianceRequest ProductComplianceRequest 1
Supplier Supplier 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.

-- Chemical Compliance Request
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHMLCMPLNCREQ (
    CHMLCMPLNCREQUESTUUID,
    _BUSINESSPROCESS,
    _BUSINESSUSERPROCESSOR,
    _BUSINESSUSERREQUESTER,
    _CHEMICALCUSTOMERMATERIAL,
    _CHMLCMPLNCINFO,
    _CHMLCMPLNCINFOPROD,
    _CHMLCMPLNCREQCMPLNCPROC,
    _CREATEDBYUSER,
    _LASTCHANGEDBYUSER,
    _MULTICOMPONENTPRODUCT,
    _ORIGINPROCESS,
    _ORIGINTYPE,
    _PRODUCT,
    _REQUESTEDAPPLICATION,
    _REQUESTEDMARKET,
    _REQUESTEDPLNT,
    _REQUESTEDPURPOSE,
    _REQUESTEDSLSORG,
    _REQUESTERUSER,
    _REQUESTSTATUS,
    _ROUTESEGMENT,
    _SUPPLIER,
    BUSINESSSYSTEMNAME,
    CHEMICALCUSTOMERMATERIALUUID,
    CHMLCMPLNCBUSINESSPROCESS,
    CHMLCMPLNCINFOUUID,
    CHMLCMPLNCPRODUUID,
    CHMLCMPLNCREQBPPROCESSOR,
    CHMLCMPLNCREQBPREQUESTER,
    CHMLCMPLNCREQCMPLNCPROC,
    CHMLCMPLNCREQDETAILS,
    CHMLCMPLNCREQLOGISTICDOCCAT,
    CHMLCMPLNCREQORIGINPROC,
    CHMLCMPLNCREQREQUESTER,
    CHMLCMPLNCREQUESTDUEDATE,
    CHMLCMPLNCREQUESTORIGINTYPE,
    CHMLCMPLNCREQUESTPRGRSSTATUS,
    CHMLCMPLNCREQUESTREMARK,
    CREATEDBYUSER,
    CREATIONUTCDATETIME,
    DNGRSGDSLOGSPACKGINSTRNUUID,
    DNGRSGOODSMODEOFTRANSPORT,
    LASTCHANGEDBYUSER,
    LASTCHANGEUTCDATETIME,
    MATERIAL,
    MULTICOMPONENTPRODUCT,
    PRODCMPLNCLOGSDOCUMENT,
    PRODCMPLNCLOGSDOCUMENTITEM,
    PRODCMPLNCLOGSDOCUMENTUUID,
    PRODUCTCOMPLIANCEREQUEST,
    SUPPLIER,
    PRIMARY KEY (CHMLCMPLNCREQUESTUUID)
);

Learn More