I_CHEMICALAPPROVALROLE

CDS View

Chemical Approval Role

I_CHEMICALAPPROVALROLE is a CDS View in S/4HANA. Chemical Approval Role. It contains 3 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 Chemical Approval Role
P_ChemicalApprvlNotAprvdCt view from COMPOSITE Chemical Approval Not Approved Count
P_EHSLocationChemicalApproval view inner COMPOSITE Chemical Approval for Location

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ChemicalApprovalRoleUUID ChemicalApprovalRoleUUID 2
_ProcCtrlChemicalBasicInfo _ProcCtrlChemicalBasicInfo 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,
    PROCESSCONTROLCHEMICALUUID,
    PRIMARY KEY (CHEMICALAPPROVALROLEUUID)
);