PTRV_PRODUCT

Transparent Table Customizing Table
8 Fields 2 CDS Views

Product customizing for Spend traking relevance

PTRV_PRODUCT is an SAP database table in S/4HANA. Product customizing for Spend traking relevance. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TravelExpenseProductVH view from BASIC Travel Expense Product
I_TrvlExpnRcptProductData view_entity inner BASIC Travel Expense Receipt Product

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY product_id PTRV_PRD_ID ID
product_name PTRV_PRD_NAME Name
product_cat PTRV_PRD_CAT Categories
prd_drug_code PTRV_DRUG_CODE Nat. Drug Code
date_origin PTRV_DATE_ORI Validity Date
date_expiration PTRV_DATE_EXP Validity Date
prd_obsolete_flag PTRV_PRD_OBS Obsolete

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.

-- Product customizing for Spend traking relevance
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTRV_PRODUCT (
    MANDT,              -- Client [MANDT]
    PRODUCT_ID,         -- ID [PTRV_PRD_ID]
    PRODUCT_NAME,       -- Name [PTRV_PRD_NAME]
    PRODUCT_CAT,        -- Categories [PTRV_PRD_CAT]
    PRD_DRUG_CODE,      -- Nat. Drug Code [PTRV_DRUG_CODE]
    DATE_ORIGIN,        -- Validity Date [PTRV_DATE_ORI]
    DATE_EXPIRATION,    -- Validity Date [PTRV_DATE_EXP]
    PRD_OBSOLETE_FLAG,  -- Obsolete [PTRV_PRD_OBS]
    PRIMARY KEY (MANDT, PRODUCT_ID)
);

Learn More