PTRV_RECPRODUCT

Transparent Table Application Table
8 Fields 2 CDS Views

Products for Spend tracking relevance

PTRV_RECPRODUCT is an SAP database table in S/4HANA. Products for Spend tracking relevance. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlExpnRcptProductData view_entity from EXTENSION Travel Expense Receipt Product - Extension
I_TrvlExpnRcptProductData view_entity from BASIC Travel Expense Receipt Product

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERNR_D Personnel No.
KEY reinr REINR Trip Number
KEY perio PTRV_PEROD Period Number
KEY pdvrs PTRV_PDVRS Sequence Number
KEY belnr NRBEL Document Number
KEY lfdnr PTRV_LFDNR Sequence Number
product_id PTRV_PRD_ID ID

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.

-- Products for Spend tracking relevance
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTRV_RECPRODUCT (
    MANDT,       -- Client [MANDT]
    PERNR,       -- Personnel No. [PERNR_D]
    REINR,       -- Trip Number [REINR]
    PERIO,       -- Period Number [PTRV_PEROD]
    PDVRS,       -- Sequence Number [PTRV_PDVRS]
    BELNR,       -- Document Number [NRBEL]
    LFDNR,       -- Sequence Number [PTRV_LFDNR]
    PRODUCT_ID,  -- ID [PTRV_PRD_ID]
    PRIMARY KEY (MANDT, PERNR, REINR, PERIO, PDVRS, BELNR, LFDNR)
);

Learn More