P_AR_JOURNALENTRY

CDS View
35 Fields 16 CDS Views

P_AR_JOURNALENTRY is a CDS View in S/4HANA. It contains 35 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_AR_StRpJournalEntryTaxItem view from CONSUMPTION Journal Entry Tax Item for Argentina
C_AR_StRpODNInvoiceAcctgDocLog view_entity from CONSUMPTION AR ODN Log of Invoice Accounting Docs
C_AR_StRpVATPrintTaxDetailC view from CONSUMPTION Argentina VAT Print Tax Details - Cube
P_AR_CustomerSupplierEntry view_entity from CONSUMPTION
P_AR_EDplOtherPerceptionFilter view from CONSUMPTION
P_AR_ElectronicDplItemsFromFI view from CONSUMPTION
P_AR_ElectronicDplItemsFromSD view from CONSUMPTION
P_AR_JournalEntryLogDetail view from CONSUMPTION
P_AR_JrnlEntryWthOfclDocType view_entity from CONSUMPTION
P_AR_PurchaseTaxItem view from CONSUMPTION
P_AR_SalesFromSDWithZeroVAT view from CONSUMPTION
P_AR_SalesTaxItem view from CONSUMPTION
P_AR_StRpJournalEntryLogDetail view from CONSUMPTION
P_AR_SupplierPayable view inner CONSUMPTION
P_AR_SupplierPaymentDetail view_entity inner CONSUMPTION
P_AR_VATPrintPurchaseDetail view from CONSUMPTION

Fields (35)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 13
KEY AR_Branch AR_Branch 11
KEY AR_PrintCharacter AR_PrintCharacter 11
KEY CompanyCode CompanyCode 12
KEY FiscalYear FiscalYear 13
_OneTimeAccountBP _OneTimeAccountBP 3
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 11
AR_Branch4Digits AR_Branch4Digits 2
AR_CAE AR_CAE 2
AR_CAEInvoiceDueDate AR_CAEInvoiceDueDate 2
AR_OfficialDocumentNumber AR_OfficialDocumentNumber 11
Branch Branch 2
CompanyCodeCurrency CompanyCodeCurrency 3
DocumentDate DocumentDate 10
DocumentReferenceID DocumentReferenceID 12
ExchangeRate ExchangeRate 6
ExchangeRateDate ExchangeRateDate 5
FiscalPeriod FiscalPeriod 8
IsDocumentFromSD IsDocumentFromSD 2
IsReversal IsReversal 6
IsReversed IsReversed 6
LogicalSystem LogicalSystem 3
NmbrOfPages NmbrOfPages 2
OriginalReferenceDocument OriginalReferenceDocument 6
PostingDate PostingDate 12
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 3
ReferenceDocumentType ReferenceDocumentType 8
ReportingDate ReportingDate 13
ReversalReferenceDocument ReversalReferenceDocument 6
ReverseDocument ReverseDocument 6
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 3
TaxReportingDate TaxReportingDate 5
TransactionCurrency TransactionCurrency 7

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_AR_JOURNALENTRY (
    ACCOUNTINGDOCUMENT,
    AR_BRANCH,
    AR_PRINTCHARACTER,
    COMPANYCODE,
    FISCALYEAR,
    _ONETIMEACCOUNTBP,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    AR_BRANCH4DIGITS,
    AR_CAE,
    AR_CAEINVOICEDUEDATE,
    AR_OFFICIALDOCUMENTNUMBER,
    BRANCH,
    COMPANYCODECURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    FISCALPERIOD,
    ISDOCUMENTFROMSD,
    ISREVERSAL,
    ISREVERSED,
    LOGICALSYSTEM,
    NMBROFPAGES,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    REPORTINGDATE,
    REVERSALREFERENCEDOCUMENT,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, AR_BRANCH, AR_PRINTCHARACTER, COMPANYCODE, FISCALYEAR)
);

Learn More