I_MFGBUSINESSPARTNER

CDS View
15 Fields 5 CDS Views

Manufacturing Business Partner

I_MFGBUSINESSPARTNER is a CDS View in S/4HANA. Manufacturing Business Partner. It contains 15 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_MfgExecutionUserVH view_entity from CONSUMPTION Manufacturing execution user
C_MfgOperatorDetail view from CONSUMPTION Production Operator details
I_MfgBusinessPartnerTP view from TRANSACTIONAL Manufacturing Business Partner
P_OpActyAllManufacturingUsers view cross COMPOSITE
P_OpActyMainWrkCtrMfgUser view inner COMPOSITE

Fields (15)

KeyField CDS FieldsUsed in Views
KEY MfgBusinessPartner MfgBusinessPartner 3
_BusinessPartner _BusinessPartner 2
_WorkCenterBySemanticKey _WorkCenterBySemanticKey 2
AuthorizationGroup AuthorizationGroup 2
BusinessPartner BusinessPartner 2
BusinessPartnerUUID BusinessPartnerUUID 3
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
FirstName FirstName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LastName LastName 1
Plant Plant 3
WorkCenter WorkCenter 3

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.

-- Manufacturing Business Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGBUSINESSPARTNER (
    MFGBUSINESSPARTNER,
    _BUSINESSPARTNER,
    _WORKCENTERBYSEMANTICKEY,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    BUSINESSPARTNERUUID,
    CREATEDBYUSER,
    CREATIONDATETIME,
    FIRSTNAME,
    ISBUSINESSPURPOSECOMPLETED,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTNAME,
    PLANT,
    WORKCENTER,
    PRIMARY KEY (MFGBUSINESSPARTNER)
);

Learn More