TRVS4_RECEIPT_D

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.

-- Draft table for entity I_TRAVELEXPENSERECEIPT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_RECEIPT_D (
    MANDT,                           -- Client [mandt]
    PERSONNELNUMBER,                 -- Personnel No. [pernr_d]
    TRAVELTRIPNUMBER,                -- Trip Number [reinr]
    TRAVELREQUUID,                   -- UUID [sysuuid_x16]
    SEQREQUUID,                      -- UUID [sysuuid_x16]
    TRAVELEXPENSEDOCUMENT,           -- Document Number [nrbel]
    TRAVELEXPNSEQUENTIALNUMBER,      -- Sequential no. [ptrv_hdvrs]
    TRAVELEXPENSETYPE,               -- Travel Exp.Type [spkzl]
    TRAVELEXPENSECATEGORY,           -- Expense Category [vdm_exp_cate]
    TRAVELEXPENSEHASPAPERRECEIPT,    -- Paper Receipt [paper_receipt_core]
    INDIVIDUALRECEIPTAMOUNT,         -- Receipt Amount [vdm_rec_amount]
    RECEIPTAMOUNTCURRENCYCODE,       -- Currency [waers]
    TRAVELEXCHANGERATE,              -- Exchange Rate [vdm_ukurs_curr]
    CURRENCYUNITFROMRATIO,           -- Factor (From) [vdm_s_factor]
    CURRENCYUNITTORATIO,             -- Factor (to) [t_factor]
    INDIVIDUALRECEIPTDATE,           -- Date [vdm_rec_date]
    PAYMENTAMOUNT,                   -- Amount in Settlement Currency [vdm_pay_amount]
    PAYMENTCURRENCY,                 -- Accounting in [ptrv_paycurr]
    TAXCODE,                         -- Tax Code [mwskz]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    RECEIPTSHORTTEXT,                -- Short Receipt Info [vdm_shortrecinformation]
    COUNTRY,                         -- Country / Region [vdm_ctry_reg]
    TRIPREGION,                      -- Trip Region [rgion]
    SERVICEFROMDATE,                 -- From Date [frdat]
    SERVICETODATE,                   -- To Date [todat]
    NUMBEROFDAYS,                    -- Number of Days [vdm_no_unit]
    TOTALNUMBEROFBREAKFASTS,         -- No.Breakf. [nubrf]
    TRVLEXPNRECEIPTDESCRIPTION,      -- Receipt Description [vdm_trvlexpnrecdesc]
    WORKLOCATIONNAME,                -- Work Location [vdm_location]
    BUSINESSPURPOSEDESCRIPTION,      -- Bus. Purpose [buspu]
    BUSINESSPARTNERTEXT,             -- Business Partner [vdm_bus_reason]
    CREDITCARDCOMPANYCODE,           -- Company [ccomp]
    CREDITCARDRECEIPTDOCNMBR,        -- Credit Card Receipt Document Number [vdm_creditcardrecdocnmbr]
    CREDITCARDTRANSACTIONDESC,       -- Credit Card Transaction Description [vdm_creditcardtransdesc]
    CREDITCARDNUMBER,                -- Card Number [c_num]
    CREDITCARDTRANSACTIONUUID,       -- GUID 16 [guid_32]
    PAYMENTTRANSACTIONKEY,           -- Transaction Key [cekey]
    PROVIDERCATEGORYCODE,            -- Provider Category [provider_category]
    TRVLEXPNPROVIDERCODE,            -- Provider Code [provider_code]
    PAPERRECEIPTDOCUMENTNUMBER,      -- Paper Document Number [vdm_paperrecdocnmbr]
    NUMBEROFEMPLOYEES,               -- Employees [ch_no_staff]
    NMBROFEMPLOYEESOFBP,             -- Partners [ch_no_partners]
    NUMBEROFADDITIONALGUESTS,        -- Number of Guests [vdm_numberofguests]
    PAYMENTISMADEBYCOMPANY,          -- Paid by Company [bezfa]
    SERVICEPROVIDERCODE,             -- ServiceProvider [payot]
    LIMITFOREXCEEDINGTRVLEXPNTYPE,   -- Limit exceeded [ptrv_above_limit]
    PROTECTIONINDICATORTYPE,         -- ProtectInd [protect]
    TRAVELEXPENSEREFERENCEDOCUMENT,  -- Sub Document No [nobel]
    RECEIPTISCHECKED,                -- Receipt Checked [receipt_validated_core]
    TRIPTYPEENTERPRISE,              -- Trip Type Ent Specific [vdm_triptypeenterprise]
    RECEIPTCHECKRESULT,              -- Receipt Check Result [receipt_check_result]
    INDIVIDUALRECEIPTISDSPONLY,      -- Receipt Display Only [vdm_indivrecisdsponly]
    RECEIPTEDITORTEXT,               -- Editor [ptrv_web_editor]
    ORIGINALTRAVELEXPENSETYPE,       -- Travel Exp.Type [spkzl]
    PRIVATESHARETRAVELEXPENSETYPE,   -- Expense Type Private [vdm_exptypeforprivateshare]
    TOTALNUMBEROFLUNCHES,            -- Number of Lunches [vdm_nmbroflunches]
    TOTALNUMBEROFDINNERS,            -- Number of Dinners [vdm_nmbrofdinners]
    ACMDTNREIMBMTRECEIPTISAPPROVED,  -- Acmdtns Rcpt Aprvd [vdm_acmdtnreimbmtrcptisaprvd]
    MISSINGPAPERRECEIPTTYPE,         -- Paper Receipt Missing [vdm_paperrecmissing]
    TRIPBOOKEDPRICE,                 -- Booked Price [booked_price]
    TRIPBOOKEDPRICECURRENCY,         -- Booked Currency [booked_curr]
    DIFFERENCEINTRAVELEXPENSEAMT,    -- Variance Amount [vdm_diff_amount]
    DIFFERENCEAMOUNTCURRENCY,        -- Difference Amt. Crcy [vdm_diffamountcrcy]
    DIFFERENCEAMOUNTREASONTEXT,      -- Reason for Difference [vdm_reasonfordifference]
    MAXDIFFEXCEEDINGTRVLEXPNTYPE,    -- Max Difference Exceeded [vdm_maxdiffexceeded]
    ORIGINALRECEIPTINVOICENUMBER,    -- Original Rcpt Invc No. [vdm_originalrecinvcnmbr]
    NUMBEROFINVOICEITEMS,            -- No. of Invoice Items [vdm_nmbrofinvoiceitems]
    TAXAMOUNT,                       -- Tax Amount [trv_wmwst]
    SERVICETAXTYPECODE,              -- Services [ptrv_vat_service_code]
    SERVICETAXDESCRIPTION,           -- Goods and Services Desc [vdm_descofgoodsandservices]
    SERVICETAXREGISTRATIONNUMBER,    -- VAT Registration No. [vdm_vatregnnumber]
    NAME,                            -- Name [ad_name1]
    STREETNAME,                      -- Deptr Street [vdm_deptrstreet]
    HOUSENUMBER,                     -- House Number [ad_hsnm1]
    POSTALCODE,                      -- Deptr City Postl Code [vdm_deptrpostalcode]
    CITYNAME,                        -- City [ad_city1]
    SERVICETAXSUBCODE,               -- Subcode [ptrv_vat_sub_srv_code]
    SERVICETAXDESCRIPTIONLANGUAGE,   -- Goods and Services Lang [vdm_langofdescofgoodsandsrvcs]
    TAXAMOUNTCHANGE,                 -- VAT Changed [ptrv_vat_changed_man]
    FLIGHTDEPARTURELOCATION,         -- Departure IATA [vdm_air_departure]
    FLIGHTARRIVALLOCATION,           -- Arrival IATA [vdm_air_arrival]
    AIRLINE,                         -- Airline [airline]
    AIRCABINCLASS,                   -- Cabin Class [air_cabin_class]
    AIRTICKETNUMBER,                 -- Ticket Number [ptrv_ticket_number]
    VEHICLEMILEAGEVALUE,             -- Mileage [car_odometer_reading]
    SUPPLIERNAME,                    -- Supplier Name [vdm_suppliername]
    SUPPLIERSTREETNAME,              -- Arrival Street [vdm_arrvlstreet]
    SUPPLIERCITYNAME,                -- Supplier City [vdm_suppliercityname]
    SUPPLIERSTATENAME,               -- District (US:County) [se_state_province]
    SUPPLIERCOUNTRYNAME,             -- Country / Region [vdm_supplier_ctry_name]
    SUPPLIERPOSTALCODE,              -- Arrival Postal Code [vdm_arrvlpostalcode]
    CUSTOMERSERVICETELEPHONENUMBER,  -- Cust Service Phone No. [vdm_customersrvctelnmbr]
    ACMDTNRCPTWITHCOLLECTIVEITEMS,   -- Rcpt with Collective Itms [vdm_reccontainscollvitem]
    MEALSINCLUSIONINACMDTNRECEIPT,   -- Meals In Accommodation Receipt [vdm_mazub]
    INVOICETOEMPLOYER,               -- Invc Issued to Employer [vdm_invoicetoemployer]
    BUSINESSRELATEDCOLLECTIVEITEM,   -- Collective Item - Business Only [vdm_sadv]
    TRAVELEXPENSETYPENAME,           -- Expense Type [vdm_exp_type_name]
    TRAVELEXPENSECATEGORYNAME,       -- Expense Category Name [vdm_exp_cate_name]
    RECEIPTAMOUNTCURRENCYCODENAME,   -- Long Text [ltext]
    PAYMENTCURRENCYCODENAME,         -- Long Text [ltext]
    TAXCODENAME,                     -- Tax Code Name [vdm_tax_code_name]
    TAXJURISDICTIONCODENAME,         -- Tax Jurisdiction Name [vdm_taxjurcode_name]
    COUNTRYREGIONNAME,               -- Country / Region [vdm_country_region_name]
    CREDITCARDCOMPANYNAME,           -- Credit Card Company [text_ccard]
    PROVIDERCATEGORYNAME,            -- Provider Category Name [vdm_p_ctg_name]
    TRAVELEXPENSEPROVIDERNAME,       -- Provider Name [vdm_p_prv_name]
    SERVICEPROVIDERNAME,             -- Service Provider Name [vdm_service_provider_name]
    TRIPTYPEENTERPRISENAME,          -- Trip Type Enterprise Name [vdm_tt_comsp_name]
    TRVLEXPNRCPTIMGLNKTEXT,          -- UUID Archive [ptra_image_link]
    ORIGINALRECEIPTAMOUNT,           -- Original Receipt Amount [vdm_origin_rec_amount]
    TOTALITEMIZEDRECEIPTAMOUNT,      -- Total Itemized Receipts [vdm_total_itemized_rec_amount]
    PRIVATEEXPENSEAMOUNT,            -- Amount [gesbb]
    RECEIPTORIGINTYPE,               -- Receipt Origin [vdm_receiptorigin]
    RECEIPTORIGINNAME,               -- Origin [mte_origin_name]
    RECEIPTISITEMIZED,               -- Itemized [vdm_isitemized]
    TRAVELEXPENSETYPECATEGORYCODE,   -- Expense Category Code [vdm_categorycode]
    TRAVELEXPENSETYPECATEGORYNAME,   -- Category [vdm_category_name]
    SERVICETAXTYPENAME,              -- Service Tax Type Name [vdm_servicetax_type_name]
    SUBSERVICETAXNAME,               -- Sub Service Tax Name [vdm_subservice_taxname]
    AIRLINENAME,                     -- Airline Name [vdm_airline_name]
    TRVLCOSTASSGMTAMTORPCTG,         -- Amt/Percent [betpr]
    TRVLEXPNRECISMODIFIED,           -- abap.char
    RCPTSLOCLLASTCHGDDTETME,         -- Changed On [abp_lastchange_tstmpl]
    DESTINATIONASSIGNMENT,           -- Dest.Assignment [keyzi]
    TRAVELCOUNTRYREGION,             -- Country / Region [vdm_reg_ctry]
    RCPTTRAVELEXPENSETYPEISVISIBLE,  -- Checkbox [xfeld]
    RCPTTRVLEXPNPAPERRCPTISVISIBLE,  -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTAMTISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTCRCYISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTRATEISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTDATEISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYAMTISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYCRCYISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLEXPNSHORTTXTISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNBIZPRPSISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYTCOISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLCRDTCARDNMBRISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLCRDTCARDDESCISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTISCHECKVISIBLE,  -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTNMBRISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTITEMISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNVATAMTISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLVATSRVCCODEISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLVATSRVCDESCISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLVATREGNNMBRISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLVATREGNTAXISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLEXPNNAMEISVISIBLE,       -- Checkbox [xfeld]
    RCPTTRVLEXPNSTREETISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLEXPNHOUSENMBRISVISIBLE,  -- Checkbox [xfeld]
    RCPTTRVLEXPNPOSTLCODEISVISIBLE,  -- Checkbox [xfeld]
    RCPTTRVLEXPNCITYISVISIBLE,       -- Checkbox [xfeld]
    RCPTTRVLEXPNMBLAPPLISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLAIRPORTDEPTRISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLAIRPORTARRVLISVISIBLE,   -- Checkbox [xfeld]
    RCPTTRVLEXPNAIRLINEISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLEXPNCABINCLISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLTICKETNMBRISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLCARODOMETERISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRNAMEISVISIBLE,  -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRSTISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRCITYISVISIBLE,  -- Checkbox [xfeld]
    RCPTTRVLSUPLRSTATEISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLSUPLRCNTRYISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLSUPLRPOSTLISVISIBLE,     -- Checkbox [xfeld]
    RCPTTRVLSUPLRSRVCPHISVISIBLE,    -- Checkbox [xfeld]
    RCPTTRAVELEXPENSETYPEISINPUT,    -- Checkbox [xfeld]
    RCPTTRVLEXPNPAPERRCPTISINPUT,    -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTAMTISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTCRCYISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTRATEISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTDATEISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYAMTISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYCRCYISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLEXPNSHORTTXTISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNBIZPRPSISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYTCOISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLCRDTCARDNMBRISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLCRDTCARDDESCISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTISCHECKINPUT,    -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTNMBRISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTITEMISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNVATAMTISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLVATSRVCCODEISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLVATSRVCDESCISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLVATREGNNMBRISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLVATREGNTAXISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLEXPNNAMEISINPUT,         -- Checkbox [xfeld]
    RCPTTRVLEXPNSTREETISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLEXPNHOUSENMBRISINPUT,    -- Checkbox [xfeld]
    RCPTTRVLEXPNPOSTLCODEISINPUT,    -- Checkbox [xfeld]
    RCPTTRVLEXPNCITYISINPUT,         -- Checkbox [xfeld]
    RCPTTRVLEXPNMBLAPPLISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLAIRPORTDEPTRISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLAIRPORTARRVLISINPUT,     -- Checkbox [xfeld]
    RCPTTRVLEXPNAIRLINEISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLEXPNCABINCLISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLTICKETNMBRISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLCARODOMETERISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRNAMEISINPUT,    -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRSTISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRCITYISINPUT,    -- Checkbox [xfeld]
    RCPTTRVLSUPLRSTATEISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLSUPLRCNTRYISINPUT,       -- Checkbox [xfeld]
    RCPTTRVLSUPLRPOSTLCODEISINPUT,   -- Checkbox [xfeld]
    RCPTTRVLSUPLRSRVCPHISINPUT,      -- Checkbox [xfeld]
    RCPTTRVLEXPNTYPEISREQUIRED,      -- Checkbox [xfeld]
    RCPTTRVLEXPNPAPERRCPTISRQD,      -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTAMTISRQD,        -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTCRCYISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTRATEISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTDATEISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYAMTISRQD,         -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYCRCYISRQD,        -- Checkbox [xfeld]
    RCPTTRVLEXPNSHORTTXTISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNBIZPRPSISRQD,        -- Checkbox [xfeld]
    RCPTTRVLEXPNPAYTCOISRQD,         -- Checkbox [xfeld]
    RCPTTRVLCRDTCARDNMBRISRQD,       -- Checkbox [xfeld]
    RCPTTRVLCRDTCARDDESCISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTISCHECKRQD,      -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTNMBRISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNRCPTITEMISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNVATAMTISRQD,         -- Checkbox [xfeld]
    RCPTTRVLVATSRVCCODEISRQD,        -- Checkbox [xfeld]
    RCPTTRVLVATSRVCDESCISRQD,        -- Checkbox [xfeld]
    RCPTTRVLVATREGNNMBRISRQD,        -- Checkbox [xfeld]
    RCPTTRVLVATREGNTAXISRQD,         -- Checkbox [xfeld]
    RCPTTRVLEXPNNAMEISRQD,           -- Checkbox [xfeld]
    RCPTTRVLEXPNSTREETISRQD,         -- Checkbox [xfeld]
    RCPTTRVLEXPNHOUSENMBRISRQD,      -- Checkbox [xfeld]
    RCPTTRVLEXPNPOSTLCODEISRQD,      -- Checkbox [xfeld]
    RCPTTRVLEXPNCITYISRQD,           -- Checkbox [xfeld]
    RCPTTRVLEXPNMBLAPPLISRQD,        -- Checkbox [xfeld]
    RCPTTRVLAIRPORTDEPTRISRQD,       -- Checkbox [xfeld]
    RCPTTRVLAIRPORTARRVLISRQD,       -- Checkbox [xfeld]
    RCPTTRVLEXPNAIRLINEISRQD,        -- Checkbox [xfeld]
    RCPTTRVLEXPNCABINCLISRQD,        -- Checkbox [xfeld]
    RCPTTRVLTICKETNMBRISRQD,         -- Checkbox [xfeld]
    RCPTTRVLCARODOMETERISRQD,        -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRNAMEISRQD,      -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRSTISRQD,        -- Checkbox [xfeld]
    RCPTTRVLEXPNSUPLRCITYISRQD,      -- Checkbox [xfeld]
    RCPTTRVLSUPLRSTATEISRQD,         -- Checkbox [xfeld]
    RCPTTRVLSUPLRCNTRYISRQD,         -- Checkbox [xfeld]
    RCPTTRVLSUPLRPOSTLCODEISRQD,     -- Checkbox [xfeld]
    RCPTTRVLSUPLRSRVCPHISRQD,        -- Checkbox [xfeld]
    ACMDTNRCPTWTHCOLLVITMS_H,        -- abap.raw
    ACMDTNREIMBMTRCPTISAPRVD_H,      -- abap.raw
    AIRCABINCLASS_H,                 -- abap.raw
    AIRLINE_H,                       -- abap.raw
    AIRTICKETNUMBER_H,               -- abap.raw
    BUSINESSPARTNERTEXT_H,           -- abap.raw
    BUSINESSPURPOSEDESCRIPTION_H,    -- abap.raw
    BUSINESSRELTDCOLLVITM_H,         -- abap.raw
    CITYNAME_H,                      -- abap.raw
    CUSTOMERSERVICETELNMBR_H,        -- abap.raw
    FLIGHTARRIVALLOCATION_H,         -- abap.raw
    FLIGHTDEPARTURELOCATION_H,       -- abap.raw
    HOUSENUMBER_H,                   -- abap.raw
    INDIVIDUALRECEIPTAMOUNT_H,       -- abap.raw
    RECEIPTAMOUNTCURRENCYCODE_H,     -- abap.raw
    INDIVIDUALRECEIPTDATE_H,         -- abap.raw
    INVOICETOEMPLOYER_H,             -- abap.raw
    MEALSINCLSNINACMDTNRCPT_H,       -- abap.raw
    NAME_H,                          -- abap.raw
    NMBROFEMPLOYEESOFBP_H,           -- abap.raw
    NUMBEROFADDITIONALGUESTS_H,      -- abap.raw
    NUMBEROFDAYS_H,                  -- abap.raw
    NUMBEROFEMPLOYEES_H,             -- abap.raw
    NUMBEROFINVOICEITEMS_H,          -- abap.raw
    ORIGINALRECEIPTINVOICENUMBER_H,  -- abap.raw
    PAPERRECEIPTDOCUMENTNUMBER_H,    -- abap.raw
    PAYMENTAMOUNT_H,                 -- abap.raw
    PAYMENTCURRENCY_H,               -- abap.raw
    POSTALCODE_H,                    -- abap.raw
    RECEIPTEDITORTEXT_H,             -- abap.raw
    RECEIPTISCHECKED_H,              -- abap.raw
    RECEIPTSHORTTEXT_H,              -- abap.raw
    SERVICEFROMDATE_H,               -- abap.raw
    SERVICEPROVIDERCODE_H,           -- abap.raw
    SERVICETAXDESCLANG_H,            -- abap.raw
    SERVICETAXREGISTRATIONNUMBER_H,  -- abap.raw
    SERVICETAXSUBCODE_H,             -- abap.raw
    SERVICETAXTYPECODE_H,            -- abap.raw
    SERVICETODATE_H,                 -- abap.raw
    STREETNAME_H,                    -- abap.raw
    SUPPLIERCITYNAME_H,              -- abap.raw
    SUPPLIERCOUNTRYNAME_H,           -- abap.raw
    SUPPLIERNAME_H,                  -- abap.raw
    SUPPLIERPOSTALCODE_H,            -- abap.raw
    SUPPLIERSTATENAME_H,             -- abap.raw
    SUPPLIERSTREETNAME_H,            -- abap.raw
    TAXAMOUNT_H,                     -- abap.raw
    TAXCODE_H,                       -- abap.raw
    TAXJURISDICTION_H,               -- abap.raw
    TOTALNUMBEROFBREAKFASTS_H,       -- abap.raw
    TOTALNUMBEROFDINNERS_H,          -- abap.raw
    TOTALNUMBEROFLUNCHES_H,          -- abap.raw
    TRAVELCOUNTRYREGION_H,           -- abap.raw
    TRAVELEXCHANGERATE_H,            -- abap.raw
    TRAVELEXPENSEHASPAPERRECEIPT_H,  -- abap.raw
    TRAVELEXPENSETYPE_H,             -- abap.raw
    TRIPTYPEENTERPRISE_H,            -- abap.raw
    TRVLEXPNPROVIDERCODE_H,          -- abap.raw
    TRVLEXPNRECEIPTDESCRIPTION_H,    -- abap.raw
    VEHICLEMILEAGEVALUE_H,           -- abap.raw
    WORKLOCATIONNAME_H,              -- abap.raw
    RCPTPARTICIPANTFACET_H,          -- abap.raw
    RCPTPRODUCTFACET_H,              -- abap.raw
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELEXPENSEDOCUMENT)
);