P_RU_AcctgDocReferenceID

DDL: P_RU_ACCTGDOCREFERENCEID SQL: PRUACCDOCREFID Type: view CONSUMPTION

P_RU_AcctgDocReferenceID is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 29 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from

Annotations (7)

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

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
AccountingDocumentType AccountingDocumentType
DocumentDate DocumentDate
PostingDate PostingDate
TaxReportingDate TaxReportingDate
BusinessTransactionType BusinessTransactionType
AccountingDocumentCategory AccountingDocumentCategory
LedgerGroup LedgerGroup
ReverseDocument ReverseDocument
ReverseDocumentFiscalYear ReverseDocumentFiscalYear
ReferenceDocumentType ReferenceDocumentType
OriginalReferenceDocument OriginalReferenceDocument
OriginalReferenceDocumentNum
OriginalReferenceDocumentCntxt
DocumentReferenceID DocumentReferenceID
ReferenceIDType
ReferenceIDDocumentNumber
ReferenceIDDocumentYear
AccountingDocumentHeaderText AccountingDocumentHeaderText
HeaderTextType
HeaderTextDocumentNumber
HeaderTextDocumentYear
IsReversal IsReversal
IsReversed IsReversed
ReversalReferenceDocument ReversalReferenceDocument
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt
SenderLogicalSystem SenderLogicalSystem 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUACCDOCREFID'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_AcctgDocReferenceID
  as select from I_JournalEntry

{
  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
      AccountingDocumentType,
      DocumentDate,
      PostingDate,
      TaxReportingDate,
      BusinessTransactionType,
      AccountingDocumentCategory,
      LedgerGroup,
      ReverseDocument,
      ReverseDocumentFiscalYear,

      ReferenceDocumentType,                                                         //RMRP, ...

      OriginalReferenceDocument,
      substring(OriginalReferenceDocument,1,10)        as OriginalReferenceDocumentNum,
      substring(OriginalReferenceDocument,11,10)       as OriginalReferenceDocumentCntxt,

      DocumentReferenceID,
      substring(DocumentReferenceID,1,4)               as ReferenceIDType,           //GTD^, ...

      substring(DocumentReferenceID,5,10)              as ReferenceIDDocumentNumber,
      concat('20',substring(DocumentReferenceID,15,2)) as ReferenceIDDocumentYear,

      AccountingDocumentHeaderText,
      substring(AccountingDocumentHeaderText, 1, 4)    as HeaderTextType,            //RCU^, ...

      substring(AccountingDocumentHeaderText, 5, 10)   as HeaderTextDocumentNumber,
      substring(AccountingDocumentHeaderText, 15, 4)   as HeaderTextDocumentYear,

      IsReversal,
      IsReversed,
      ReversalReferenceDocument,
      ReversalReferenceDocumentCntxt,

      SenderLogicalSystem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More