I_MFGBPQUALIFNCERTASSGMTTP

CDS View

Mfg. BP Qualifn Certificate Assignment

I_MFGBPQUALIFNCERTASSGMTTP is a CDS View in S/4HANA. Mfg. BP Qualifn Certificate Assignment. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MfgBPQualifnCertAssgmtTP view from CONSUMPTION Mfg. BP Qualifn Certificate Assignment
C_MfgQualifnCertBPAssgmt view from CONSUMPTION Mfg Qualifn Certificate BP Assignment

Fields (10)

KeyField CDS FieldsUsed in Views
KEY MfgBusinessPartner MfgBusinessPartner 2
KEY MfgQualifnCertificate MfgQualifnCertificate 2
AuthorizationGroup AuthorizationGroup 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
MfgQualifnCertAssgmtDate MfgQualifnCertAssgmtDate 2
MfgQualifnCertAssgmtStatus MfgQualifnCertAssgmtStatus 2
MfgQualifnCertAssgmtStsVirtual MfgQualifnCertAssgmtStsVirtual 1
MfgQualifnCertExprtnDate MfgQualifnCertExprtnDate 2
MfgQualifnCertSkillLevel MfgQualifnCertSkillLevel 2
MfgQualifnCertTrainingRequired MfgQualifnCertTrainingRequired 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.

-- Mfg. BP Qualifn Certificate Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGBPQUALIFNCERTASSGMTTP (
    MFGBUSINESSPARTNER,
    MFGQUALIFNCERTIFICATE,
    AUTHORIZATIONGROUP,
    ISBUSINESSPURPOSECOMPLETED,
    MFGQUALIFNCERTASSGMTDATE,
    MFGQUALIFNCERTASSGMTSTATUS,
    MFGQUALIFNCERTASSGMTSTSVIRTUAL,
    MFGQUALIFNCERTEXPRTNDATE,
    MFGQUALIFNCERTSKILLLEVEL,
    MFGQUALIFNCERTTRAININGREQUIRED,
    PRIMARY KEY (MFGBUSINESSPARTNER, MFGQUALIFNCERTIFICATE)
);