TRVS4_RECEIPT

Transparent Table Application Table
117 Fields 2 CDS Views

Travel Receipt

TRVS4_RECEIPT is an SAP database table in S/4HANA. Travel Receipt. It contains 117 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelExpenseReceiptData view_entity from EXTENSION Travel Expense Receipt - Extension
I_TravelExpenseReceiptData view_entity from BASIC Travel Expense Receipt Data

Fields (117)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pernr pernr_d Personnel No.
KEY reinr reinr Trip Number
KEY hdvrs ptrv_hdvrs Sequential no.
KEY receiptno nrbel Document Number
exp_type spkzl Travel Exp.Type
exp_cate belar Expen.Category
paper_receipt paper_receipt_core Paper Receipt
rec_amount ptrv_web_rec_amount Amount
rec_curr waers Currency
rec_rate ukurs_curr Exchange Rate
s_factor ffact_curr Ratio (from)
t_factor tfact_curr Ratio (to)
rec_date beldt Date
pay_amount gesbb Amount
pay_curr ptrv_paycurr Accounting in
tax_code mwskz Tax Code
taxjurcode txjcd Tax Jur.
shorttxt txbel Short Info
country lndgr Trip Ctry/Reg
region rgion Trip Region
from_date frdat From Date
to_date todat To Date
no_unit eranz Number
no_brft nubrf No.Breakf.
descript erdes Description
location erplc Location
bus_purpo buspu Bus. Purpose
bus_reason busre Bus. Partners
ccomp ccomp Company
c_doc c_doc Document No.
c_txt c_txt Description
ccard c_num Card Number
cekey cekey Transaction Key
guid_ccc guid_32 GUID 16
p_ctg provider_category Provider Category
p_prv provider_code Provider Code
p_doc p_doc Document No.
n_stf ch_no_staff Employees
n_ptn ch_no_partners Partners
n_gst ch_no_guests Guests
paid_com bezfa Paid by Company
payout payot ServiceProvider
above_limit ptrv_above_limit Limit exceeded
coming_from_plan protect ProtectInd
ref_no nobel Sub Document No
receipt_ok receipt_validated_core Receipt Checked
tt_comsp berei Trip Type E
check_result receipt_check_result Receipt Check Result
display_only receipt_display_only Rcpt Display Only
editor ptrv_web_editor Editor
exp_type_original spkzl Travel Exp.Type
exp_type1 spkzl Travel Exp.Type
exp_type2 spkzl Travel Exp.Type
exp_type3 spkzl Travel Exp.Type
exp_type4 spkzl Travel Exp.Type
exp_type5 spkzl Travel Exp.Type
exp_type6 spkzl Travel Exp.Type
priexp priexp Expense Type
no_lunch ptrv_anzlu No. Lunches
no_dinner ptrv_anzdi No. Dinners
full_amount_reimb ptrv_genehm_u_beleg Accomm. Recpt Apprvd
paper_missing paper_missing PprRcpt Missing
booked_price booked_price Booked Price
booked_curr booked_curr Booked Currency
diff_amount diff_amount Difference Amount
diff_curr diff_curr Diff.Amount Currency
reason ptrv_reason Reason f. Difference
diff_violation diff_violation Max. Diff. Exceeded
receipt_no ptrv_receipt_no Inv.No.of Orig.Rcpt
receipt_item ptrv_receipt_item No. of Invoice Item
vat_amount trv_wmwst Tax Amount
vat_service_code ptrv_vat_service_code Services
vat_service_desc ptrv_vat_service_desc Descr.of Service
vat_reg_no stceg VAT Reg. No.
vat_reg_no_nat stcd1 Tax Number 1
name ad_name1 Name
street ad_street Street
house_num ad_hsnm1 House Number
post_code ad_pstcd1 Postal Code
city ad_city1 City
vat_sub_srv_code ptrv_vat_sub_srv_code Subcode
vat_srv_desc_langu ptrv_vat_srv_desc_langu Language of Descr.
vat_changed_man ptrv_vat_changed_man VAT Changed
image_link ptra_image_link UUID Archive
from_mobile ptra_from_mobile Mobile App.
air_departure air_location IATA
air_arrival air_location IATA
airline airline Airline
air_cabin_class air_cabin_class Cabin Class
air_ticket_number ptrv_ticket_number Ticket Number
car_odometer_reading car_odometer_reading Mileage
se_name ad_name1 Name
se_street ad_street Street
se_city ad_city1 City
se_state_province se_state_province District (US:County)
se_country se_country Country/Region
se_postal_code ad_pstcd1 Postal Code
se_customer_service_phone se_customer_service_phone Ser.Tel.No.
belsa ptrvps_belsa Rcpt w/ Cllct Item
mazub ptrvps_mazub Meals in U Recpt
recag ptrvps_recag Invoice to ER
sadv ptrvps_sadv C.Item Business Only
origin_rec_amount ptrv_web_rec_amount Amount
total_itemized_rec_amount ptrv_web_rec_amount Amount
private_expense_amount gesbb Amount
origin mte_receipt_ori Origin
origin_name mte_origin_name Origin
isitemized xfeld Checkbox
nbattachments int4 INT4
category mte_expense_type_category Category
category_name ltext Long Text
vat_service_name ptrv_vat_service_text Services
vat_sub_srv_name ptrv_vat_service_text Services
airline_name provider_name Name
perc_abs betpr Amt/Percent
key_stop keyzi Dest.Assignment

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.

