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