I_SDITEMORGANIZATION

CDS View
10 Fields 6 CDS Views

Sales Document Item with Sales Organization

I_SDITEMORGANIZATION is a CDS View in S/4HANA. Sales Document Item with Sales Organization. It contains 10 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_MasterProjectSalesOrder view inner COMPOSITE Get MasterProject Sales Order
I_MstrProjHierList view left_outer COMPOSITE Master Project Hierarchy List
P_MPStructureElement view left_outer COMPOSITE
P_MPStructureElement view inner COMPOSITE
P_MstrProjHierarchy view left_outer COMPOSITE
P_MstrProjHierarchy view inner COMPOSITE

Fields (10)

KeyField CDS FieldsUsed in Views
BusinessArea BusinessArea 2
CompanyCode CompanyCode 2
ControllingArea ControllingArea 2
ControllingObject ControllingObject 1
FiscalYear FiscalYear 1
SalesDocument SalesDocument 4
SalesDocumentItem SalesDocumentItem 4
SalesDocumentItemText ControllingObjectDescription,ObjectName 2
SDDocumentCategory SDDocumentCategory 1
WBSElement WBSElement 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.

-- Sales Document Item with Sales Organization
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SDITEMORGANIZATION (
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    FISCALYEAR,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMTEXT,
    SDDOCUMENTCATEGORY,
    WBSELEMENT
);

Learn More