P_RU_CFINVATDOCEXTRAS

CDS View
10 Fields 10 CDS Views

Central Finance Extras for Documents

P_RU_CFINVATDOCEXTRAS is a CDS View in S/4HANA. Central Finance Extras for Documents. It contains 10 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_RU_CFinVatCorRevExtras view left_outer CONSUMPTION Central Finance Extras for VAT Invoice Correction and Revis
P_RU_InvoiceExternalNumberDate view from CONSUMPTION Invoice Total Amount
P_RU_InvoicePayment view from CONSUMPTION Payment Order Number and Date for Invoice
P_RU_InvoicePayment view inner CONSUMPTION Payment Order Number and Date for Invoice
P_RU_InvoicePayment view union_all CONSUMPTION Payment Order Number and Date for Invoice
P_RU_PaymentDocument2 view inner CONSUMPTION Payment Document
P_RU_VATInvcJrnlLinkExtraData view from CONSUMPTION Invoice Linking: Linking through extra texts
P_RU_VATInvoiceClearingChain view inner CONSUMPTION VAT Invoice Clearing Chain
P_RU_VATInvoicePaymentExtras view from CONSUMPTION VAT Invoice Clearing - Payments Extra Texts
P_RU_VATInvoicePaymentExtras view union_all CONSUMPTION VAT Invoice Clearing - Payments Extra Texts

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 3
ExternalInvoice ExternalInvoice 2
ExternalPayment ExternalPayment 3
InvoiceDate InvoiceDate 1
PaymentDate PaymentDate 3
RU_IncomingInvoiceDate RU_IncomingInvoiceDate 2
RU_IncomingInvoiceNumber IncomingExternalInvoice,RU_IncomingInvoiceNumber 2
Supplier BusinessPartner 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.

-- Central Finance Extras for Documents
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_CFINVATDOCEXTRAS (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    EXTERNALINVOICE,
    EXTERNALPAYMENT,
    INVOICEDATE,
    PAYMENTDATE,
    RU_INCOMINGINVOICEDATE,
    RU_INCOMINGINVOICENUMBER,
    SUPPLIER,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More