I_BusSolnPrtfloSlsOrderItmTP

DDL: I_BUSSOLNPRTFLOSLSORDERITMTP Type: view_entity TRANSACTIONAL
25 Fields 1 Data Sources 3 Associations

Transact. Process.: Sales Order Item

I_BusSolnPrtfloSlsOrderItmTP is a Transactional CDS View that provides data about "Transact. Process.: Sales Order Item" in SAP S/4HANA. It reads from 1 data source (I_BusSolnPrtfloSlsOrderItm) and exposes 25 fields with key fields BusinessSolutionPortfolio, SalesOrder, SalesOrderItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusSolnPrtfloSlsOrderItm I_BusSolnPrtfloSlsOrderItm from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SalesOrderItem _SalesOrderItem $projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
[0..1] I_SlsDocItemEnhancedFields _SalesOrderItemEnhancedFields $projection.SalesOrder = _SalesOrderItemEnhancedFields.SalesDocument and $projection.SalesOrderItem = _SalesOrderItemEnhancedFields.SalesDocumentItem
[0..1] I_SalesOrder _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder

Annotations (7)

NameValueLevelField
EndUserText.label Transact. Process.: Sales Order Item view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionPortfolio BusinessSolutionPortfolio Transaction ID
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
SalesOrderType
OrganizationDivision _SalesOrder OrganizationDivision Org. Division
SalesOrganization _SalesOrder SalesOrganization Sales Organization
DistributionChannel _SalesOrder DistributionChannel RefDistCh-Cust/Mat.
TransactionCurrency _SalesOrderItem TransactionCurrency Transaction Currency
Currency _BusinessSolutionPortfolio Currency Valuation Crcy
SoldToParty
SDProcessStatus _SalesOrderItem SDProcessStatus
SDProcessStatusDesc
Material
MaterialName
RequestedDeliveryDate
SalesOrderItemCategory _SalesOrderItem SalesOrderItemCategory Item Category
SalesDocumentItemCategoryName
BusSolnPrtfloLastChgDateTime _BusinessSolutionPortfolio LastChangeDateTime Timestamp
_BusinessSolutionPortfolio _BusinessSolutionPortfolio
_SalesOrderItem _SalesOrderItem
_SalesOrder _SalesOrder

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 I_BusSolnPrtfloSlsOrderItmTP.
-- 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.

CREATE VIEW I_BusSolnPrtfloSlsOrderItmTP AS
SELECT
  BusinessSolutionPortfolio,
  SalesOrder,
  SalesOrderItem,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  cast(_SalesOrder.SalesOrderType as auart_unv) AS SalesOrderType,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  _BusinessSolutionPortfolio.Currency AS Currency,
  _SalesOrder._SoldToParty._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS SoldToParty,
  _SalesOrderItem.SDProcessStatus AS SDProcessStatus,
  cast(_SalesOrderItem._SDProcessStatus._Text[1:Language = $session.system_language].SDProcessStatusDesc as bezei) AS SDProcessStatusDesc,
  cast(_SalesOrderItem.Material as matnr_trex) AS Material,
  _SalesOrderItem._MaterialText[1:Language=$session.system_language].MaterialName AS MaterialName,
  _SalesOrderItemEnhancedFields._RequestedDeliveryDate.RequestedDeliveryDate AS RequestedDeliveryDate,
  _SalesOrderItem.SalesOrderItemCategory AS SalesOrderItemCategory,
  _SalesOrderItem._ItemCategory._Text[1:Language = $session.system_language].SalesDocumentItemCategoryName AS SalesDocumentItemCategoryName,
  _BusinessSolutionPortfolio.LastChangeDateTime AS BusSolnPrtfloLastChgDateTime
FROM I_BusSolnPrtfloSlsOrderItm
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SlsDocItemEnhancedFields AS _SalesOrderItemEnhancedFields ON SalesOrder = _SalesOrderItemEnhancedFields.SalesDocument AND SalesOrderItem = _SalesOrderItemEnhancedFields.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
;

Learn More