I_MFGBPWRKCTRASSGMTTP

CDS View
12 Fields 2 CDS Views

Mfg. BP Work Center Assignment

I_MFGBPWRKCTRASSGMTTP is a CDS View in S/4HANA. Mfg. BP Work Center Assignment. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MfgBPWorkCenterAssgmt view from CONSUMPTION Work Center assignment
C_MfgBPWrkCtrAssgmtTP view from CONSUMPTION Mfg. BP Work Center Assignment

Fields (12)

KeyField CDS FieldsUsed in Views
KEY MfgBusinessPartner MfgBusinessPartner 2
KEY Plant Plant 2
KEY WorkCenter WorkCenter 2
AuthorizationGroup AuthorizationGroup 2
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
IsDefaultMfgWrkCtr IsDefaultMfgWrkCtr 2
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 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 Work Center Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGBPWRKCTRASSGMTTP (
    MFGBUSINESSPARTNER,
    PLANT,
    WORKCENTER,
    AUTHORIZATIONGROUP,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ISBUSINESSPURPOSECOMPLETED,
    ISDEFAULTMFGWRKCTR,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (MFGBUSINESSPARTNER, PLANT, WORKCENTER)
);

Learn More