I_CHEMICALAPPROVALROLE

CDS View
5 Fields 6 CDS Views

Chemical Approval Role

I_CHEMICALAPPROVALROLE is a CDS View in S/4HANA. Chemical Approval Role. It contains 5 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_MyChemicalApprovalRole view from COMPOSITE Chemical Approval Role
I_SftyRlvtChgAffcdObjUser view left_outer COMPOSITE SRC: Relevant Affected Objects for Users
I_SftyRlvtChgAffcdObjUser_2 view inner COMPOSITE SRC: Relevant Affected Objects for Users
P_ChemicalApprovalRoleData view from COMPOSITE
P_ChemicalApprvlNotAprvdCt view from COMPOSITE
P_EHSLocationChemicalApproval view inner COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY ChemicalApprovalRoleUUID ChemicalApprovalRoleUUID 2
_ProcCtrlChemicalBasicInfo _ProcCtrlChemicalBasicInfo 1
ChemicalApprovalDate ChemicalApprovalDate 1
ChemicalApprovalStatus ChemicalApprovalStatus 1
ProcessControlChemicalUUID ProcessControlChemicalUUID 2

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 Approval Role
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHEMICALAPPROVALROLE (
    CHEMICALAPPROVALROLEUUID,
    _PROCCTRLCHEMICALBASICINFO,
    CHEMICALAPPROVALDATE,
    CHEMICALAPPROVALSTATUS,
    PROCESSCONTROLCHEMICALUUID,
    PRIMARY KEY (CHEMICALAPPROVALROLEUUID)
);

Learn More