I_SalesSchedgAgrmtItemCube
Sales Scheduling Agreement Item - Cube
I_SalesSchedgAgrmtItemCube is a Composite CDS View (Cube) that provides data about "Sales Scheduling Agreement Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_SalesSchedgAgrmtItem) and exposes 76 fields with key fields SalesSchedulingAgreement, SalesSchedulingAgreementItem, SchedulingAgreementReleaseType. It has 6 associations to related views.
SAP Help Documentation
| Category | Sales Scheduling Agreement |
|---|---|
| Data Category | Cube |
| Status | Released |
Purpose
This CDS view provides prerequisites for analyzing to what extent sales scheduling agreements are being processed. It answers the following business questions about sales scheduling agreements with delivery schedules: What is the cumulative delivered quantity? What is the cumulative issued quantity? What is the cumulative quantity received by customer? Note Make sure that you use the cubes for analytical purposes only.
Prerequisites
Users who want to run reports using this CDS view must have the read access to: Sales Document Type Sales Organization Distribution Channel Division
Structure
Object types This view is built on the following object type: Sales Scheduling Agreement Main CDS parameters and filters This view does not contain any input parameters or filters. Measures and attributes Some important measures and attributes are: Cumulative delivered quantity ( CumulativeDeliveredQuantity ) Cumulative issued quantity ( CumulativeIssuedQuantity ) Cumulative quantity received by the customer ( CumulativeReceiptQuantity ) Sales scheduling agreement ( SalesSchedulingAgreement ) Sales scheduling agreement item ( SalesSchedulingAgreementItem ) Sales scheduling agreement release type ( SchedulingAgreementReleaseType ) The possible values are: 1 : Forecast Delivery Schedule 2 : JIT Delivery Schedule
This CDS view provides prerequisites for analyzing to what extent sales scheduling agreements are being processed. It answers the following business questions about sales scheduling agreements with delivery schedules: What is the cumulative delivered quantity? What is the cumulative issued quantity? What is the cumulative quantity received by customer? Note Make sure that you use the cubes for analytical purposes only.
Prerequisites
Users who want to run reports using this CDS view must have the read access to: Sales Document Type Sales Organization Distribution Channel Division
Structure
Object types This view is built on the following object type: Sales Scheduling Agreement Main CDS parameters and filters This view does not contain any input parameters or filters. Measures and attributes Some important measures and attributes are: Cumulative delivered quantity ( CumulativeDeliveredQuantity ) Cumulative issued quantity ( CumulativeIssuedQuantity ) Cumulative quantity received by the customer ( CumulativeReceiptQuantity ) Sales scheduling agreement ( SalesSchedulingAgreement ) Sales scheduling agreement item ( SalesSchedulingAgreementItem ) Sales scheduling agreement release type ( SchedulingAgreementReleaseType ) The possible values are: 1 : Forecast Delivery Schedule 2 : JIT Delivery Schedule
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesSchedgAgrmtItem | SalesSchedgAgrmtItem | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Customer | _ShipToParty | $projection.ShipToParty = _ShipToParty.Customer |
| [0..1] | I_Customer | _BillToParty | $projection.BillToParty = _BillToParty.Customer |
| [0..1] | I_Customer | _PayerParty | $projection.PayerParty = _PayerParty.Customer |
| [0..1] | I_Product | _Product | $projection.Product = _Product.Product |
| [0..1] | I_ProductGroup_2 | _ProductGroup | $projection.ProductGroup = _ProductGroup.ProductGroup |
| [0..1] | E_SalesDocumentItemBasic | _Extension | $projection.SalesSchedulingAgreement = _Extension.SalesDocument and $projection.SalesSchedulingAgreementItem = _Extension.SalesDocumentItem |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Sales Scheduling Agreement Item - Cube | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AbapCatalog.sqlViewName | ISDSCHEDGAGRMTIC | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Analytics.dataCategory | #CUBE | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (76)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesSchedulingAgreement | I_SalesSchedgAgrmtItem | SalesSchedulingAgreement | Sales Document |
| KEY | SalesSchedulingAgreementItem | I_SalesSchedgAgrmtItem | SalesSchedulingAgreementItem | Item |
| KEY | SchedulingAgreementReleaseType | SalesSchedgAgrmtDelivSched | SchedulingAgreementReleaseType | |
| _SalesSchedgAgrmt | I_SalesSchedgAgrmtItem | _SalesSchedgAgrmt | ||
| _SalesSchedgAgrmtRelType | SalesSchedgAgrmtDelivSched | _SalesSchedgAgrmtRelType | ||
| SalesSchedgAgrmtType | ||||
| LastChangeDate | I_SalesSchedgAgrmtItem | LastChangeDate | Time Stamp | |
| CreatedByUser | I_SalesSchedgAgrmtItem | CreatedByUser | User Name | |
| CreationDate | I_SalesSchedgAgrmtItem | CreationDate | Time Stamp | |
| CreationTime | I_SalesSchedgAgrmtItem | CreationTime | Time of Change | |
| CreationDateYear | ||||
| CreationDateYearQuarter | ||||
| CreationDateYearMonth | ||||
| SalesOrganization | ||||
| _SalesOrganization | ||||
| DistributionChannel | ||||
| _DistributionChannel | ||||
| OrganizationDivision | ||||
| _OrganizationDivision | ||||
| SalesOffice | ||||
| _SalesOffice | ||||
| SalesGroup | ||||
| _SalesGroup | ||||
| PartnerCompany | ||||
| _GlobalCompany | ||||
| SoldToParty | ||||
| _SoldToParty | ||||
| CustomerGroup | ||||
| _CustomerGroup | ||||
| ShipToParty | ||||
| _ShipToParty | _ShipToParty | |||
| BillToParty | ||||
| _BillToParty | _BillToParty | |||
| PayerParty | ||||
| _PayerParty | _PayerParty | |||
| AdditionalCustomerGroup1 | ||||
| _AdditionalCustomerGroup1 | ||||
| AdditionalCustomerGroup2 | ||||
| _AdditionalCustomerGroup2 | ||||
| AdditionalCustomerGroup3 | ||||
| _AdditionalCustomerGroup3 | ||||
| AdditionalCustomerGroup4 | ||||
| _AdditionalCustomerGroup4 | ||||
| AdditionalCustomerGroup5 | ||||
| _AdditionalCustomerGroup5 | ||||
| MaterialByCustomer | I_SalesSchedgAgrmtItem | MaterialByCustomer | Customer Mat. | |
| Division | I_SalesSchedgAgrmtItem | Division | Internal Division ID | |
| _Division | I_SalesSchedgAgrmtItem | _Division | ||
| Plant | I_SalesSchedgAgrmtItem | Plant | Valuation Area | |
| _Plant | I_SalesSchedgAgrmtItem | _Plant | ||
| Product | ||||
| _Product | _Product | |||
| ProductGroup | ||||
| _ProductGroup | _ProductGroup | |||
| AdditionalMaterialGroup1 | I_SalesSchedgAgrmtItem | AdditionalMaterialGroup1 | MaterialGroup 1 | |
| _AdditionalMaterialGroup1 | I_SalesSchedgAgrmtItem | _AdditionalMaterialGroup1 | ||
| AdditionalMaterialGroup2 | I_SalesSchedgAgrmtItem | AdditionalMaterialGroup2 | MaterialGroup 2 | |
| _AdditionalMaterialGroup2 | I_SalesSchedgAgrmtItem | _AdditionalMaterialGroup2 | ||
| AdditionalMaterialGroup3 | I_SalesSchedgAgrmtItem | AdditionalMaterialGroup3 | MaterialGroup 3 | |
| _AdditionalMaterialGroup3 | I_SalesSchedgAgrmtItem | _AdditionalMaterialGroup3 | ||
| AdditionalMaterialGroup4 | I_SalesSchedgAgrmtItem | AdditionalMaterialGroup4 | MaterialGroup 4 | |
| _AdditionalMaterialGroup4 | I_SalesSchedgAgrmtItem | _AdditionalMaterialGroup4 | ||
| AdditionalMaterialGroup5 | I_SalesSchedgAgrmtItem | AdditionalMaterialGroup5 | MaterialGroup 5 | |
| _AdditionalMaterialGroup5 | I_SalesSchedgAgrmtItem | _AdditionalMaterialGroup5 | ||
| BillingCompanyCode | ||||
| _BillingCompanyCode | ||||
| SalesDistrict | ||||
| _SalesDistrict | ||||
| CustomerFiscalYear | SalesSchedgAgrmtDelivSched | CustomerFiscalYear | ||
| OrderQuantityUnit | I_SalesSchedgAgrmtItem | OrderQuantityUnit | Sales Unit | |
| _OrderQuantityUnit | I_SalesSchedgAgrmtItem | _OrderQuantityUnit | ||
| BaseUnit | I_SalesSchedgAgrmtItem | BaseUnit | Unit of Measure | |
| _BaseUnit | I_SalesSchedgAgrmtItem | _BaseUnit | ||
| CumulativeDeliveredQuantity | SalesSchedgAgrmtCumltvQty | CumulativeDeliveredQuantity | ||
| CumulativeIssuedQuantity | SalesSchedgAgrmtCumltvQty | CumulativeIssuedQuantity | ||
| CumulativeReceiptQuantity | SalesSchedgAgrmtDelivSched | CumulativeReceiptQuantity |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_SalesSchedgAgrmtItemCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW I_SalesSchedgAgrmtItemCube AS
SELECT
SalesSchedgAgrmtItem.SalesSchedulingAgreement AS SalesSchedulingAgreement,
SalesSchedgAgrmtItem.SalesSchedulingAgreementItem AS SalesSchedulingAgreementItem,
SalesSchedgAgrmtDelivSched.SchedulingAgreementReleaseType AS SchedulingAgreementReleaseType,
SalesSchedgAgrmtItem._SalesSchedgAgrmt AS _SalesSchedgAgrmt,
SalesSchedgAgrmtDelivSched._SalesSchedgAgrmtRelType AS _SalesSchedgAgrmtRelType,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.SalesSchedgAgrmtType AS SalesSchedgAgrmtType,
SalesSchedgAgrmtItem.LastChangeDate AS LastChangeDate,
SalesSchedgAgrmtItem.CreatedByUser AS CreatedByUser,
SalesSchedgAgrmtItem.CreationDate AS CreationDate,
SalesSchedgAgrmtItem.CreationTime AS CreationTime,
cast(CalendarDate.CalendarYear as creation_date_year) AS CreationDateYear,
cast(CalendarDate.YearQuarter as creation_date_year_quarter) AS CreationDateYearQuarter,
cast(CalendarDate.YearMonth as creation_date_year_month) AS CreationDateYearMonth,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.SalesOrganization AS SalesOrganization,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._SalesOrganization AS _SalesOrganization,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.DistributionChannel AS DistributionChannel,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._DistributionChannel AS _DistributionChannel,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.OrganizationDivision AS OrganizationDivision,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._OrganizationDivision AS _OrganizationDivision,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.SalesOffice AS SalesOffice,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._SalesOffice AS _SalesOffice,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.SalesGroup AS SalesGroup,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._SalesGroup AS _SalesGroup,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._SoldToParty.TradingPartner AS PartnerCompany,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._SoldToParty._GlobalCompany AS _GlobalCompany,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.SoldToParty AS SoldToParty,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._SoldToParty AS _SoldToParty,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.CustomerGroup AS CustomerGroup,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._CustomerGroup AS _CustomerGroup,
cast(coalesce(ItemPartner.ShipToParty, HeaderPartner.ShipToParty) as kunwe) AS ShipToParty,
cast(coalesce(ItemPartner.BillToParty, HeaderPartner.BillToParty) as kunre) AS BillToParty,
cast(coalesce(ItemPartner.PayerParty, HeaderPartner.PayerParty) as kunrg) AS PayerParty,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
SalesSchedgAgrmtItem.MaterialByCustomer AS MaterialByCustomer,
SalesSchedgAgrmtItem.Division AS Division,
SalesSchedgAgrmtItem._Division AS _Division,
SalesSchedgAgrmtItem.Plant AS Plant,
SalesSchedgAgrmtItem._Plant AS _Plant,
cast( SalesSchedgAgrmtItem.Material as productnumber preserving type ) AS Product,
cast( SalesSchedgAgrmtItem.MaterialGroup as productgroup preserving type ) AS ProductGroup,
SalesSchedgAgrmtItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
SalesSchedgAgrmtItem._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
SalesSchedgAgrmtItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
SalesSchedgAgrmtItem._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
SalesSchedgAgrmtItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
SalesSchedgAgrmtItem._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
SalesSchedgAgrmtItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
SalesSchedgAgrmtItem._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
SalesSchedgAgrmtItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
SalesSchedgAgrmtItem._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.BillingCompanyCode AS BillingCompanyCode,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._BillingCompanyCode AS _BillingCompanyCode,
SalesSchedgAgrmtItem._SalesSchedgAgrmt.SalesDistrict AS SalesDistrict,
SalesSchedgAgrmtItem._SalesSchedgAgrmt._SalesDistrict AS _SalesDistrict,
SalesSchedgAgrmtDelivSched.CustomerFiscalYear AS CustomerFiscalYear,
SalesSchedgAgrmtItem.OrderQuantityUnit AS OrderQuantityUnit,
SalesSchedgAgrmtItem._OrderQuantityUnit AS _OrderQuantityUnit,
SalesSchedgAgrmtItem.BaseUnit AS BaseUnit,
SalesSchedgAgrmtItem._BaseUnit AS _BaseUnit,
SalesSchedgAgrmtCumltvQty.CumulativeDeliveredQuantity AS CumulativeDeliveredQuantity,
SalesSchedgAgrmtCumltvQty.CumulativeIssuedQuantity AS CumulativeIssuedQuantity,
SalesSchedgAgrmtDelivSched.CumulativeReceiptQuantity AS CumulativeReceiptQuantity
FROM I_SalesSchedgAgrmtItem AS SalesSchedgAgrmtItem
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesSchedulingAgreement = _Extension.SalesDocument AND SalesSchedulingAgreementItem = _Extension.SalesDocumentItem -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA