TRVS4_RECEIPT
Travel Receipt
TRVS4_RECEIPT is an SAP database table in S/4HANA. Travel Receipt. It contains 250 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_TravelExpenseReceiptData | view_entity | from | EXTENSION | Travel Expense Receipt - Extension |
| I_TravelExpenseReceiptData | view_entity | from | BASIC | Travel Expense Receipt Data |
Fields (250)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| visiblespk | XFELD | Checkbox | ||||
| inputspk | XFELD | Checkbox | ||||
| requiredspk | XFELD | Checkbox | ||||
| exp_cate | BELAR | Expen.Category | ||||
| visiblepap | XFELD | Checkbox | ||||
| inputpap | XFELD | Checkbox | ||||
| requiredpap | XFELD | Checkbox | ||||
| paper_receipt | PAPER_RECEIPT_CORE | Paper Receipt | ||||
| rec_amount | PTRV_WEB_REC_AMOUNT | Amount | ||||
| visibleamn | XFELD | Checkbox | ||||
| inputamn | XFELD | Checkbox | ||||
| requiredamn | XFELD | Checkbox | ||||
| rec_curr | WAERS | Currency | ||||
| visiblecur | XFELD | Checkbox | ||||
| inputcur | XFELD | Checkbox | ||||
| requiredcur | XFELD | Checkbox | ||||
| rec_rate | UKURS_CURR | Exchange Rate | ||||
| visiblerat | XFELD | Checkbox | ||||
| inputrat | XFELD | Checkbox | ||||
| requiredrat | XFELD | Checkbox | ||||
| s_factor | FFACT_CURR | Ratio (from) | ||||
| t_factor | TFACT_CURR | Ratio (to) | ||||
| visibledat | XFELD | Checkbox | ||||
| inputdat | XFELD | Checkbox | ||||
| requireddat | XFELD | Checkbox | ||||
| rec_date | BELDT | Date | ||||
| pay_amount | GESBB | Amount | ||||
| visiblepam | XFELD | Checkbox | ||||
| inputpam | XFELD | Checkbox | ||||
| requiredpam | XFELD | Checkbox | ||||
| pay_curr | PTRV_PAYCURR | Accounting in | ||||
| visiblepcu | XFELD | Checkbox | ||||
| inputpcu | XFELD | Checkbox | ||||
| requiredpcu | XFELD | Checkbox | ||||
| tax_code | MWSKZ | Tax Code | ||||
| taxjurcode | TXJCD | Tax Jur. | ||||
| visiblestx | XFELD | Checkbox | ||||
| inputstx | XFELD | Checkbox | ||||
| requiredstx | XFELD | Checkbox | ||||
| 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 | ||||
| visiblebpp | XFELD | Checkbox | ||||
| inputbpp | XFELD | Checkbox | ||||
| requiredbpp | XFELD | Checkbox | ||||
| bus_reason | BUSRE | Bus. Partners | ||||
| ccomp | CCOMP | Company | ||||
| visibleccp | XFELD | Checkbox | ||||
| inputccp | XFELD | Checkbox | ||||
| requiredccp | XFELD | Checkbox | ||||
| c_doc | C_DOC | Document No. | ||||
| visiblecdc | XFELD | Checkbox | ||||
| inputcdc | XFELD | Checkbox | ||||
| requiredcdc | XFELD | Checkbox | ||||
| c_txt | C_TXT | Description | ||||
| visiblectx | XFELD | Checkbox | ||||
| inputctx | XFELD | Checkbox | ||||
| requiredctx | XFELD | Checkbox | ||||
| 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 | ||||
| visiblerok | XFELD | Checkbox | ||||
| inputrok | XFELD | Checkbox | ||||
| requiredrok | XFELD | Checkbox | ||||
| 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 | ||||
| visiblerno | XFELD | Checkbox | ||||
| inputrno | XFELD | Checkbox | ||||
| requiredrno | XFELD | Checkbox | ||||
| receipt_item | PTRV_RECEIPT_ITEM | No. of Invoice Item | ||||
| visiblerit | XFELD | Checkbox | ||||
| inputrit | XFELD | Checkbox | ||||
| requiredrit | XFELD | Checkbox | ||||
| vat_amount | TRV_WMWST | Tax Amount | ||||
| visiblevam | XFELD | Checkbox | ||||
| inputvam | XFELD | Checkbox | ||||
| requiredvam | XFELD | Checkbox | ||||
| vat_service_code | PTRV_VAT_SERVICE_CODE | Services | ||||
| visiblevsc | XFELD | Checkbox | ||||
| inputvsc | XFELD | Checkbox | ||||
| requiredvsc | XFELD | Checkbox | ||||
| vat_service_desc | PTRV_VAT_SERVICE_DESC | Descr.of Service | ||||
| visiblevsd | XFELD | Checkbox | ||||
| inputvsd | XFELD | Checkbox | ||||
| requiredvsd | XFELD | Checkbox | ||||
| vat_reg_no | STCEG | VAT Reg. No. | ||||
| visiblevrn | XFELD | Checkbox | ||||
| inputvrn | XFELD | Checkbox | ||||
| requiredvrn | XFELD | Checkbox | ||||
| vat_reg_no_nat | STCD1 | Tax Number 1 | ||||
| visiblevnn | XFELD | Checkbox | ||||
| inputvnn | XFELD | Checkbox | ||||
| requiredvnn | XFELD | Checkbox | ||||
| name | AD_NAME1 | Name | ||||
| visiblenam | XFELD | Checkbox | ||||
| inputnam | XFELD | Checkbox | ||||
| requirednam | XFELD | Checkbox | ||||
| street | AD_STREET | Street | ||||
| visiblestr | XFELD | Checkbox | ||||
| inputstr | XFELD | Checkbox | ||||
| requiredstr | XFELD | Checkbox | ||||
| house_num | AD_HSNM1 | House Number | ||||
| visiblehnu | XFELD | Checkbox | ||||
| inputhnu | XFELD | Checkbox | ||||
| requiredhnu | XFELD | Checkbox | ||||
| post_code | AD_PSTCD1 | Postal Code | ||||
| visiblepcd | XFELD | Checkbox | ||||
| inputpcd | XFELD | Checkbox | ||||
| requiredpcd | XFELD | Checkbox | ||||
| city | AD_CITY1 | City | ||||
| visiblecty | XFELD | Checkbox | ||||
| inputcty | XFELD | Checkbox | ||||
| requiredcty | XFELD | Checkbox | ||||
| 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. | ||||
| visiblemob | XFELD | Checkbox | ||||
| inputmob | XFELD | Checkbox | ||||
| requiredmob | XFELD | Checkbox | ||||
| air_departure | AIR_LOCATION | IATA | ||||
| visibleaid | XFELD | Checkbox | ||||
| inputaid | XFELD | Checkbox | ||||
| requiredaid | XFELD | Checkbox | ||||
| air_arrival | AIR_LOCATION | IATA | ||||
| visibleaia | XFELD | Checkbox | ||||
| inputaia | XFELD | Checkbox | ||||
| requiredaia | XFELD | Checkbox | ||||
| airline | AIRLINE | Airline | ||||
| visibleail | XFELD | Checkbox | ||||
| inputail | XFELD | Checkbox | ||||
| requiredail | XFELD | Checkbox | ||||
| air_cabin_class | AIR_CABIN_CLASS | Cabin Class | ||||
| visibleaic | XFELD | Checkbox | ||||
| inputaic | XFELD | Checkbox | ||||
| requiredaic | XFELD | Checkbox | ||||
| air_ticket_number | PTRV_TICKET_NUMBER | Ticket Number | ||||
| visibleait | XFELD | Checkbox | ||||
| inputait | XFELD | Checkbox | ||||
| requiredait | XFELD | Checkbox | ||||
| car_odometer_reading | CAR_ODOMETER_READING | Mileage | ||||
| visibleodo | XFELD | Checkbox | ||||
| inputodo | XFELD | Checkbox | ||||
| requiredodo | XFELD | Checkbox | ||||
| se_name | AD_NAME1 | Name | ||||
| visiblesna | XFELD | Checkbox | ||||
| inputsna | XFELD | Checkbox | ||||
| requiredsna | XFELD | Checkbox | ||||
| se_street | AD_STREET | Street | ||||
| visiblesst | XFELD | Checkbox | ||||
| inputsst | XFELD | Checkbox | ||||
| requiredsst | XFELD | Checkbox | ||||
| se_city | AD_CITY1 | City | ||||
| visiblesci | XFELD | Checkbox | ||||
| inputsci | XFELD | Checkbox | ||||
| requiredsci | XFELD | Checkbox | ||||
| se_state_province | SE_STATE_PROVINCE | District (US:County) | ||||
| visiblespr | XFELD | Checkbox | ||||
| inputspr | XFELD | Checkbox | ||||
| requiredspr | XFELD | Checkbox | ||||
| se_country | SE_COUNTRY | Country/Region | ||||
| visiblesco | XFELD | Checkbox | ||||
| inputsco | XFELD | Checkbox | ||||
| requiredsco | XFELD | Checkbox | ||||
| se_postal_code | AD_PSTCD1 | Postal Code | ||||
| visiblespc | XFELD | Checkbox | ||||
| inputspc | XFELD | Checkbox | ||||
| requiredspc | XFELD | Checkbox | ||||
| se_customer_service_phone | SE_CUSTOMER_SERVICE_PHONE | Ser.Tel.No. | ||||
| visiblesph | XFELD | Checkbox | ||||
| inputsph | XFELD | Checkbox | ||||
| requiredsph | XFELD | Checkbox | ||||
| 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 | ||||
| exp_type_name | TEXT_SPKZL | Name of Exp. Type | ||||
| exp_cate_name | LTEXT | Long Text | ||||
| rec_curr_name | LTEXT | Long Text | ||||
| pay_curr_name | LTEXT | Long Text | ||||
| tax_code_name | TEXT1_007S | Description | ||||
| taxjurcode_name | TM_TEXT1_TXJCD | Description | ||||
| country_region_name | TEXT_RGION | Name Ctry/Region | ||||
| ccomp_name | TEXT_CCARD | Credit Card Company | ||||
| p_ctg_name | LTEXT | Long Text | ||||
| p_prv_name | PROVIDER_NAME | Name | ||||
| payout_name | TEXT_CCOMP | Service prov. | ||||
| tt_comsp_name | TEXT_BEREI | Name | ||||
| 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 | ||||
| dummy_trvreceipt_incl_eew_ps | CFD_DUMMY | Dummy |
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]
VISIBLESPK, -- Checkbox [XFELD]
INPUTSPK, -- Checkbox [XFELD]
REQUIREDSPK, -- Checkbox [XFELD]
EXP_CATE, -- Expen.Category [BELAR]
VISIBLEPAP, -- Checkbox [XFELD]
INPUTPAP, -- Checkbox [XFELD]
REQUIREDPAP, -- Checkbox [XFELD]
PAPER_RECEIPT, -- Paper Receipt [PAPER_RECEIPT_CORE]
REC_AMOUNT, -- Amount [PTRV_WEB_REC_AMOUNT]
VISIBLEAMN, -- Checkbox [XFELD]
INPUTAMN, -- Checkbox [XFELD]
REQUIREDAMN, -- Checkbox [XFELD]
REC_CURR, -- Currency [WAERS]
VISIBLECUR, -- Checkbox [XFELD]
INPUTCUR, -- Checkbox [XFELD]
REQUIREDCUR, -- Checkbox [XFELD]
REC_RATE, -- Exchange Rate [UKURS_CURR]
VISIBLERAT, -- Checkbox [XFELD]
INPUTRAT, -- Checkbox [XFELD]
REQUIREDRAT, -- Checkbox [XFELD]
S_FACTOR, -- Ratio (from) [FFACT_CURR]
T_FACTOR, -- Ratio (to) [TFACT_CURR]
VISIBLEDAT, -- Checkbox [XFELD]
INPUTDAT, -- Checkbox [XFELD]
REQUIREDDAT, -- Checkbox [XFELD]
REC_DATE, -- Date [BELDT]
PAY_AMOUNT, -- Amount [GESBB]
VISIBLEPAM, -- Checkbox [XFELD]
INPUTPAM, -- Checkbox [XFELD]
REQUIREDPAM, -- Checkbox [XFELD]
PAY_CURR, -- Accounting in [PTRV_PAYCURR]
VISIBLEPCU, -- Checkbox [XFELD]
INPUTPCU, -- Checkbox [XFELD]
REQUIREDPCU, -- Checkbox [XFELD]
TAX_CODE, -- Tax Code [MWSKZ]
TAXJURCODE, -- Tax Jur. [TXJCD]
VISIBLESTX, -- Checkbox [XFELD]
INPUTSTX, -- Checkbox [XFELD]
REQUIREDSTX, -- Checkbox [XFELD]
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]
VISIBLEBPP, -- Checkbox [XFELD]
INPUTBPP, -- Checkbox [XFELD]
REQUIREDBPP, -- Checkbox [XFELD]
BUS_REASON, -- Bus. Partners [BUSRE]
CCOMP, -- Company [CCOMP]
VISIBLECCP, -- Checkbox [XFELD]
INPUTCCP, -- Checkbox [XFELD]
REQUIREDCCP, -- Checkbox [XFELD]
C_DOC, -- Document No. [C_DOC]
VISIBLECDC, -- Checkbox [XFELD]
INPUTCDC, -- Checkbox [XFELD]
REQUIREDCDC, -- Checkbox [XFELD]
C_TXT, -- Description [C_TXT]
VISIBLECTX, -- Checkbox [XFELD]
INPUTCTX, -- Checkbox [XFELD]
REQUIREDCTX, -- Checkbox [XFELD]
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]
VISIBLEROK, -- Checkbox [XFELD]
INPUTROK, -- Checkbox [XFELD]
REQUIREDROK, -- Checkbox [XFELD]
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]
VISIBLERNO, -- Checkbox [XFELD]
INPUTRNO, -- Checkbox [XFELD]
REQUIREDRNO, -- Checkbox [XFELD]
RECEIPT_ITEM, -- No. of Invoice Item [PTRV_RECEIPT_ITEM]
VISIBLERIT, -- Checkbox [XFELD]
INPUTRIT, -- Checkbox [XFELD]
REQUIREDRIT, -- Checkbox [XFELD]
VAT_AMOUNT, -- Tax Amount [TRV_WMWST]
VISIBLEVAM, -- Checkbox [XFELD]
INPUTVAM, -- Checkbox [XFELD]
REQUIREDVAM, -- Checkbox [XFELD]
VAT_SERVICE_CODE, -- Services [PTRV_VAT_SERVICE_CODE]
VISIBLEVSC, -- Checkbox [XFELD]
INPUTVSC, -- Checkbox [XFELD]
REQUIREDVSC, -- Checkbox [XFELD]
VAT_SERVICE_DESC, -- Descr.of Service [PTRV_VAT_SERVICE_DESC]
VISIBLEVSD, -- Checkbox [XFELD]
INPUTVSD, -- Checkbox [XFELD]
REQUIREDVSD, -- Checkbox [XFELD]
VAT_REG_NO, -- VAT Reg. No. [STCEG]
VISIBLEVRN, -- Checkbox [XFELD]
INPUTVRN, -- Checkbox [XFELD]
REQUIREDVRN, -- Checkbox [XFELD]
VAT_REG_NO_NAT, -- Tax Number 1 [STCD1]
VISIBLEVNN, -- Checkbox [XFELD]
INPUTVNN, -- Checkbox [XFELD]
REQUIREDVNN, -- Checkbox [XFELD]
NAME, -- Name [AD_NAME1]
VISIBLENAM, -- Checkbox [XFELD]
INPUTNAM, -- Checkbox [XFELD]
REQUIREDNAM, -- Checkbox [XFELD]
STREET, -- Street [AD_STREET]
VISIBLESTR, -- Checkbox [XFELD]
INPUTSTR, -- Checkbox [XFELD]
REQUIREDSTR, -- Checkbox [XFELD]
HOUSE_NUM, -- House Number [AD_HSNM1]
VISIBLEHNU, -- Checkbox [XFELD]
INPUTHNU, -- Checkbox [XFELD]
REQUIREDHNU, -- Checkbox [XFELD]
POST_CODE, -- Postal Code [AD_PSTCD1]
VISIBLEPCD, -- Checkbox [XFELD]
INPUTPCD, -- Checkbox [XFELD]
REQUIREDPCD, -- Checkbox [XFELD]
CITY, -- City [AD_CITY1]
VISIBLECTY, -- Checkbox [XFELD]
INPUTCTY, -- Checkbox [XFELD]
REQUIREDCTY, -- Checkbox [XFELD]
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]
VISIBLEMOB, -- Checkbox [XFELD]
INPUTMOB, -- Checkbox [XFELD]
REQUIREDMOB, -- Checkbox [XFELD]
AIR_DEPARTURE, -- IATA [AIR_LOCATION]
VISIBLEAID, -- Checkbox [XFELD]
INPUTAID, -- Checkbox [XFELD]
REQUIREDAID, -- Checkbox [XFELD]
AIR_ARRIVAL, -- IATA [AIR_LOCATION]
VISIBLEAIA, -- Checkbox [XFELD]
INPUTAIA, -- Checkbox [XFELD]
REQUIREDAIA, -- Checkbox [XFELD]
AIRLINE, -- Airline [AIRLINE]
VISIBLEAIL, -- Checkbox [XFELD]
INPUTAIL, -- Checkbox [XFELD]
REQUIREDAIL, -- Checkbox [XFELD]
AIR_CABIN_CLASS, -- Cabin Class [AIR_CABIN_CLASS]
VISIBLEAIC, -- Checkbox [XFELD]
INPUTAIC, -- Checkbox [XFELD]
REQUIREDAIC, -- Checkbox [XFELD]
AIR_TICKET_NUMBER, -- Ticket Number [PTRV_TICKET_NUMBER]
VISIBLEAIT, -- Checkbox [XFELD]
INPUTAIT, -- Checkbox [XFELD]
REQUIREDAIT, -- Checkbox [XFELD]
CAR_ODOMETER_READING, -- Mileage [CAR_ODOMETER_READING]
VISIBLEODO, -- Checkbox [XFELD]
INPUTODO, -- Checkbox [XFELD]
REQUIREDODO, -- Checkbox [XFELD]
SE_NAME, -- Name [AD_NAME1]
VISIBLESNA, -- Checkbox [XFELD]
INPUTSNA, -- Checkbox [XFELD]
REQUIREDSNA, -- Checkbox [XFELD]
SE_STREET, -- Street [AD_STREET]
VISIBLESST, -- Checkbox [XFELD]
INPUTSST, -- Checkbox [XFELD]
REQUIREDSST, -- Checkbox [XFELD]
SE_CITY, -- City [AD_CITY1]
VISIBLESCI, -- Checkbox [XFELD]
INPUTSCI, -- Checkbox [XFELD]
REQUIREDSCI, -- Checkbox [XFELD]
SE_STATE_PROVINCE, -- District (US:County) [SE_STATE_PROVINCE]
VISIBLESPR, -- Checkbox [XFELD]
INPUTSPR, -- Checkbox [XFELD]
REQUIREDSPR, -- Checkbox [XFELD]
SE_COUNTRY, -- Country/Region [SE_COUNTRY]
VISIBLESCO, -- Checkbox [XFELD]
INPUTSCO, -- Checkbox [XFELD]
REQUIREDSCO, -- Checkbox [XFELD]
SE_POSTAL_CODE, -- Postal Code [AD_PSTCD1]
VISIBLESPC, -- Checkbox [XFELD]
INPUTSPC, -- Checkbox [XFELD]
REQUIREDSPC, -- Checkbox [XFELD]
SE_CUSTOMER_SERVICE_PHONE, -- Ser.Tel.No. [SE_CUSTOMER_SERVICE_PHONE]
VISIBLESPH, -- Checkbox [XFELD]
INPUTSPH, -- Checkbox [XFELD]
REQUIREDSPH, -- Checkbox [XFELD]
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]
EXP_TYPE_NAME, -- Name of Exp. Type [TEXT_SPKZL]
EXP_CATE_NAME, -- Long Text [LTEXT]
REC_CURR_NAME, -- Long Text [LTEXT]
PAY_CURR_NAME, -- Long Text [LTEXT]
TAX_CODE_NAME, -- Description [TEXT1_007S]
TAXJURCODE_NAME, -- Description [TM_TEXT1_TXJCD]
COUNTRY_REGION_NAME, -- Name Ctry/Region [TEXT_RGION]
CCOMP_NAME, -- Credit Card Company [TEXT_CCARD]
P_CTG_NAME, -- Long Text [LTEXT]
P_PRV_NAME, -- Name [PROVIDER_NAME]
PAYOUT_NAME, -- Service prov. [TEXT_CCOMP]
TT_COMSP_NAME, -- Name [TEXT_BEREI]
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]
DUMMY_TRVRECEIPT_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, RECEIPTNO)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA