I_STRPBILLINGWITHREFSDDOCUMENT

CDS View

Billing Documents With Reference Documents

I_STRPBILLINGWITHREFSDDOCUMENT is a CDS View in S/4HANA. Billing Documents With Reference Documents. It contains 3 fields.

3 fields

Fields (3)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument 1
KEY SenderLogicalSystem SenderLogicalSystem 1
ReferenceSDDocument ReferenceSDDocument 1 
@AbapCatalog.sqlViewName: 'ISRBILLREFDOC'
@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 Documents'
define view I_StRpBillingWithRefSDDocument as select distinct from I_CFinBillingDocumentItem as _Item 
{
key _Item.CentralFinanceBillingDocument as BillingDocument,
key SenderLogicalSystem,
case
when ( _Item.ReferenceSDDocumentCategory = 'M' or
       _Item.ReferenceSDDocumentCategory = 'N' or
       _Item.ReferenceSDDocumentCategory = 'O'or
       _Item.ReferenceSDDocumentCategory = 'P' or
       _Item.ReferenceSDDocumentCategory = 'S' or
       _Item.ReferenceSDDocumentCategory = 'U' or
       _Item.ReferenceSDDocumentCategory = '5' or
       _Item.ReferenceSDDocumentCategory = '6' or
       _Item.ReferenceSDDocumentCategory = 'f' )
        then _Item.ReferenceSDDocument
        else 
             case when ( _CFinSalesDocumentItem.ReferenceSDDocumentCategory = 'M' or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = 'N' or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = 'O'or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = 'P' or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = 'S' or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = 'U' or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = '5' or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = '6' or
                         _CFinSalesDocumentItem.ReferenceSDDocumentCategory = 'f' )
                          then _CFinSalesDocumentItem.ReferenceSDDocument
             else _CFinBillingDocument.CancelledBillingDocument
             end
        end  as ReferenceSDDocument,
 _CFinBillingDocument.CompanyCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CFINBILLINGDOCUMENT",
"I_CFINBILLINGDOCUMENTITEM",
"I_CFINSALESDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More