C_SalesOrderItemIncompleteQ

DDL: C_SALESORDERITEMINCOMPLETEQ SQL: CSLSORDITEMSO01Q Type: view CONSUMPTION Package: VDM_SD_SOF_OLD
37 Fields 1 Data Sources

SOFM Incomplete Sales Order Item Query

C_SalesOrderItemIncompleteQ is a Consumption CDS View that provides data about "SOFM Incomplete Sales Order Item Query" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderItemIncomplete) and exposes 37 fields with key fields SalesOrder, SalesOrderItem. Part of development package VDM_SD_SOF_OLD.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderItemIncomplete I_SalesOrderItemIncomplete from

Parameters (2)

NameTypeDefault
P_Language sylangu
P_ReferenceDate sydate

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SOFM Incomplete Sales Order Item Query view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName CSLSORDITEMSO01Q view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
DueDays DueDays Processing Time
SalesOrderType SalesOrderType Sales Order Type
SalesOrderItemCategory SalesOrderItemCategory Item Category
SalesOrderItemCategoryName
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
Material Material Vehicle Model
MaterialName
ProductionPlant Plant Valuation Area
PlantName PlantName Plant Name
SalesOrderItemText SalesOrderItemText Item Descr.
OrderQuantity OrderQuantity Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
TargetQuantity TargetQuantity Target Quantity
TargetQuantityUnit TargetQuantityUnit Target Qty UoM
NetAmount NetAmount Stated Amount
TransactionCurrency TransactionCurrency Transaction Currency
ShippingPoint ShippingPoint Shipping Point
ShippingPointName
Route Route Vehicle route
RouteName
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus
ItemGenIncompletionStatusDesc
ItemBillingIncompletionStatus ItemBillingIncompletionStatus
ItemBillingIncompletionStsDesc
PricingIncompletionStatus PricingIncompletionStatus
PricingIncompletionStatusDesc
ItemDeliveryIncompletionStatus ItemDeliveryIncompletionStatus
ItemDelivIncompletionStsDesc
ShipToParty
ShipToPartyName ShipToPartyName Ship-To Party Name
_TransactionCurrency _TransactionCurrency
_OrderQuantityUnit _OrderQuantityUnit
_TargetQuantityUnit _TargetQuantityUnit

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_SalesOrderItemIncompleteQ.
-- 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: CSLSORDITEMSO01Q
-- Parameters: P_Language : sylangu, P_ReferenceDate : sydate

CREATE VIEW C_SalesOrderItemIncompleteQ AS
SELECT
  SalesOrder,
  SalesOrderItem,
  DueDays,
  SalesOrderType,
  SalesOrderItemCategory,
  _ItemCategory._Text[1: Language=$parameters.P_Language].SalesDocumentItemCategoryName AS SalesOrderItemCategoryName,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Material,
  _Material._Text[1: Language=$parameters.P_Language].MaterialName AS MaterialName,
  Plant AS ProductionPlant,
  PlantName,
  SalesOrderItemText,
  OrderQuantity,
  OrderQuantityUnit,
  TargetQuantity,
  TargetQuantityUnit,
  NetAmount,
  TransactionCurrency,
  ShippingPoint,
  _ShippingPoint._Text[1: Language=$parameters.P_Language].ShippingPointName AS ShippingPointName,
  Route,
  _Route._Text[1: Language=$parameters.P_Language].RouteName AS RouteName,
  ItemGeneralIncompletionStatus,
  _ItemGeneralIncompletionStatus._Text[1: Language=$parameters.P_Language].ItemGenIncompletionStatusDesc AS ItemGenIncompletionStatusDesc,
  ItemBillingIncompletionStatus,
  _ItemBillingIncompletionStatus._Text[1: Language=$parameters.P_Language].ItemBillingIncompletionStsDesc AS ItemBillingIncompletionStsDesc,
  PricingIncompletionStatus,
  _PricingIncompletionStatus._Text[1: Language=$parameters.P_Language].PricingIncompletionStatusDesc AS PricingIncompletionStatusDesc,
  ItemDeliveryIncompletionStatus,
  _ItemDelivIncompletionSts._Text[1: Language=$parameters.P_Language].ItemDelivIncompletionStsDesc AS ItemDelivIncompletionStsDesc,
  ShipToPartyName
FROM I_SalesOrderItemIncomplete
;

Learn More