P_Bpsddata

DDL: P_BPSDDATA SQL: PBPSDDATA Type: view BASIC

P_Bpsddata is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (fpla, fplt, vbkd) and exposes 16 fields with key fields fplnr, fpltr.

3 data source(s) 16 fields

Data Sources (3)

SourceAliasJoin Type
fpla _billingplan from
fplt _billingplandates inner
vbkd _sdbusdata inner

Annotations (6)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY fplnr fpla fplnr
KEY fpltr fplt fpltr
vbeln fpla vbeln
posnr vbkd posnr
source
afdat fplt afdat
faksp fplt faksp
fareg fplt fareg
fksaf fplt fksaf
autte fpla autte
fpart fpla fpart
fpttp fplt fpttp
fakwr fplt fakwr
waers fplt waers
mlbez fplt mlbez
tetxt fplt tetxt 
@AbapCatalog.sqlViewName: 'PBPSDDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE


define view P_Bpsddata as select from fpla as _billingplan
  inner join fplt as _billingplandates on _billingplan.fplnr = _billingplandates.fplnr 
  inner join vbkd as _sdbusdata on _billingplan.fplnr = _sdbusdata.fplnr {
  
  key _billingplan.fplnr,
  key _billingplandates.fpltr,
      _billingplan.vbeln,
      _sdbusdata.posnr,
      cast('SDI' as abap.char( 3 )) as source,
      _billingplandates.afdat,                      // BillingDate

      _billingplandates.faksp,                      // BillingBlockCode

      _billingplandates.fareg,                      // BillingRuleCode

      _billingplandates.fksaf ,                     // Status

      _billingplan.autte,                           // Advance 

      _billingplan.fpart,                           // Billing Plan TypeCode

      _billingplandates.fpttp,                      // Date CategoryCode

      _billingplandates.fakwr,                      // Amount

      _billingplandates.waers,                      // Currency

      _billingplandates.mlbez,                     // Milestone Code   

      _billingplandates.tetxt                       // Billing Plan DateDescCode

 
      
      
} where _sdbusdata.posnr != '000000' //excluding header

  and (_billingplandates.fksaf <> ' ' )


  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FPLA",
"FPLT",
"VBKD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More