P_RELATEDACCOUNTINGDOCUMENT

CDS View

Related Accounting Documents

P_RELATEDACCOUNTINGDOCUMENT is a CDS View in S/4HANA. Related Accounting Documents. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MatlLdgrDocToAcctgDocument view_entity from CONSUMPTION ML Document Related Accounting Documents 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Related Accounting Documents'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #XXL,
    dataClass: #TRANSACTIONAL
}
@VDM: {
  viewType: #COMPOSITE,
  private:true
}
define view entity P_RelatedAccountingDocument
  as select from I_JournalEntry
  association [0..1] to I_ReferenceDocumentType as _PrivatReferenceDocumentType on $projection.PrivatReferenceDocumentType = _PrivatReferenceDocumentType.ReferenceDocumentType
{
  key  ReferenceDocumentType,
  key  OriginalReferenceDocument,
  key  CompanyCode,
  key  FiscalYear,       
  key  AccountingDocument,
       AccountingDocumentType,
       DocumentDate,
       PostingDate,
       FiscalPeriod,
       AccountingDocumentCreationDate,
       CreationTime,
       LastChangeDate,
       ExchangeRateDate,
       AccountingDocCreatedByUser,
       TransactionCode,
       IntercompanyTransaction,
       DocumentReferenceID,
       RecurringAccountingDocument,
       ReverseDocument,
       ReverseDocumentFiscalYear,
       AccountingDocumentHeaderText,
       ExchangeRate,
       AccountingDocumentCategory,
       BusinessTransactionType,
       BatchInputSession,
       FinancialManagementArea,
       ReferenceDocumentLogicalSystem,
       Branch,
       IsDiscountDocument,
       Reference1InDocumentHeader,
       Reference2InDocumentHeader,
       InvoiceReceiptDate,
       Ledger,
       LedgerGroup,
       AlternativeReferenceDocument,
       IsReversal,
       IsReversed,
       TaxReportingDate,
       ReversalReason,
       ParkingDate,
       ParkingTime,
       CompanyCodeCurrency,
       AdditionalCurrency1,
       AdditionalCurrency2,
       TaxIsCalculatedAutomatically,
       NmbrOfPages,
       cast('BKPF' as fis_awtyp) as PrivatReferenceDocumentType,

       /* Associations */
       _AccountingDocumentCategory,
       _AccountingDocumentType,
       _AccountingDocumentTypeText,
       _AdditionalCurrency1,
       _AdditionalCurrency2,
       _BusinessTransactionType,
       _BusinessTransactionTypeText,
       _CompanyCode,
       _CompanyCodeCurrency,
       _FiscalYear,
       _Ledger,
       _LedgerGroup,
       _LedgerText,
       _OperationalAcctgDocItem,
       _ReferenceDocumentType,
       _PrivatReferenceDocumentType,
       _User
}

Learn More