P_BusSolnOrdItemData

DDL: P_BUSSOLNORDITEMDATA Type: view_entity COMPOSITE
30 Fields 1 Data Sources

P view for OVP Card

P_BusSolnOrdItemData is a Composite CDS View that provides data about "P view for OVP Card" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 30 fields with key fields ServiceObjectType, BusinessSolutionOrder, BusinessSolutionOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label P view for OVP Card view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (30)

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
TransactionCurrency TransactionCurrency Transaction Currency
SoldToParty SoldToParty Sold-to Party
Product Product Product Sold
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
BusSolnOrdItmStatus ServiceDocumentItemStatus
TotBusSolnOrdItmNetAmtPerPerd ServiceDocumentItemNetAmount
PostingDate PostingDate Posting Date for GR
ResponsibleEmployee ResponsibleEmployee Employee Resp.
_ServiceDocumentType _ServiceDocumentType
_ServiceObjType _ServiceObjType
_TransactionCurrency _TransactionCurrency
_SoldToParty _SoldToParty
_Product _Product
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_RespEmployee _RespEmployee

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_BusSolnOrdItemData.
-- 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 P_BusSolnOrdItemData AS
SELECT
  ServiceObjectType,
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceDocumentType AS BusSolnOrdType,
  ServiceDocumentDescription AS BusSolnOrdDescription,
  ServiceDocumentItemDescription AS BusSolnOrdItmDescription,
  TransactionCurrency,
  SoldToParty,
  Product,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  ServiceDocumentItemStatus AS BusSolnOrdItmStatus,
  ServiceDocumentItemNetAmount AS TotBusSolnOrdItmNetAmtPerPerd,
  PostingDate,
  ResponsibleEmployee
FROM I_ServiceDocumentItemEnhcd
;

Learn More