P_ComSDOpenBillingPlan

DDL: P_COMSDOPENBILLINGPLAN SQL: PCOMSDBPOPEN Type: view BASIC Package: VDM_CPM_WS

Sales Order Item Open Billing Plan

P_ComSDOpenBillingPlan is a Basic CDS View that provides data about "Sales Order Item Open Billing Plan" in SAP S/4HANA. It reads from 3 data sources (fpla, fplt, vbkd) and exposes 6 fields. Part of development package VDM_CPM_WS.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
fpla fpla from
fplt fplt inner
vbkd vbkd inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCOMSDBPOPEN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
SalesOrder fpla vbeln
SalesOrderItem vbkd posnr
BillingDate fplt afdat
BillingPlan fpla fplnr
BillingPlanItem fplt fpltr
SDDocumentStatus fplt fksaf 
@AbapCatalog.sqlViewName: 'PCOMSDBPOPEN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
define view P_ComSDOpenBillingPlan as select from fpla

inner join fplt on fpla.fplnr = fplt.fplnr 
inner join vbkd on fpla.fplnr = vbkd.fplnr 

{ 
  fpla.vbeln as SalesOrder,                                       
  vbkd.posnr as SalesOrderItem, 
  fplt.afdat as BillingDate,
  fpla.fplnr as BillingPlan,
  fplt.fpltr as BillingPlanItem,
  fplt.fksaf as SDDocumentStatus
  
} where vbkd.posnr != '000000' and ( fplt.fksaf = 'A' or fplt.fksaf = 'B')

Learn More