P_AR_BRANCHPRINTCHAROFREFDOC

CDS View

Private View for fetching the RefDoc of specific length

P_AR_BRANCHPRINTCHAROFREFDOC is a CDS View in S/4HANA. Private View for fetching the RefDoc of specific length. It contains 8 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 8 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_AR_InvoiceAcctgDocuments view from COMPOSITE Relevant Documents Of Official Document Numbering
P_AR_InvoiceAcctgDocuments view union_all COMPOSITE Relevant Documents Of Official Document Numbering
P_AR_LatestRefDoc view left_outer COMPOSITE Private View Containaing the Latest Ref Doc

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AR_PrintCharacter AR_PrintCharacter 1
KEY Branch Branch 1
KEY BranchPrefix BranchPrefix 1
KEY CompanyCode CompanyCode 1
KEY DocumentClass DocumentClass 1
KEY DocumentReferenceID DocumentReferenceID 1
KEY FiscalYear FiscalYear 1 
@AbapCatalog.sqlViewName: 'PBRNCHPRNTREF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: 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
@VDM.private: true
//@EndUserText.label: 'Private View for fetching the RefDoc of specific length'

define view P_AR_BranchPrintCharOfRefDoc as select from P_AR_DocumentReferenceIDSplit 
{

 key P_AR_DocumentReferenceIDSplit.CompanyCode,
 key P_AR_DocumentReferenceIDSplit.AccountingDocument,
 key P_AR_DocumentReferenceIDSplit.FiscalYear,
 key P_AR_DocumentReferenceIDSplit.AccountingDocumentType,
 key P_AR_DocumentReferenceIDSplit.DocumentReferenceID,
     P_AR_DocumentReferenceIDSplit.ReportingDate,
     P_AR_DocumentReferenceIDSplit.DocumentClass,
     
     P_AR_DocumentReferenceIDSplit.BranchPrefix,
     P_AR_DocumentReferenceIDSplit.Branch,
     P_AR_DocumentReferenceIDSplit.AR_PrintCharacter,
     
     cast( P_AR_DocumentReferenceIDSplit.AR_OfficialDocumentNumber as abap.numc( 8 ) ) as AR_OfficialDocumentNumber

}
  where 
    ( P_AR_DocumentReferenceIDSplit.refdoc = 13 or P_AR_DocumentReferenceIDSplit.refdoc = 14 ) 
    and ( P_AR_DocumentReferenceIDSplit.DocumentClass is not null or ( CompanyCode is null or CompanyCode = '' ) )
    // this filter is added in order to do not select the non-int official document numbers

    and ( P_AR_DocumentReferenceIDSplit.AR_OfficialDocumentNumber >= '00000000' and P_AR_DocumentReferenceIDSplit.AR_OfficialDocumentNumber <= '99999999' )

Learn More