PTRV_RECDETAIL

Transparent Table Application Table
9 Fields 2 CDS Views

Teilnehmer Bewirtungsbelege

PTRV_RECDETAIL is an SAP database table in S/4HANA. Teilnehmer Bewirtungsbelege. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlExpnRcptParticipantData view_entity from EXTENSION Travel Expense Receipt Participant - Extension
I_TrvlExpnRcptParticipantData view_entity from BASIC Travel Expense Receipt Participant

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY belnr nrbel Document Number
KEY lfdnr ptrv_lfdnr Sequence Number
relation ptrv_relation Co. Relation.
name pad_nachn Last Name
first_name pad_vorna First Name
jobtitel ptrv_jobtitel Job Title
company ptrv_company Company
pernr_int pernr_d Personnel No.
bu_partner bu_partner Busn. Partner

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.

-- Teilnehmer Bewirtungsbelege
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTRV_RECDETAIL (
    BELNR,       -- Document Number [nrbel]
    LFDNR,       -- Sequence Number [ptrv_lfdnr]
    RELATION,    -- Co. Relation. [ptrv_relation]
    NAME,        -- Last Name [pad_nachn]
    FIRST_NAME,  -- First Name [pad_vorna]
    JOBTITEL,    -- Job Title [ptrv_jobtitel]
    COMPANY,     -- Company [ptrv_company]
    PERNR_INT,   -- Personnel No. [pernr_d]
    BU_PARTNER,  -- Busn. Partner [bu_partner]
    PRIMARY KEY (BELNR, LFDNR)
);

Learn More