C_WhereUsdPrftCtrSlsOrderItem

DDL: C_WHEREUSDPRFTCTRSLSORDERITEM SQL: CWUPCSOI Type: view CONSUMPTION
29 Fields 1 Data Sources 1 Associations

Where-Used Profit Centers - Sales Order Item

C_WhereUsdPrftCtrSlsOrderItem is a Consumption CDS View that provides data about "Where-Used Profit Centers - Sales Order Item" in SAP S/4HANA. It reads from 1 data source (P_WhereUsdPrftCtrSlsOrderItem) and exposes 29 fields with key fields SalesDocument, SalesDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_WhereUsdPrftCtrSlsOrderItem P_WhereUsdPrftCtrSlsOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] dd07t _SDItemTypeText $projection.SalesDocumentItemType = _SDItemTypeText.domvalue_l and _SDItemTypeText.domname = 'POSAR' and _SDItemTypeText.as4local = 'A'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CWUPCSOI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Where-Used Profit Centers - Sales Order Item view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
NetAmount NetAmount Stated Amount
TransactionCurrency TransactionCurrency Transaction Currency
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
SoldToParty SoldToParty Sold-to Party
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SDDocumentCategory SDDocumentCategory Document Cat.
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
SalesDocumentItemType SalesDocumentItemType
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
SDProcessStatus SDProcessStatus
SDProcessStatusDesc SDProcessStatusDesc
DeliveryStatus DeliveryStatus Delivery Status
DeliveryStatusText DeliveryStatusText
TotalDeliveryStatus TotalDeliveryStatus
TotalDeliveryStatusDesc TotalDeliveryStatusDesc
ItemBillingIncompletionStatus ItemBillingIncompletionStatus
ItemBillingStatusText ItemBillingStatusText
SalesDocumentItemTypeText

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_WhereUsdPrftCtrSlsOrderItem.
-- 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: CWUPCSOI

CREATE VIEW C_WhereUsdPrftCtrSlsOrderItem AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  ControllingArea,
  ProfitCenter,
  NetAmount,
  TransactionCurrency,
  CreatedByUser,
  CreationDate,
  SoldToParty,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SDDocumentCategory,
  SalesDocumentType,
  SalesDocumentItemCategory,
  SalesDocumentItemType,
  CompanyCode,
  CompanyCodeName,
  SDProcessStatus,
  SDProcessStatusDesc,
  DeliveryStatus,
  DeliveryStatusText,
  TotalDeliveryStatus,
  TotalDeliveryStatusDesc,
  ItemBillingIncompletionStatus,
  ItemBillingStatusText,
  _SDItemTypeText[ 1: ddlanguage = $session.system_language ].ddtext AS SalesDocumentItemTypeText
FROM P_WhereUsdPrftCtrSlsOrderItem
LEFT OUTER JOIN dd07t AS _SDItemTypeText ON SalesDocumentItemType = _SDItemTypeText.domvalue_l AND _SDItemTypeText.domname = 'POSAR' AND _SDItemTypeText.as4local = 'A'  -- association [0..1]
;

Learn More