I_StRpBillingWithRefAcctgDoc

DDL: I_STRPBILLINGWITHREFACCTGDOC SQL: ISRBILLRACCDOC Type: view COMPOSITE

Billing Documents With Reference Accounting Document

I_StRpBillingWithRefAcctgDoc is a Composite CDS View that provides data about "Billing Documents With Reference Accounting Document" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 7 fields with key fields BillingDocument, SenderLogicalSystem.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry _JournalEntry left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISRBILLRACCDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Billing Documents With Reference Accounting Document view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_StRpBillingWithRefSDDocument BillingDocument
KEY SenderLogicalSystem I_StRpBillingWithRefSDDocument SenderLogicalSystem
ReferenceSDDocument I_StRpBillingWithRefSDDocument ReferenceSDDocument
AccountingDocument I_JournalEntry AccountingDocument
CompanyCode I_JournalEntry CompanyCode
FiscalYear I_JournalEntry FiscalYear
PostingDate I_JournalEntry PostingDate 
@AbapCatalog.sqlViewName: 'ISRBILLRACCDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Billing Documents With Reference Accounting Document'
define view I_StRpBillingWithRefAcctgDoc as select distinct from I_StRpBillingWithRefSDDocument

//left outer join I_BillingDocument as _Billing on I_StRpBillingWithRefSDDocument.ReferenceSDDocument = _Billing.BillingDocument

left outer join I_JournalEntry  as _JournalEntry   on  I_StRpBillingWithRefSDDocument.CompanyCode        = _JournalEntry.CompanyCode
                                                  and  ( I_StRpBillingWithRefSDDocument.ReferenceSDDocument = _JournalEntry.OriginalReferenceDocument
                                                         and ( _JournalEntry.OriginalReferenceDocument <> '') )
                                                  and _JournalEntry.AccountingDocumentCategory = ''
                                                  and  I_StRpBillingWithRefSDDocument.SenderLogicalSystem = _JournalEntry.SenderLogicalSystem

{
    key I_StRpBillingWithRefSDDocument.BillingDocument,
    key I_StRpBillingWithRefSDDocument.SenderLogicalSystem,
    I_StRpBillingWithRefSDDocument.ReferenceSDDocument,
    _JournalEntry.AccountingDocument,
    _JournalEntry.CompanyCode,
    _JournalEntry.FiscalYear,
    _JournalEntry.PostingDate 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_STRPBILLINGWITHREFSDDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More