P_RU_ACCTGDOCREFERENCEID

CDS View
20 Fields 13 CDS Views

S/P Ledgers: Primary Document Selection

P_RU_ACCTGDOCREFERENCEID is a CDS View in S/4HANA. S/P Ledgers: Primary Document Selection. It contains 20 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
P_RU_GtdFromImCD1 view inner CONSUMPTION FI RU determine GTD from ImCD & Country
P_RU_ImprtSupplier1 view from CONSUMPTION S/P Ledgers: Import Supplier1
P_RU_ImprtSupplier1 view inner CONSUMPTION S/P Ledgers: Import Supplier1
P_RU_ImprtSupplier1 view union_all CONSUMPTION S/P Ledgers: Import Supplier1
P_RU_ImprtSupplier3 view inner CONSUMPTION S/P Ledgers: Import Supplier3
P_RU_ImprtSupplier4 view from CONSUMPTION S/P Ledgers: Import Supplier4
P_RU_ImprtSupplier4 view union_all CONSUMPTION S/P Ledgers: Import Supplier4
P_RU_MaterialRcptDateMM3 view from CONSUMPTION FI RU get Material Receipt Date: MM-3
P_RU_MaterialRcptDateMM4 view from CONSUMPTION FI RU get Material Receipt Date: MM-4
P_RU_RealReversedDocument view inner CONSUMPTION Reversed Document
P_RU_SuplrInvcLogsItem view inner CONSUMPTION Supplier Invoice: Accounting Document & Logistics Item
P_RU_VATInTransitBillingDoc view from CONSUMPTION S/P Ledgers: Primary Document Selection
P_RU_VATReportingRNPT1 view inner CONSUMPTION FI RU RNPT determination for VAT Reporting - 1

Fields (20)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 7
KEY CompanyCode CompanyCode 8
KEY FiscalYear FiscalYear 7
AccountingDocumentType AccountingDocumentType 1
DocumentDate DocumentDate 3
DocumentReferenceID DocumentReferenceID 4
IsReversal IsReversal 4
IsReversed IsReversed 4
OriginalReferenceDocument OriginalReferenceDocument 1
OriginalReferenceDocumentCntxt OriginalReferenceDocumentCntxt 1
OriginalReferenceDocumentNum OriginalReferenceDocumentNum 1
PostingDate PostingDate 4
ReferenceDocumentType ReferenceDocumentType 2
ReferenceIDDocumentNumber ReferenceIDDocumentNumber 2
ReferenceIDDocumentYear ReferenceIDDocumentYear 2
ReferenceIDType ReferenceIDType 2
ReverseDocument ReversalDocumentBKPF 1
ReverseDocumentFiscalYear ReversalDocumentFiscalYearBKPF 1
SenderLogicalSystem SenderLogicalSystem 1
TaxReportingDate TaxReportingDate 1

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.

-- S/P Ledgers: Primary Document Selection
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_ACCTGDOCREFERENCEID (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    ACCOUNTINGDOCUMENTTYPE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    ISREVERSAL,
    ISREVERSED,
    ORIGINALREFERENCEDOCUMENT,
    ORIGINALREFERENCEDOCUMENTCNTXT,
    ORIGINALREFERENCEDOCUMENTNUM,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REFERENCEIDDOCUMENTNUMBER,
    REFERENCEIDDOCUMENTYEAR,
    REFERENCEIDTYPE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    SENDERLOGICALSYSTEM,
    TAXREPORTINGDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More