-- Travel Receipt
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_RECEIPT (
    MANDT,                      -- Client [mandt]
    PERNR,                      -- Personnel No. [pernr_d]
    REINR,                      -- Trip Number [reinr]
    HDVRS,                      -- Sequential no. [ptrv_hdvrs]
    RECEIPTNO,                  -- Document Number [nrbel]
    EXP_TYPE,                   -- Travel Exp.Type [spkzl]
    EXP_CATE,                   -- Expen.Category [belar]
    PAPER_RECEIPT,              -- Paper Receipt [paper_receipt_core]
    REC_AMOUNT,                 -- Amount [ptrv_web_rec_amount]
    REC_CURR,                   -- Currency [waers]
    REC_RATE,                   -- Exchange Rate [ukurs_curr]
    S_FACTOR,                   -- Ratio (from) [ffact_curr]
    T_FACTOR,                   -- Ratio (to) [tfact_curr]
    REC_DATE,                   -- Date [beldt]
    PAY_AMOUNT,                 -- Amount [gesbb]
    PAY_CURR,                   -- Accounting in [ptrv_paycurr]
    TAX_CODE,                   -- Tax Code [mwskz]
    TAXJURCODE,                 -- Tax Jur. [txjcd]
    SHORTTXT,                   -- Short Info [txbel]
    COUNTRY,                    -- Trip Ctry/Reg [lndgr]
    REGION,                     -- Trip Region [rgion]
    FROM_DATE,                  -- From Date [frdat]
    TO_DATE,                    -- To Date [todat]
    NO_UNIT,                    -- Number [eranz]
    NO_BRFT,                    -- No.Breakf. [nubrf]
    DESCRIPT,                   -- Description [erdes]
    LOCATION,                   -- Location [erplc]
    BUS_PURPO,                  -- Bus. Purpose [buspu]
    BUS_REASON,                 -- Bus. Partners [busre]
    CCOMP,                      -- Company [ccomp]
    C_DOC,                      -- Document No. [c_doc]
    C_TXT,                      -- Description [c_txt]
    CCARD,                      -- Card Number [c_num]
    CEKEY,                      -- Transaction Key [cekey]
    GUID_CCC,                   -- GUID 16 [guid_32]
    P_CTG,                      -- Provider Category [provider_category]
    P_PRV,                      -- Provider Code [provider_code]
    P_DOC,                      -- Document No. [p_doc]
    N_STF,                      -- Employees [ch_no_staff]
    N_PTN,                      -- Partners [ch_no_partners]
    N_GST,                      -- Guests [ch_no_guests]
    PAID_COM,                   -- Paid by Company [bezfa]
    PAYOUT,                     -- ServiceProvider [payot]
    ABOVE_LIMIT,                -- Limit exceeded [ptrv_above_limit]
    COMING_FROM_PLAN,           -- ProtectInd [protect]
    REF_NO,                     -- Sub Document No [nobel]
    RECEIPT_OK,                 -- Receipt Checked [receipt_validated_core]
    TT_COMSP,                   -- Trip Type E [berei]
    CHECK_RESULT,               -- Receipt Check Result [receipt_check_result]
    DISPLAY_ONLY,               -- Rcpt Display Only [receipt_display_only]
    EDITOR,                     -- Editor [ptrv_web_editor]
    EXP_TYPE_ORIGINAL,          -- Travel Exp.Type [spkzl]
    EXP_TYPE1,                  -- Travel Exp.Type [spkzl]
    EXP_TYPE2,                  -- Travel Exp.Type [spkzl]
    EXP_TYPE3,                  -- Travel Exp.Type [spkzl]
    EXP_TYPE4,                  -- Travel Exp.Type [spkzl]
    EXP_TYPE5,                  -- Travel Exp.Type [spkzl]
    EXP_TYPE6,                  -- Travel Exp.Type [spkzl]
    PRIEXP,                     -- Expense Type [priexp]
    NO_LUNCH,                   -- No. Lunches [ptrv_anzlu]
    NO_DINNER,                  -- No. Dinners [ptrv_anzdi]
    FULL_AMOUNT_REIMB,          -- Accomm. Recpt Apprvd [ptrv_genehm_u_beleg]
    PAPER_MISSING,              -- PprRcpt Missing [paper_missing]
    BOOKED_PRICE,               -- Booked Price [booked_price]
    BOOKED_CURR,                -- Booked Currency [booked_curr]
    DIFF_AMOUNT,                -- Difference Amount [diff_amount]
    DIFF_CURR,                  -- Diff.Amount Currency [diff_curr]
    REASON,                     -- Reason f. Difference [ptrv_reason]
    DIFF_VIOLATION,             -- Max. Diff. Exceeded [diff_violation]
    RECEIPT_NO,                 -- Inv.No.of Orig.Rcpt [ptrv_receipt_no]
    RECEIPT_ITEM,               -- No. of Invoice Item [ptrv_receipt_item]
    VAT_AMOUNT,                 -- Tax Amount [trv_wmwst]
    VAT_SERVICE_CODE,           -- Services [ptrv_vat_service_code]
    VAT_SERVICE_DESC,           -- Descr.of Service [ptrv_vat_service_desc]
    VAT_REG_NO,                 -- VAT Reg. No. [stceg]
    VAT_REG_NO_NAT,             -- Tax Number 1 [stcd1]
    NAME,                       -- Name [ad_name1]
    STREET,                     -- Street [ad_street]
    HOUSE_NUM,                  -- House Number [ad_hsnm1]
    POST_CODE,                  -- Postal Code [ad_pstcd1]
    CITY,                       -- City [ad_city1]
    VAT_SUB_SRV_CODE,           -- Subcode [ptrv_vat_sub_srv_code]
    VAT_SRV_DESC_LANGU,         -- Language of Descr. [ptrv_vat_srv_desc_langu]
    VAT_CHANGED_MAN,            -- VAT Changed [ptrv_vat_changed_man]
    IMAGE_LINK,                 -- UUID Archive [ptra_image_link]
    FROM_MOBILE,                -- Mobile App. [ptra_from_mobile]
    AIR_DEPARTURE,              -- IATA [air_location]
    AIR_ARRIVAL,                -- IATA [air_location]
    AIRLINE,                    -- Airline [airline]
    AIR_CABIN_CLASS,            -- Cabin Class [air_cabin_class]
    AIR_TICKET_NUMBER,          -- Ticket Number [ptrv_ticket_number]
    CAR_ODOMETER_READING,       -- Mileage [car_odometer_reading]
    SE_NAME,                    -- Name [ad_name1]
    SE_STREET,                  -- Street [ad_street]
    SE_CITY,                    -- City [ad_city1]
    SE_STATE_PROVINCE,          -- District (US:County) [se_state_province]
    SE_COUNTRY,                 -- Country/Region [se_country]
    SE_POSTAL_CODE,             -- Postal Code [ad_pstcd1]
    SE_CUSTOMER_SERVICE_PHONE,  -- Ser.Tel.No. [se_customer_service_phone]
    BELSA,                      -- Rcpt w/ Cllct Item [ptrvps_belsa]
    MAZUB,                      -- Meals in U Recpt [ptrvps_mazub]
    RECAG,                      -- Invoice to ER [ptrvps_recag]
    SADV,                       -- C.Item Business Only [ptrvps_sadv]
    ORIGIN_REC_AMOUNT,          -- Amount [ptrv_web_rec_amount]
    TOTAL_ITEMIZED_REC_AMOUNT,  -- Amount [ptrv_web_rec_amount]
    PRIVATE_EXPENSE_AMOUNT,     -- Amount [gesbb]
    ORIGIN,                     -- Origin [mte_receipt_ori]
    ORIGIN_NAME,                -- Origin [mte_origin_name]
    ISITEMIZED,                 -- Checkbox [xfeld]
    NBATTACHMENTS,              -- INT4 [int4]
    CATEGORY,                   -- Category [mte_expense_type_category]
    CATEGORY_NAME,              -- Long Text [ltext]
    VAT_SERVICE_NAME,           -- Services [ptrv_vat_service_text]
    VAT_SUB_SRV_NAME,           -- Services [ptrv_vat_service_text]
    AIRLINE_NAME,               -- Name [provider_name]
    PERC_ABS,                   -- Amt/Percent [betpr]
    KEY_STOP,                   -- Dest.Assignment [keyzi]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, RECEIPTNO)
);

Learn More