C_OrdWthoutChrgItmWrkflwInbox

DDL: C_ORDWTHOUTCHRGITMWRKFLWINBOX SQL: CSDSOWOCIWFINBOX Type: view CONSUMPTION Package: ODATA_SD_SALESORDER_WRF
11 Fields 1 Data Sources 1 Associations

Sls Ord Wthout Chrg Item Workflow Inbox

C_OrdWthoutChrgItmWrkflwInbox is a Consumption CDS View that provides data about "Sls Ord Wthout Chrg Item Workflow Inbox" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderWithoutChargeItem) and exposes 11 fields with key fields SalesOrderWithoutCharge, SalesOrderWithoutChargeItem. It has 1 association to related views. Part of development package ODATA_SD_SALESORDER_WRF.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderWithoutChargeItem I_SalesOrderWithoutChargeItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_SalesDocumentItemBasic _Extension $projection.SalesOrderWithoutCharge = _Extension.SalesDocument and $projection.SalesOrderWithoutChargeItem = _Extension.SalesDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSDSOWOCIWFINBOX view
AbapCatalog.preserveKey true view
EndUserText.label Sls Ord Wthout Chrg Item Workflow Inbox view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderWithoutCharge SalesOrderWithoutCharge
KEY SalesOrderWithoutChargeItem SalesOrderWithoutChargeItem
Product Product Product Sold
ProductName
OrderQuantity OrderQuantity Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
NetAmount NetAmount Stated Amount
TransactionCurrency TransactionCurrency Transaction Currency
_TransactionCurrency _TransactionCurrency
_SalesOrderWithoutCharge _SalesOrderWithoutCharge
_OrderQuantityUnit _OrderQuantityUnit

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_OrdWthoutChrgItmWrkflwInbox.
-- 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: CSDSOWOCIWFINBOX

CREATE VIEW C_OrdWthoutChrgItmWrkflwInbox AS
SELECT
  SalesOrderWithoutCharge,
  SalesOrderWithoutChargeItem,
  Product,
  _Product._Text[1: Language=$session.system_language ].ProductName AS ProductName,
  OrderQuantity,
  OrderQuantityUnit,
  NetAmount,
  TransactionCurrency
FROM I_SalesOrderWithoutChargeItem
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrderWithoutCharge = _Extension.SalesDocument AND SalesOrderWithoutChargeItem = _Extension.SalesDocumentItem  -- association [0..1]
;

Learn More