C_OpnSlsOrdAboveThreshold

DDL: C_OPNSLSORDABOVETHRESHOLD SQL: CGRCNPSOR Type: view CONSUMPTION
37 Fields 1 Data Sources 1 Associations

Open Sales Orders Above Threshold

C_OpnSlsOrdAboveThreshold is a Consumption CDS View that provides data about "Open Sales Orders Above Threshold" in SAP S/4HANA. It reads from 1 data source (P_SalesOrdersDeliveryDate) and exposes 37 fields with key fields SalesDocument, SalesDocumentItem, ScheduleLine. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_SalesOrdersDeliveryDate P_SalesOrdersDeliveryDate from

Parameters (2)

NameTypeDefault
P_StartDate edatu
P_DeliveryDateOffsetInDays far_number

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SalesDocumentBasic _SalesDocumentBasic $projection.SalesDocument = _SalesDocumentBasic.SalesDocument

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCNPSOR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Open Sales Orders Above Threshold view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
KEY ScheduleLine ScheduleLine Schedule Line
SalesDocumentItemUUID SalesDocumentItemUUID
SalesDocumentItemText SalesDocumentItemText Item Descr.
SoldToParty _SalesDocumentBasic SoldToParty Sold-to Party
CustomerName
DeliveryDate DeliveryDate Delivery Date
CurrentDate CurrentDate Current Date
DeliveryDateOffsetInDays DeliveryDateOffsetInDays Days between delivery and current date
SalesDocumentType SalesDocumentType Sales Doc. Type
OrganizationDivision OrganizationDivision Org. Division
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SDDocumentCategory SDDocumentCategory Document Cat.
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
SalesDocumentItemType SalesDocumentItemType
IsReturnsItem IsReturnsItem Returns Item
CompletionRule CompletionRule
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
Division Division Internal Division ID
Product Product Product Sold
_Product _Product
_SalesDocument _SalesDocument
_SDDocumentCategory _SDDocumentCategory
_ItemCategory _ItemCategory
_Division _Division
_SalesDocumentType _SalesDocumentType
_OrganizationDivision _OrganizationDivision
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_ProductText _ProductText
_SoldToParty _SalesDocumentBasic _SoldToParty
_SalesDocumentBasic _SalesDocumentBasic

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_OpnSlsOrdAboveThreshold.
-- 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.
-- SQL view name: CGRCNPSOR
-- Parameters: P_StartDate : edatu, P_DeliveryDateOffsetInDays : far_number

CREATE VIEW C_OpnSlsOrdAboveThreshold AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  SalesDocumentItemUUID,
  SalesDocumentItemText,
  _SalesDocumentBasic.SoldToParty AS SoldToParty,
  _SalesDocumentBasic._SoldToParty.CustomerName AS CustomerName,
  DeliveryDate,
  CurrentDate,
  DeliveryDateOffsetInDays,
  SalesDocumentType,
  OrganizationDivision,
  SalesOrganization,
  DistributionChannel,
  SDDocumentCategory,
  SalesDocumentItemCategory,
  SalesDocumentItemType,
  IsReturnsItem,
  CompletionRule,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  Division,
  Product,
  _SalesDocumentBasic._SoldToParty AS _SoldToParty
FROM P_SalesOrdersDeliveryDate
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocumentBasic ON SalesDocument = _SalesDocumentBasic.SalesDocument  -- association [0..1]
;

Learn More