P_Ru_FinDocStructuralDivision2

DDL: P_RU_FINDOCSTRUCTURALDIVISION2 SQL: PRUFINSTRDIVN2 Type: view CONSUMPTION

P_Ru_FinDocStructuralDivision2 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_AccountingDocument) and exposes 6 fields.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_AccountingDocument AccountingDocument from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUFINSTRDIVN2 view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
CompanyCode I_AccountingDocument CompanyCode
AccountingDocument I_AccountingDocument AccountingDocument
FiscalYear I_AccountingDocument FiscalYear
LineItemendasLineItem
ProfitCenter
BusinessArea 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUFINSTRDIVN2'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_Ru_FinDocStructuralDivision2 as select from I_AccountingDocument as AccountingDocument

 association[0..1] to P_Ru_FinDocStructuralDivision3 as _FinDocItem1 on
                           _FinDocItem1.CompanyCode        = AccountingDocument.CompanyCode and 
                           _FinDocItem1.AccountingDocument = AccountingDocument.AccountingDocument and
                           _FinDocItem1.FiscalYear         = AccountingDocument.FiscalYear 
                           
 association[0..1] to P_Ru_FinDocStructuralDivision4 as _FinDocItem2 on
                           _FinDocItem2.CompanyCode        = AccountingDocument.CompanyCode and 
                           _FinDocItem2.AccountingDocument = AccountingDocument.AccountingDocument and
                           _FinDocItem2.FiscalYear         = AccountingDocument.FiscalYear    
                              
{

  AccountingDocument.CompanyCode,
  AccountingDocument.AccountingDocument,
  AccountingDocument.FiscalYear,
  
  case when _FinDocItem1.LineItem is not null
       then _FinDocItem1.LineItem
       else _FinDocItem2.LineItem     
  end as LineItem,
            
  '' as  ProfitCenter,
  '' as  BusinessArea
  
}

Learn More