P_BusSolnOrdHdrData

DDL: P_BUSSOLNORDHDRDATA SQL: PBUSSOLNORDDATA Type: view COMPOSITE
38 Fields 1 Data Sources 1 Associations

P_BusSolnOrdHdrData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 38 fields with key fields ServiceObjectType, BusinessSolutionOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentEnhcd I_ServiceDocumentEnhcd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _Period $projection.ServiceDocumentCreationDate = _Period.CalendarDate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PBUSSOLNORDDATA 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 (38)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY BusinessSolutionOrder ServiceDocument Transaction ID
BusSolnOrdType ServiceDocumentType Transaction Type
BusSolnOrdDescription ServiceDocumentDescription
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
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
TransactionCurrency TransactionCurrency Transaction Currency
BusSolnOrdStatus ServiceDocumentStatus
int4asNrOfOpenBusSolnOrders
int4asNrOfReldBusSolnOrders
int4asNrOfCmpltdBusSolnOrders
NrOfCrtedBusSolnOrders
ServiceDocNetAmount ServiceDocNetAmount
ServiceDocumentCreationDate ServiceDocumentCreationDate
BusSolnOrdCreationQuarter _Period CalendarQuarter Calendar Quarter
BusSolnOrdCreationMonth _Period CalendarMonth Calendar Month
BusSolnOrdCreationYear _Period CalendarYear Year
PostingDate PostingDate Posting Date for GR
_Period _Period
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SoldToParty _SoldToParty
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_TransactionCurrency _TransactionCurrency
_ServiceDocumentStatus _ServiceDocumentStatus
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus

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_BusSolnOrdHdrData.
-- 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: PBUSSOLNORDDATA

CREATE VIEW P_BusSolnOrdHdrData AS
SELECT
  ServiceObjectType,
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentType AS BusSolnOrdType,
  ServiceDocumentDescription AS BusSolnOrdDescription,
  DistributionChannel,
  Division,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  TransactionCurrency,
  ServiceDocumentStatus AS BusSolnOrdStatus,
  cast( case when (ServiceDocumentIsOpen = 'X' and ServiceDocumentIsReleased = '') then 1 else 0 end as abap.int4 ) as NrOfOpenBusSolnOrders AS int4asNrOfOpenBusSolnOrders,
  cast( case when ServiceDocumentIsReleased = 'X' then 1 else 0 end as abap.int4 ) as NrOfReldBusSolnOrders AS int4asNrOfReldBusSolnOrders,
  cast( case when (ServiceDocumentIsOpen = '' and ServiceDocumentIsReleased = '') then 1 else 0 end as abap.int4 ) as NrOfCmpltdBusSolnOrders AS int4asNrOfCmpltdBusSolnOrders,
  cast(1 as abap.int4) AS NrOfCrtedBusSolnOrders,
  ServiceDocNetAmount,
  ServiceDocumentCreationDate,
  _Period.CalendarQuarter AS BusSolnOrdCreationQuarter,
  _Period.CalendarMonth AS BusSolnOrdCreationMonth,
  _Period.CalendarYear AS BusSolnOrdCreationYear,
  PostingDate
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN I_CalendarDate AS _Period ON ServiceDocumentCreationDate = _Period.CalendarDate  -- association [0..1]
;

Learn More