C_SalesOrderWrkflwInbox

DDL: C_SALESORDERWRKFLWINBOX SQL: CSOWFIN Type: view CONSUMPTION
43 Fields 2 Data Sources 2 Associations

Sales Order Workflow Inbox

C_SalesOrderWrkflwInbox is a Consumption CDS View that provides data about "Sales Order Workflow Inbox" in SAP S/4HANA. It reads from 2 data sources (I_SalesOrderPartner, I_SalesOrder) and exposes 43 fields with key field SalesOrder. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SalesOrderPartner _Partner left_outer
I_SalesOrder SalesOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _ShipToParty _Partner.Customer = _ShipToParty.Customer
[0..*] C_SalesOrderItmWrkflwInbox _WorkflowInItem $projection.SalesOrder = _WorkflowInItem.SalesOrder

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSOWFIN view
EndUserText.label Sales Order Workflow Inbox view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.semanticObject SalesOrder view
UI.headerInfo.title.value DocumentTitle view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrder SalesOrder Order
SalesOrder01asDocumentTitle
CustomerName _SoldToParty CustomerName Name of Customer
SoldToParty SoldToParty Sold-to Party
ShipToPartyName _ShipToParty CustomerName Name of Customer
ShipToParty I_SalesOrderPartner Customer Ship-To Party
CityName _DfltAddrRprstn CityName City
CountryName
Country _DfltAddrRprstn Country Country or Region
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
TransactionCurrency TransactionCurrency Transaction Currency
TotalNetAmount TotalNetAmount Total Net Amount
SDDocumentReasonText
SDDocumentReason SDDocumentReason Order Reason
SDApprovalReasonName
SalesOrderApprovalReason SalesOrderApprovalReason Approval Request Reason
TotalCreditCheckStatusDesc
TotalCreditCheckStatus TotalCreditCheckStatus Overall Credit Status
SalesOrganizationName
SalesOrganization SalesOrganization Sales Organization
DistributionChannelName
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DivisionName
OrganizationDivision OrganizationDivision Org. Division
UserName _CreatedByUser UserDescription Full Name
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Created On
UserDescription _LastChangedByUser UserDescription Full Name
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Last Changed On
SalesOrderType SalesOrderType Sales Order Type
_WorkflowInItem _WorkflowInItem
_SoldToParty _SoldToParty
_TransactionCurrency _TransactionCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_OrganizationDivision _OrganizationDivision
_SalesOrderApprovalReason _SalesOrderApprovalReason
_TotalCreditCheckStatus _TotalCreditCheckStatus
_SDDocumentReason _SDDocumentReason
_SalesOrderType _SalesOrderType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_SalesOrderWrkflwInbox.
-- 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: CSOWFIN

CREATE VIEW C_SalesOrderWrkflwInbox AS
SELECT
  SalesOrder.SalesOrder AS SalesOrder,
  concat_with_space(concat_with_space(_SalesOrderType._Text[1: Language=$session.system_language].SalesDocumentTypeName, '-', 1), ltrim(SalesOrder.SalesOrder,'0'), 1) as DocumentTitle AS SalesOrder01asDocumentTitle,
  _SoldToParty.CustomerName AS CustomerName,
  SoldToParty,
  _ShipToParty.CustomerName AS ShipToPartyName,
  _Partner.Customer AS ShipToParty,
  _DfltAddrRprstn.CityName AS CityName,
  _DfltAddrRprstn._Country._Text[1: Language=$session.system_language ].CountryName AS CountryName,
  _DfltAddrRprstn.Country AS Country,
  PurchaseOrderByCustomer,
  TransactionCurrency,
  TotalNetAmount,
  _SDDocumentReason._Text[1: Language=$session.system_language ].SDDocumentReasonText AS SDDocumentReasonText,
  SDDocumentReason,
  _SalesOrderApprovalReason._SDApprovalReasonT[1: Language=$session.system_language ].SDApprovalReasonName AS SDApprovalReasonName,
  SalesOrderApprovalReason,
  _TotalCreditCheckStatus._Text[1: Language=$session.system_language ].TotalCreditCheckStatusDesc AS TotalCreditCheckStatusDesc,
  TotalCreditCheckStatus,
  _SalesOrganization._Text[1: Language=$session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  SalesOrganization,
  _DistributionChannel._Text[1: Language=$session.system_language ].DistributionChannelName AS DistributionChannelName,
  DistributionChannel,
  _OrganizationDivision._Text[1: Language=$session.system_language ].DivisionName AS DivisionName,
  OrganizationDivision,
  _CreatedByUser.UserDescription AS UserName,
  CreatedByUser,
  CreationDate,
  _LastChangedByUser.UserDescription AS UserDescription,
  LastChangedByUser,
  LastChangeDateTime,
  SalesOrderType
FROM I_SalesOrder AS SalesOrder
LEFT OUTER JOIN I_SalesOrderPartner AS _Partner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _ShipToParty ON _Partner.Customer = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_SalesOrderItmWrkflwInbox AS _WorkflowInItem ON SalesOrder = _WorkflowInItem.SalesOrder  -- association [0..*]
;

Learn More