I_RU_TRACEABILITYMOVEMENTDOCS

CDS View
16 Fields 3 CDS Views

Traceability RN Movement Documents

I_RU_TRACEABILITYMOVEMENTDOCS is a CDS View in S/4HANA. Traceability RN Movement Documents. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_RU_TraceabilityDocsInfo view inner CONSUMPTION Data from traceability databases
P_RU_VATReportingRNPT1 view from CONSUMPTION
P_RU_VATReportingRNPT1 view union_all CONSUMPTION

Fields (16)

KeyField CDS FieldsUsed in Views
KEY RU_RNPTRegistrationItem RU_RNPTRegistrationItem 2
KEY RU_RNPTRegistrationNumber RU_RNPTRegistrationNumber 1
KEY RU_RNPTRegistrationYear RU_RNPTRegistrationYear 2
AccountingDocument AccountingDocument,FinanceInvoice 2
Currency Currency 2
FiscalYear FinanceInvoiceFiscalYear,FiscalYear 2
Quantity Quantity 2
RU_RNPTOperationDate RU_RNPTOperationDate 1
RU_RNPTPrimaryDocumentItem RU_RNPTPrimaryDocumentItem 2
RU_RNPTPrimaryDocumentNumber RU_RNPTPrimaryDocumentNumber 2
RU_RNPTPrimaryDocumentType RU_RNPTPrimaryDocumentType 2
RU_RNPTPrimaryDocumentYear RU_RNPTPrimaryDocumentYear 2
SupplierInvoice SupplierInvoice 2
SupplierInvoiceFiscalYear SupplierInvoiceFiscalYear 2
SupplierInvoiceItem SupplierInvoiceItem 2
TotalAmountInLocalCurrency TotalAmountInLocalCurrency 2

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.

-- Traceability RN Movement Documents
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RU_TRACEABILITYMOVEMENTDOCS (
    RU_RNPTREGISTRATIONITEM,
    RU_RNPTREGISTRATIONNUMBER,
    RU_RNPTREGISTRATIONYEAR,
    ACCOUNTINGDOCUMENT,
    CURRENCY,
    FISCALYEAR,
    QUANTITY,
    RU_RNPTOPERATIONDATE,
    RU_RNPTPRIMARYDOCUMENTITEM,
    RU_RNPTPRIMARYDOCUMENTNUMBER,
    RU_RNPTPRIMARYDOCUMENTTYPE,
    RU_RNPTPRIMARYDOCUMENTYEAR,
    SUPPLIERINVOICE,
    SUPPLIERINVOICEFISCALYEAR,
    SUPPLIERINVOICEITEM,
    TOTALAMOUNTINLOCALCURRENCY,
    PRIMARY KEY (RU_RNPTREGISTRATIONITEM, RU_RNPTREGISTRATIONNUMBER, RU_RNPTREGISTRATIONYEAR)
);

Learn More