P_BillingDocProcFlowCP1

DDL: P_BILLINGDOCPROCFLOWCP1 SQL: PBILLGDOPROCFCP1 Type: view CONSUMPTION

P_BillingDocProcFlowCP1 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentItem) and exposes 9 fields with key fields LevelCM1Document, LevelCM1DocumentItem, LevelCM1DocumentCategory, LevelC0Document, LevelC0DocumentItem.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentItem LevelCM1 inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PBILLGDOPROCFCP1 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LevelCM1Document I_BillingDocumentItem PrelimBillingDocument
KEY LevelCM1DocumentItem I_BillingDocumentItem PrelimBillingDocumentItem
KEY LevelCM1DocumentCategory
KEY LevelC0Document LevelC0 LevelC0Document
KEY LevelC0DocumentItem LevelC0 LevelC0DocumentItem
KEY LevelC0DocumentCategory LevelC0 LevelC0DocumentCategory
KEY BillingDocument LevelC0 BillingDocument
BillingDocumentType LevelC0 BillingDocumentType
SalesOrganization LevelC0 SalesOrganization 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PBILLGDOPROCFCP1'
define view P_BillingDocProcFlowCP1 
  as select distinct from P_BillingDocProcFlowC0 as LevelC0  --> Level 0 
    inner join            I_BillingDocumentItem as LevelCM1 --> Level Minus 1 (Check for Preliminary Billing Documents)
    on  LevelC0.LevelC0Document             = LevelCM1.BillingDocument
    and LevelC0.LevelC0DocumentItem         = LevelCM1.BillingDocumentItem
    and LevelCM1.PrelimBillingDocument      != ''
{
      //Key

  key LevelCM1.PrelimBillingDocument as LevelCM1Document,  
  key LevelCM1.PrelimBillingDocumentItem as LevelCM1DocumentItem,    
  key 'PBD' as LevelCM1DocumentCategory,
  key LevelC0.LevelC0Document,
  key LevelC0.LevelC0DocumentItem,
  key LevelC0.LevelC0DocumentCategory,

      //Billing Document

  key LevelC0.BillingDocument,  
      LevelC0.BillingDocumentType,

      //Organization

      LevelC0.SalesOrganization
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTITEM",
"P_BILLINGDOCPROCFLOWC0"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More