I_MASTERPROJECTSALESORDER

CDS View
27 Fields 2 CDS Views

Get MasterProject Sales Order

I_MASTERPROJECTSALESORDER is a CDS View in S/4HANA. Get MasterProject Sales Order. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MpSO view union COMPOSITE
P_MstrProjHierSales view union COMPOSITE

Fields (27)

KeyField CDS FieldsUsed in Views
BusinessArea BusinessArea 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
ControllingObject ControllingObject 1
Country Country 1
Customer Customer 1
EndDate EndDate 1
FinancialRisk FinancialRisk 1
Industry Industry 1
MasterProject MasterProject 2
MasterProjectIsConfidential MasterProjectIsConfidential 2
MasterProjectItem MasterProjectItem 1
MasterProjectItemObjectType MasterProjectItemObjectType 1
MasterProjectItemUUID MasterProjectItemUUID 1
MasterProjectName MasterProjectName 1
MasterProjectOrganization MasterProjectOrganization 2
MasterProjectStage MasterProjectStage 1
MasterProjectType MasterProjectType 2
OverallRisk OverallRisk 1
ProjectRisk ProjectRisk 1
Region Region 1
SalesDocument SalesDocument 2
SalesDocumentItem SalesDocumentItem 2
StartDate StartDate 1
TechnicalRisk TechnicalRisk 1
WBSElement WBSElement 1
WorkType WorkType 1

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.

-- Get MasterProject Sales Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MASTERPROJECTSALESORDER (
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    COUNTRY,
    CUSTOMER,
    ENDDATE,
    FINANCIALRISK,
    INDUSTRY,
    MASTERPROJECT,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTITEM,
    MASTERPROJECTITEMOBJECTTYPE,
    MASTERPROJECTITEMUUID,
    MASTERPROJECTNAME,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTSTAGE,
    MASTERPROJECTTYPE,
    OVERALLRISK,
    PROJECTRISK,
    REGION,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    STARTDATE,
    TECHNICALRISK,
    WBSELEMENT,
    WORKTYPE
);

Learn More