P_CanclnBillingDocProcFlowM2

DDL: P_CANCLNBILLINGDOCPROCFLOWM2 SQL: PCBILLDOCPROCFM2 Type: view CONSUMPTION

P_CanclnBillingDocProcFlowM2 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentItem) and exposes 7 fields with key fields LevelM2Document, LevelM2DocumentItem, LevelM2DocumentCategory, BillingDocument.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentItem LevelM2 inner

Annotations (10)

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 PCBILLDOCPROCFM2 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY LevelM2Document ReferenceSDDocument
KEY LevelM2DocumentItem ReferenceSDDocumentItem
KEY LevelM2DocumentCategory ReferenceSDDocumentCategory
KEY BillingDocument LevelM1 BillingDocument
BillingDocumentType LevelM1 BillingDocumentType
SDDocumentCategory LevelM1 SDDocumentCategory
SalesOrganization LevelM1 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: 'PCBILLDOCPROCFM2'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true

define view P_CanclnBillingDocProcFlowM2
  as select distinct from P_CanclnBillingDocProcFlowM1 as LevelM1 --> Level 0
    inner join            I_BillingDocumentItem        as LevelM2 --> Level Minus1
                                                          on  LevelM2.BillingDocument = LevelM1.BillingDocument
                                                          and LevelM2.ReferenceSDDocument != ''
{
  key ReferenceSDDocument         as LevelM2Document,
  key ReferenceSDDocumentItem     as LevelM2DocumentItem,
  key ReferenceSDDocumentCategory as LevelM2DocumentCategory,


      //Billing Document

  key LevelM1.BillingDocument,
      LevelM1.BillingDocumentType,
      LevelM1.SDDocumentCategory,

      //Organization

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

Learn More