P_BusSolnOrdItmFinData

DDL: P_BUSSOLNORDITMFINDATA SQL: PBSOLNORDITMFNDT Type: view COMPOSITE
47 Fields 1 Data Sources 2 Associations

P_BusSolnOrdItmFinData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 47 fields with key fields ServiceObjectType, BusinessSolutionOrder, BusinessSolutionOrderItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Associations (2)

CardinalityTargetAliasCondition
[1] P_BusinessSolnOrdItmFinData _ServiceDocLinItmFinData $projection.BusinessSolutionOrder = _ServiceDocLinItmFinData.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _ServiceDocLinItmFinData.BusinessSolutionOrderItem
[1] P_BusSolnOrdItmWithHdrStat _SolnOrdHdrStat $projection.ServiceObjectType = _SolnOrdHdrStat.ServiceObjectType and $projection.BusinessSolutionOrder = _SolnOrdHdrStat.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _SolnOrdHdrStat.BusinessSolutionOrderItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PBSOLNORDITMFNDT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY BusinessSolutionOrder ServiceDocument Transaction ID
KEY BusinessSolutionOrderItem ServiceDocumentItem Service Document
BusSolnOrdType ServiceDocumentType Transaction Type
BusSolnOrdDescription ServiceDocumentDescription
BusSolnOrdItmDescription ServiceDocumentItemDescription
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SoldToParty SoldToParty Sold-to Party
Country SoldToPartyCountry
Region SoldToPartyRegion
BusSolnOrdItmStatus ServiceDocumentItemStatus
TransactionCurrency TransactionCurrency Transaction Currency
TotBusSolnOrdItmNetAmtPerPerd ServiceDocumentItemNetAmount
ServiceDocumentItemObjectType ServiceDocumentItemObjectType
CompanyCodeCurrency _ServiceDocLinItmFinData CompanyCodeCurrency Local Currency
RevenueAmountInCompanyCodeCrcy _ServiceDocLinItmFinData RevenueAmountInCompanyCodeCrcy
CostAmountInCompanyCodeCrcy _ServiceDocLinItmFinData CostAmountInCompanyCodeCrcy
RecognizedMarginAmtInCCCrcy _ServiceDocLinItmFinData RecognizedMarginAmtInCCCrcy
BusSolnOrdStatus _ServiceDocument ServiceDocumentStatus
PostingDate PostingDate Posting Date for GR
ServiceDocItemCategory ServiceDocItemCategory
Product Product Product Sold
ServiceDocumentCreationDate _ServiceDocument ServiceDocumentCreationDate
int4asNrOfOpenBusSolnOrders
int4asNrOfReldBusSolnOrders
int4asNrOfCmpltdBusSolnOrders
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SoldToParty _SoldToParty
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_TransactionCurrency _TransactionCurrency
_ServiceDocumentStatus _ServiceDocument _ServiceDocumentStatus
_SrvcDocLifecycleStatus _ServiceDocument _SrvcDocLifecycleStatus
_ServiceDocItemCategory _ServiceDocItemCategory
_Product _Product

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 P_BusSolnOrdItmFinData.
-- 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: PBSOLNORDITMFNDT

CREATE VIEW P_BusSolnOrdItmFinData AS
SELECT
  ServiceObjectType,
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceDocumentType AS BusSolnOrdType,
  ServiceDocumentDescription AS BusSolnOrdDescription,
  ServiceDocumentItemDescription AS BusSolnOrdItmDescription,
  DistributionChannel,
  Division,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  SoldToPartyCountry AS Country,
  SoldToPartyRegion AS Region,
  ServiceDocumentItemStatus AS BusSolnOrdItmStatus,
  TransactionCurrency,
  ServiceDocumentItemNetAmount AS TotBusSolnOrdItmNetAmtPerPerd,
  ServiceDocumentItemObjectType,
  _ServiceDocLinItmFinData.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ServiceDocLinItmFinData.RevenueAmountInCompanyCodeCrcy AS RevenueAmountInCompanyCodeCrcy,
  _ServiceDocLinItmFinData.CostAmountInCompanyCodeCrcy AS CostAmountInCompanyCodeCrcy,
  _ServiceDocLinItmFinData.RecognizedMarginAmtInCCCrcy AS RecognizedMarginAmtInCCCrcy,
  _ServiceDocument.ServiceDocumentStatus AS BusSolnOrdStatus,
  PostingDate,
  ServiceDocItemCategory,
  Product,
  _ServiceDocument.ServiceDocumentCreationDate AS ServiceDocumentCreationDate,
  cast( case when (_SolnOrdHdrStat. ServiceDocumentIsOpen = 'X' and _SolnOrdHdrStat.ServiceDocumentIsReleased = '') then 1 else 0 end as abap.int4 ) as NrOfOpenBusSolnOrders AS int4asNrOfOpenBusSolnOrders,
  cast( case when _SolnOrdHdrStat.ServiceDocumentIsReleased = 'X' then 1 else 0 end as abap.int4 ) as NrOfReldBusSolnOrders AS int4asNrOfReldBusSolnOrders,
  cast( case when (_SolnOrdHdrStat. ServiceDocumentIsOpen = '' and _SolnOrdHdrStat.ServiceDocumentIsReleased = '') then 1 else 0 end as abap.int4 ) as NrOfCmpltdBusSolnOrders AS int4asNrOfCmpltdBusSolnOrders,
  _ServiceDocument._ServiceDocumentStatus AS _ServiceDocumentStatus,
  _ServiceDocument._SrvcDocLifecycleStatus AS _SrvcDocLifecycleStatus
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN P_BusinessSolnOrdItmFinData AS _ServiceDocLinItmFinData ON BusinessSolutionOrder = _ServiceDocLinItmFinData.BusinessSolutionOrder AND BusinessSolutionOrderItem = _ServiceDocLinItmFinData.BusinessSolutionOrderItem  -- association [1]
LEFT OUTER JOIN P_BusSolnOrdItmWithHdrStat AS _SolnOrdHdrStat ON ServiceObjectType = _SolnOrdHdrStat.ServiceObjectType AND BusinessSolutionOrder = _SolnOrdHdrStat.BusinessSolutionOrder AND BusinessSolutionOrderItem = _SolnOrdHdrStat.BusinessSolutionOrderItem  -- association [1]
;

Learn More