P_AR_JOURNALENTRY

CDS View
33 Fields 15 CDS Views

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

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_AR_StRpJournalEntryTaxItem view from CONSUMPTION Journal Entry Tax Item for Argentina
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 (33)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 12
KEY CompanyCode CompanyCode 11
KEY FiscalYear FiscalYear 12
_OneTimeAccountBP _OneTimeAccountBP 3
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 11
AR_Branch AR_Branch 10
AR_Branch4Digits AR_Branch4Digits 2
AR_OfficialDocumentNumber AR_OfficialDocumentNumber 10
AR_PrintCharacter AR_PrintCharacter 10
Branch Branch 2
CompanyCodeCurrency CompanyCodeCurrency 3
DocumentDate DocumentDate 10
DocumentReferenceID DocumentReferenceID 11
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 12
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,
    COMPANYCODE,
    FISCALYEAR,
    _ONETIMEACCOUNTBP,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    AR_BRANCH,
    AR_BRANCH4DIGITS,
    AR_OFFICIALDOCUMENTNUMBER,
    AR_PRINTCHARACTER,
    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, COMPANYCODE, FISCALYEAR)
);

Learn More