I_SALESORGANIZATION
Sales Organization
I_SALESORGANIZATION is a CDS View in S/4HANA. Sales Organization. It contains 4 fields. 38 CDS views read from this table.
CDS Views using this table (38)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_SalesOrganization | view | from | BASIC | Sales Organization |
| C_ACMSlsOrgVH | view_entity | from | CONSUMPTION | Val hel for sales organization |
| C_JITSalesOrganizationVH | view_entity | from | CONSUMPTION | Consump View VH for Sales Organization |
| C_LCMSalesOrganizationVH | view | from | CONSUMPTION | Consumption-Sales Org Value Help |
| C_LglTransMainOrgSlsOrgCrteVH | view | from | CONSUMPTION | Sales Organization Value Help |
| C_LglTransMainOrgSlsOrgEditVH | view | from | CONSUMPTION | Sales Organization Value Help |
| C_RevnVarSlsOrgVH | view | from | CONSUMPTION | Value help for Sales Organization |
| C_SalesDocSalesOrganizationVH | view | from | CONSUMPTION | Sales Organization |
| C_SalesInsightSalesOrgVH | view | from | CONSUMPTION | Sales Insight: Sales Org Value Help |
| C_Salesorg_Land | view | from | CONSUMPTION | Country for Sales Organization |
| C_SalesOrganizationDEX | view | from | CONSUMPTION | Sales Organization Data Extraction |
| C_SalesOrganizationValueHelp | view_entity | from | CONSUMPTION | Sales Organization |
| C_SalesOrganizationVH | view | from | CONSUMPTION | Sales Organization |
| C_SegmentationSalesOrgVH_F9070 | view_entity | from | CONSUMPTION | Sales Organization |
| C_TrdgContrSalesOrganizationVH | view_entity | from | CONSUMPTION | Sales Organization of Trdg Contr |
| C_WrntySalesOrganizationVH | view | from | CONSUMPTION | Consumption-Sales Org Value Help |
| CIC_SALES_ORG | view_entity | from | CIC Projection on Sales Organizaztion | |
| FAC_SalesOrganizationVH | view | from | Data Source for Sales Organization | |
| I_CnsldtnMasterData | view | union_all | COMPOSITE | Consolidation - Combined Master Data |
| I_DigitalVehicleSalesOrg | view_entity | from | BASIC | Digital Vehicle Sales Organization |
| I_LglCntntMCombinedEntityVH | view | union_all | COMPOSITE | Value Help for Entity Types for LCA |
| I_TrdgContrSalesOrganizationVH | view_entity | from | BASIC | Sales Organization of a Trading Contract |
| P_AR_DeliveryDocument | view_entity | inner | CONSUMPTION | |
| P_AR_LengthOfRefDoc | view | inner | COMPOSITE | |
| P_CnsldtnSalesOrganization | view | from | COMPOSITE | |
| P_RevenueRecgnSalesOrderVH | view | inner | COMPOSITE | |
| P_RevnRecgnSalesOrderItemVH | view | inner | COMPOSITE | |
| P_RevRecgnSalesOrderItemVH | view | inner | CONSUMPTION | |
| P_RevRecgnSalesOrderVH | view | inner | CONSUMPTION | |
| P_SalesDocGeneralRjcnRsn | view | from | BASIC | |
| P_SI_SalesOrganizationVH | view | from | BASIC | |
| P_SI4_TrainingData10 | view | left_outer | COMPOSITE | |
| P_SlsOrgIDDetmCountry | view | from | COMPOSITE | |
| P_SlsOrgIDDetmCountry | view | union | COMPOSITE | |
| P_SPP_PredictionData06 | view | left_outer | COMPOSITE | |
| P_SPP_TrainingData06 | view | left_outer | COMPOSITE | |
| P_SrvcMgmtRjcnPrflAssignment | view_entity | cross | COMPOSITE | |
| P_SrvcMgmtRjcnReasonAssignment | view_entity | cross | COMPOSITE |
Fields (4)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 6 |
| KEY | SalesOrganization | SalesOrganization | 4 |
| KEY | ServiceDocumentRejectionReason | ServiceDocumentRejectionReason | 1 |
| IntercompanyBillingCustomer | IntercompanyBillingCustomer | 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 Organization
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORGANIZATION (
COMPANYCODE,
SALESORGANIZATION,
SERVICEDOCUMENTREJECTIONREASON,
INTERCOMPANYBILLINGCUSTOMER,
PRIMARY KEY (COMPANYCODE, SALESORGANIZATION, SERVICEDOCUMENTREJECTIONREASON)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA