I_STRPBILLINGWITHREFACCTGDOC

CDS View

Billing Documents With Reference Accounting Document

I_STRPBILLINGWITHREFACCTGDOC is a CDS View in S/4HANA. Billing Documents With Reference Accounting Document. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SA_StRpTaxItemWthRefAcctgDoc view left_outer CONSUMPTION Tax Items for ACR Saudi Arabia with Accounting Ref Documents
C_StRpDocLineItemWthRefDoc view left_outer CONSUMPTION Tax Items with Reference Accounting Documents
I_StRpTaxItemWithRefAcctgDoc view left_outer COMPOSITE Tax Items with Reference Accounting Documents

Fields (1)

KeyField CDS FieldsUsed in Views
ReferenceSDDocument ReferenceSDDocument 2 
@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