P_RU_VATInvcJrnlLinkIncgInvc

DDL: P_RU_VATINVCJRNLLINKINCGINVC SQL: PRUVATINVJLI Type: view CONSUMPTION

P_RU_VATInvcJrnlLinkIncgInvc is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, P_RU_BSET) and exposes 8 fields.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry AccountingDocument inner
P_RU_BSET TaxItem inner

Annotations (6)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
CompanyCode I_JournalEntry CompanyCode
AccountingDocument I_JournalEntry AccountingDocument
FiscalYear I_JournalEntry FiscalYear
RU_VATReturnVersion VATReportingCust RU_VATReturnVersion
RU_VATReturnSectionType VATReportingCust RU_VATReturnSectionType
RU_VATSubScenarioVersion VATReportingCust RU_VATSubScenarioVersion
RU_VATSubScenario VATReportingCust RU_VATSubScenario
RU_SupplierOutputType VATReportingCust RU_SupplierOutputType 
@AbapCatalog.sqlViewName: 'PRUVATINVJLI'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_VATInvcJrnlLinkIncgInvc
  as select distinct from P_RU_VATReportingCust as VATReportingCust

    inner join            P_RU_BSET             as TaxItem            on  VATReportingCust.TaxCode               = TaxItem.TaxCode
                                                                      and VATReportingCust.TaxItemClassification = TaxItem.TransactionTypeDetermination

    inner join            I_JournalEntry        as AccountingDocument on  AccountingDocument.CompanyCode            = TaxItem.CompanyCode
                                                                      and AccountingDocument.AccountingDocument     = TaxItem.AccountingDocument
                                                                      and AccountingDocument.FiscalYear             = TaxItem.FiscalYear
                                                                      and (
                                                                         AccountingDocument.AccountingDocumentType  = VATReportingCust.AccountingDocumentType //from customizing

                                                                         or VATReportingCust.AccountingDocumentType is null
                                                                       )

{
  AccountingDocument.CompanyCode,
  AccountingDocument.AccountingDocument,
  AccountingDocument.FiscalYear,
  VATReportingCust.RU_VATReturnVersion,
  VATReportingCust.RU_VATReturnSectionType,
  VATReportingCust.RU_VATSubScenarioVersion,
  VATReportingCust.RU_VATSubScenario,
  VATReportingCust.RU_SupplierOutputType
}
where
  RU_VATReturnSectionType = 'I'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"P_RU_BSET",
"P_RU_VATREPORTINGCUST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More