P_BusSolnOrdItemData

DDL: P_BUSSOLNORDITEMDATA Type: view_entity COMPOSITE Package: CRMS4_ANALYTICS_SOLUTION_ORDER

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. Part of development package CRMS4_ANALYTICS_SOLUTION_ORDER.

1 data source(s) 30 fields

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
KEY BusinessSolutionOrder ServiceDocument
KEY BusinessSolutionOrderItem ServiceDocumentItem
BusSolnOrdType ServiceDocumentType
BusSolnOrdDescription ServiceDocumentDescription
BusSolnOrdItmDescription ServiceDocumentItemDescription
TransactionCurrency TransactionCurrency
SoldToParty SoldToParty
Product Product
SalesOrganization SalesOrganization
SalesOffice SalesOffice
SalesGroup SalesGroup
DistributionChannel DistributionChannel
Division Division
BusSolnOrdItmStatus ServiceDocumentItemStatus
TotBusSolnOrdItmNetAmtPerPerd ServiceDocumentItemNetAmount
PostingDate PostingDate
ResponsibleEmployee ResponsibleEmployee
_ServiceDocumentType _ServiceDocumentType
_ServiceObjType _ServiceObjType
_TransactionCurrency _TransactionCurrency
_SoldToParty _SoldToParty
_Product _Product
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_RespEmployee _RespEmployee 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'P view for OVP Card'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM: {
   private:true,
   viewType: #COMPOSITE
}
define view entity P_BusSolnOrdItemData
  as select from I_ServiceDocumentItemEnhcd
{
      @ObjectModel.foreignKey.association: '_ServiceObjType'
  key ServiceObjectType,
  key ServiceDocument                as BusinessSolutionOrder,
  key ServiceDocumentItem            as BusinessSolutionOrderItem,
      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
      ServiceDocumentType                                         as BusSolnOrdType,
      @Semantics.text: true
      ServiceDocumentDescription     as BusSolnOrdDescription,
      @Semantics.text: true
      ServiceDocumentItemDescription as BusSolnOrdItmDescription,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      //    @Semantics.currencyCode:true

      TransactionCurrency,
      @ObjectModel.foreignKey.association: '_SoldToParty'
      SoldToParty,
      @ObjectModel.foreignKey.association: '_Product'
      Product,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SalesOrganization,
            @ObjectModel.foreignKey.association: '_SalesOffice'
      SalesOffice,
      @ObjectModel.foreignKey.association: '_SalesGroup'
      SalesGroup,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      DistributionChannel,
      @ObjectModel.foreignKey.association: '_Division'
      Division,
      @ObjectModel.foreignKey.association: '_SrvcDocItmLifecycleStatus'
      ServiceDocumentItemStatus      as BusSolnOrdItmStatus,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      ServiceDocumentItemNetAmount   as TotBusSolnOrdItmNetAmtPerPerd,
      PostingDate,
      @ObjectModel.foreignKey.association: '_RespEmployee'
      ResponsibleEmployee,

      _ServiceDocumentType,
      _ServiceObjType,
      _TransactionCurrency,
      _SoldToParty,
      _Product,
      _SalesOrganization,
      _DistributionChannel,
      _Division,
      _SrvcDocItmLifecycleStatus,
      _SalesOffice,
      _SalesGroup,
      _RespEmployee



}

Learn More