C_BusSolnPrtfloSlsOrderItm

DDL: C_BUSSOLNPRTFLOSLSORDERITM Type: view_entity CONSUMPTION
31 Fields 1 Data Sources 1 OData Services

BSP: Sales Order Item

C_BusSolnPrtfloSlsOrderItm is a Consumption CDS View that provides data about "BSP: Sales Order Item" in SAP S/4HANA. It reads from 1 data source (I_BusSolnPrtfloSlsOrderItmTP) and exposes 31 fields with key fields BusinessSolutionPortfolio, SalesOrder, SalesOrderItem. It is exposed through 1 OData service (C_BUSSOLUTIONPORTFOLIO_SRV).

Data Sources (1)

SourceAliasJoin Type
I_BusSolnPrtfloSlsOrderItmTP I_BusSolnPrtfloSlsOrderItmTP projection

Annotations (8)

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

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSSOLUTIONPORTFOLIO_SRV C_BUSSOLUTIONPORTFOLIO V2 C1 NOT_RELEASED

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionPortfolio BusinessSolutionPortfolio Transaction ID
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderType SalesOrderType Sales Order Type
OrganizationDivision OrganizationDivision Org. Division
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SalesOrderItemText _SalesOrderItem SalesOrderItemText
Material Material Vehicle Model
MaterialName MaterialName Material Description
MaterialByCustomer _SalesOrderItem MaterialByCustomer Customer Mat.
PurchaseOrderByCustomer _SalesOrderItem PurchaseOrderByCustomer Purchase Order Number
RequestedQuantity _SalesOrderItem RequestedQuantity Requested Quantity
RequestedQuantityUnit _SalesOrderItem RequestedQuantityUnit Requested Quantity Unit
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
CreationDate _SalesOrderItem CreationDate Time Stamp
NetAmount _SalesOrderItem NetAmount Stated Amount
TransactionCurrency _SalesOrderItem TransactionCurrency Transaction Currency
BusSolnPrtfloAssgdDocItmNetAmt BusSolnPrtfloAssgdDocItmNetAmt
Currency _BusinessSolutionPortfolio Currency Valuation Crcy
SDProcessStatus SDProcessStatus
SDProcessStatusDesc SDProcessStatusDesc
SalesOrderItemCategory SalesOrderItemCategory Item Category
SalesDocumentItemCategoryName SalesDocumentItemCategoryName
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
BusSolnPrtfloLastChgDateTime BusSolnPrtfloLastChgDateTime Timestamp
_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 C_BusSolnPrtfloSlsOrderItm.
-- 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 C_BusSolnPrtfloSlsOrderItm AS
SELECT
  BusinessSolutionPortfolio,
  SalesOrder,
  SalesOrderItem,
  SalesOrderType,
  OrganizationDivision,
  SalesOrganization,
  DistributionChannel,
  _SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  Material,
  MaterialName,
  _SalesOrderItem.MaterialByCustomer AS MaterialByCustomer,
  _SalesOrderItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SalesOrderItem.RequestedQuantity AS RequestedQuantity,
  _SalesOrderItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  RequestedDeliveryDate,
  _SalesOrderItem.CreationDate AS CreationDate,
  _SalesOrderItem.NetAmount AS NetAmount,
  _SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  BusSolnPrtfloAssgdDocItmNetAmt,
  _BusinessSolutionPortfolio.Currency AS Currency,
  SDProcessStatus,
  SDProcessStatusDesc,
  SalesOrderItemCategory,
  SalesDocumentItemCategoryName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  BusSolnPrtfloLastChgDateTime
FROM I_BusSolnPrtfloSlsOrderItmTP
;

Learn More