C_SalesContractItemQry
Sales Contract Item - Query
C_SalesContractItemQry (Consumption)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
Sales
C_SalesContractItemQry is a Consumption CDS View that provides data about "Sales Contract Item - Query" in SAP S/4HANA. It reads from 1 data source (I_SalesContractItemCube) and exposes 102 fields with key fields SalesContract, SalesContractItem.
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Sales |
| Application Component | SD-ANA |
| Capabilities | Analytical Query |
| Package | Sales for SAP S/4HANA Cloud Private Edition |
| Description | <p>This CDS view provides the prerequisites for answering questions about various aspects of sales contracts. The example questions are:</p> <ul> <li><p>What is the target value or quantity of a given contact item?</p></li> <li><p>Which contracts are soon to be expired?</p></li> </ul> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesContractItemCube | I_SalesContractItemCube | from |
Parameters (2)
| Name | Type | Default |
|---|---|---|
| P_ExchangeRateType | kurst | |
| P_DisplayCurrency | vdm_v_display_currency |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Sales Contract Item - Query | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| AbapCatalog.sqlViewName | CSDSLSCONTRITMQ | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| Analytics.query | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_QUERY | view | |
| OData.publish | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (102)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesContract | SalesContract | Sales Document | |
| KEY | SalesContractItem | SalesContractItem | Sales Contract Item | |
| SalesContractType | SalesContractType | Sales Document Type | ||
| SalesContractItemType | SalesContractItemType | Item Type | ||
| SalesContractItemCategory | SalesContractItemCategory | Sales Document Item Category | ||
| CreatedByUser | CreatedByUser | Name of Person Responsible for Creating the Object | ||
| CreationDate | CreationDate | Record Created On | ||
| CreationTime | CreationTime | Time at Which Record Was Created | ||
| LastChangeDate | LastChangeDate | Last Changed On | ||
| CreationDateYear | CreationDateYear | Year of Creation | ||
| CreationDateYearQuarter | CreationDateYearQuarter | Year/Quarter of Creation | ||
| CreationDateYearMonth | CreationDateYearMonth | Year/Month of Creation | ||
| SalesContractValidityStartDate | SalesContractValidityStartDate | Valid-From Date (Outline Agreements, Product Proposals) | ||
| SalesContractValidityEndDate | SalesContractValidityEndDate | Valid-To Date (Outline Agreements, Product Proposals) | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| DistributionChannel | DistributionChannel | Distribution Channel | ||
| OrganizationDivision | OrganizationDivision | Organization Division | ||
| SalesOffice | SalesOffice | Sales Office | ||
| SalesGroup | SalesGroup | Sales Group | ||
| PartnerCompany | PartnerCompany | Company ID of Trading Partner | ||
| SoldToParty | SoldToParty | Sold-to Party | ||
| CustomerGroup | CustomerGroup | Customer Group | ||
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | Customer Group 1 | ||
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | Customer Group 2 | ||
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | Customer Group 3 | ||
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | Customer Group 4 | ||
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | Customer Group 5 | ||
| SDDocumentReason | SDDocumentReason | Order Reason (Reason for the Business Transaction) | ||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | Purchase Order Number | ||
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | Customer Reference Date | ||
| SalesContractItemText | SalesContractItemText | Short text for sales order item | ||
| SalesDocumentRjcnReason | SalesDocumentRjcnReason | Reason for Rejection of Sales Documents | ||
| ShipToParty | ShipToParty | Ship-To Party (obsolete) | ||
| SalesEmployee | SalesEmployee | Sales Employee | ||
| ResponsibleEmployee | ResponsibleEmployee | Employee Responsible | ||
| Product | Product | Product Number | ||
| ProductGroup | ProductGroup | Product Sold Group | ||
| AdditionalMaterialGroup1 | AdditionalMaterialGroup1 | Material Group 1 | ||
| AdditionalMaterialGroup2 | AdditionalMaterialGroup2 | Material Group 2 | ||
| AdditionalMaterialGroup3 | AdditionalMaterialGroup3 | Material Group 3 | ||
| AdditionalMaterialGroup4 | AdditionalMaterialGroup4 | Material Group 4 | ||
| AdditionalMaterialGroup5 | AdditionalMaterialGroup5 | Material Group 5 | ||
| Division | Division | Internal Division ID | ||
| Plant | Plant | Plant (Own or External) | ||
| StorageLocation | StorageLocation | Storage Location | ||
| MainItemPricingRefProduct | MainItemPricingRefProduct | Pricing Reference Product of Main Item | ||
| HigherLevelItem | HigherLevelItem | Higher-Level Item in Bill of Material Structures | ||
| BillOfMaterial | BillOfMaterial | Bill of Material | ||
| PropagatePrftbltySgmt2BOM | PropagatePrftbltySgmt2BOM | Propagate Profitability Segment to BOM (Sales Kit) Sub-Items | ||
| CostDeterminationIsRequired | CostDeterminationIsRequired | Determine cost | ||
| PricingDate | PricingDate | Date for Pricing and Exchange Rate | ||
| SalesDistrict | SalesDistrict | Sales District | ||
| CustomerPaymentTerms | CustomerPaymentTerms | Terms of Payment Key | ||
| PaymentMethod | PaymentMethod | Payment Method | ||
| BillingCompanyCode | BillingCompanyCode | Company Code to Be Billed | ||
| BillingDocumentDate | BillingDocumentDate | Billing Date | ||
| FiscalYear | FiscalYear | G/L Fiscal Year | ||
| FiscalPeriod | FiscalPeriod | Posting Period | ||
| BusinessArea | BusinessArea | Business Area | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| CustomerAccountAssignmentGroup | CustomerAccountAssignmentGroup | Account Assignment Group for Customer | ||
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | Reference Document Category | ||
| ReferenceSDDocument | ReferenceSDDocument | Document Number of Reference Document | ||
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | Item number of the reference item | ||
| DisplayCurrency | DisplayCurrency | Display Currency | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| BaseUnit | BaseUnit | Base Unit of Measure | ||
| SalesContractTargetAmountInDC | SalesContractTargetAmountInDC | Target Value of Sales Contracts in Display Currency | ||
| SalesContractTargetQuantity | SalesContractTargetQuantity | Target Quantity of Sales Contract Items | ||
| IncomingSlsContractNetAmtInDC | IncomingSlsContractNetAmtInDC | Incoming Sales Contracts Net Value in Display Currency | ||
| IncomingSlsContractQuantity | IncomingSlsContractQuantity | Quantity of Incoming Sales Contract Items | ||
| SalesContractReleasedAmtInDC | SalesContractReleasedAmtInDC | Released Value in Sales Contracts in Display Currency | ||
| SalesContractFulfillmentRate | 1 | Contract Fulfillment Rate | ||
| OverallSDProcessStatus | OverallSDProcessStatus | Overall Processing Status (Header/All Items) | ||
| OverallSDDocumentRejectionSts | OverallSDDocumentRejectionSts | Rejection Status (All Items) | ||
| TotalBlockStatus | TotalBlockStatus | Overall Block Status (Header) | ||
| OverallDelivConfStatus | OverallDelivConfStatus | Delivery Confirmation Status (All Items) | ||
| OverallTotalDeliveryStatus | OverallTotalDeliveryStatus | Overall Delivery Status (All Items) | ||
| OverallDeliveryStatus | OverallDeliveryStatus | Delivery Status (All Items) | ||
| OverallDeliveryBlockStatus | OverallDeliveryBlockStatus | Overall Delivery Block Status (All Items) | ||
| OverallOrdReltdBillgStatus | OverallOrdReltdBillgStatus | Order-Related Billing Status (All Items) | ||
| OverallBillingBlockStatus | OverallBillingBlockStatus | Billing Block Status (All Items) | ||
| OverallTotalSDDocRefStatus | OverallTotalSDDocRefStatus | Overall Reference Status (All Items) | ||
| OverallSDDocReferenceStatus | OverallSDDocReferenceStatus | Reference Status (All Items) | ||
| HdrGeneralIncompletionStatus | HdrGeneralIncompletionStatus | Incompletion Status (Header) | ||
| HeaderDelivIncompletionStatus | HeaderDelivIncompletionStatus | Delivery Incompletion Status (Header) | ||
| HeaderBillgIncompletionStatus | HeaderBillgIncompletionStatus | Billing Incompletion Status (Header) | ||
| OvrlItmGeneralIncompletionSts | OvrlItmGeneralIncompletionSts | Incompletion Status (All Items) | ||
| OvrlItmBillingIncompletionSts | OvrlItmBillingIncompletionSts | Billing Incompletion Status (All Items) | ||
| OvrlItmDelivIncompletionSts | OvrlItmDelivIncompletionSts | Delivery Incompletion Status (All Items) | ||
| SDProcessStatus | SDProcessStatus | Overall Processing Status (Item) | ||
| DeliveryConfirmationStatus | DeliveryConfirmationStatus | Delivery Confirmation Status (Item) | ||
| TotalDeliveryStatus | TotalDeliveryStatus | Overall Delivery Status (Item) | ||
| DeliveryStatus | DeliveryStatus | Delivery Status (Item) | ||
| DeliveryBlockStatus | DeliveryBlockStatus | Delivery Block Status (Item) | ||
| OrderRelatedBillingStatus | OrderRelatedBillingStatus | Order-Related Billing Status (Item) | ||
| BillingBlockStatus | BillingBlockStatus | Billing Block Status (Item) | ||
| ItemGeneralIncompletionStatus | ItemGeneralIncompletionStatus | Incompletion Status (Item) | ||
| ItemBillingIncompletionStatus | ItemBillingIncompletionStatus | Billing Incompletion Status (Item) | ||
| ItemDeliveryIncompletionStatus | ItemDeliveryIncompletionStatus | Delivery Incompletion Status (Item) | ||
| SDDocumentRejectionStatus | SDDocumentRejectionStatus | Rejection Status (Item) | ||
| TotalSDDocReferenceStatus | TotalSDDocReferenceStatus | Overall Reference Status (Item) |
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 C_SalesContractItemQry.
-- 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.
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency
CREATE VIEW C_SalesContractItemQry AS
SELECT
SalesContract,
SalesContractItem,
SalesContractType,
SalesContractItemType,
SalesContractItemCategory,
CreatedByUser,
CreationDate,
CreationTime,
LastChangeDate,
CreationDateYear,
CreationDateYearQuarter,
CreationDateYearMonth,
SalesContractValidityStartDate,
SalesContractValidityEndDate,
SalesOrganization,
DistributionChannel,
OrganizationDivision,
SalesOffice,
SalesGroup,
PartnerCompany,
SoldToParty,
CustomerGroup,
AdditionalCustomerGroup1,
AdditionalCustomerGroup2,
AdditionalCustomerGroup3,
AdditionalCustomerGroup4,
AdditionalCustomerGroup5,
SDDocumentReason,
PurchaseOrderByCustomer,
CustomerPurchaseOrderDate,
SalesContractItemText,
SalesDocumentRjcnReason,
ShipToParty,
SalesEmployee,
ResponsibleEmployee,
Product,
ProductGroup,
AdditionalMaterialGroup1,
AdditionalMaterialGroup2,
AdditionalMaterialGroup3,
AdditionalMaterialGroup4,
AdditionalMaterialGroup5,
Division,
Plant,
StorageLocation,
MainItemPricingRefProduct,
HigherLevelItem,
BillOfMaterial,
PropagatePrftbltySgmt2BOM,
CostDeterminationIsRequired,
PricingDate,
SalesDistrict,
CustomerPaymentTerms,
PaymentMethod,
BillingCompanyCode,
BillingDocumentDate,
FiscalYear,
FiscalPeriod,
BusinessArea,
ProfitCenter,
CustomerAccountAssignmentGroup,
ReferenceSDDocumentCategory,
ReferenceSDDocument,
ReferenceSDDocumentItem,
DisplayCurrency,
TransactionCurrency,
BaseUnit,
SalesContractTargetAmountInDC,
SalesContractTargetQuantity,
IncomingSlsContractNetAmtInDC,
IncomingSlsContractQuantity,
SalesContractReleasedAmtInDC,
1 AS SalesContractFulfillmentRate,
OverallSDProcessStatus,
OverallSDDocumentRejectionSts,
TotalBlockStatus,
OverallDelivConfStatus,
OverallTotalDeliveryStatus,
OverallDeliveryStatus,
OverallDeliveryBlockStatus,
OverallOrdReltdBillgStatus,
OverallBillingBlockStatus,
OverallTotalSDDocRefStatus,
OverallSDDocReferenceStatus,
HdrGeneralIncompletionStatus,
HeaderDelivIncompletionStatus,
HeaderBillgIncompletionStatus,
OvrlItmGeneralIncompletionSts,
OvrlItmBillingIncompletionSts,
OvrlItmDelivIncompletionSts,
SDProcessStatus,
DeliveryConfirmationStatus,
TotalDeliveryStatus,
DeliveryStatus,
DeliveryBlockStatus,
OrderRelatedBillingStatus,
BillingBlockStatus,
ItemGeneralIncompletionStatus,
ItemBillingIncompletionStatus,
ItemDeliveryIncompletionStatus,
SDDocumentRejectionStatus,
TotalSDDocReferenceStatus
FROM I_SalesContractItemCube
;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