TRVS4_COSTASS

Transparent Table Application Table
69 Fields 2 CDS Views

Travel Cost Assignment

TRVS4_COSTASS is an SAP database table in S/4HANA. Travel Cost Assignment. It contains 69 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelCostAssignmentData view_entity from EXTENSION Travel Cost Assignment - Extension
I_TravelCostAssignmentData view_entity from BASIC Travel Cost Assignment

Fields (69)

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 costdistno COSTDISTNO SeqNo. CstDst.
KEY ref_key CHAR3 3-Byte field
KEY cost_assignment_type FITV_COST_ASSIGNMENT_TYPE Cost Assignment Type
perc_share PERC_SHARE Percent Cost Assign
comp_code BUKRS Company Code
bus_area GSBER Business Area
co_area KOKRS CO Area
costcenter PTRV_WEB_INTERFACE_KOSTL Cost Center
travel_order PTRV_WEB_INTERFACE_AUFNR Order
cost_obj KSTRG Cost Object
wbs_elemt PTRA_WEB_INTERFACE_PS_POSID WBS Element
network PTRV_WEB_INTERFACE_NPLNR Network
activity PTRV_WEB_INTERFACE_VORNR Activity No.
sales_ord PTRV_WEB_INTERFACE_KDAUF Sales Order
s_ord_item KDPOS Sales Ord. Item
co_busproc PTRV_WEB_INTERFACE_CO_PRZNR Business Proc.
funds_ctr FISTL Funds Center
fund BP_GEBER Fund
func_area FKBER Functional Area
grant_nbr PTRV_WEB_INTERFACE_GM_GRANT_NB Grant
cmmt_item_long PTRA_WEB_INTERFACE_FM_FIPEX Commitment Item
project_guid SYSUUID_C UUID
project_ext_id PTRV_PROJECT_EXT_ID Project Number
task_role_guid SYSUUID_C UUID
task_role_ext_id PTRV_TASK_ROLE_EXT_ID Task/Role Number
object_type PTRV_OBJ_TYPE Object Type
budget_period FM_BUDGET_PERIOD Budget Period
prctr PRCTR Profit Center
segment FB_SEGMENT Segment
category GLO_PTRV_WEB_COST_CAT Cost Category
kblnr KBLNR_FI Earmarked funds
kblpos KBLPOS Document Item
erlkz REFSETERLK Set "Completed"
display_only COSTDIST_DISPLAY_ONLY CstDst Displ-Only
field_group VDM_FIELDGROUP Accounting Object
field_group_descr PTRV_WEB_FIELD_GROUP_DESCR FldGr
rec_share_abs GESBB Amount
rec_curr WAERS Currency
perc_abs BETPR Amt/Percent
rec_curr_name LTEXT Long Text
key_stop KEYZI Dest.Assignment
comp_code_name LTEXT Long Text
bus_area_name LTEXT Long Text
co_area_name LTEXT Long Text
costcenter_name LTEXT Long Text
order_name LTEXT Long Text
cost_obj_name LTEXT Long Text
wbs_elemt_name LTEXT Long Text
network_name LTEXT Long Text
activity_name LTEXT Long Text
sales_ord_name LTEXT Long Text
s_ord_item_name LTEXT Long Text
co_busproc_name LTEXT Long Text
funds_ctr_name LTEXT Long Text
fund_name LTEXT Long Text
func_area_name LTEXT Long Text
grant_nbr_name LTEXT Long Text
cmmt_item_long_name LTEXT Long Text
project_ext_id_name LTEXT Long Text
task_role_ext_id_name LTEXT Long Text
budget_period_name LTEXT Long Text
category_name LTEXT Long Text
kblnr_name LTEXT Long Text
kblpos_name LTEXT Long Text
dummy_trvcost_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 Cost Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_COSTASS (
    MANDT,                      -- Client [MANDT]
    PERNR,                      -- Personnel No. [PERNR_D]
    REINR,                      -- Trip Number [REINR]
    HDVRS,                      -- Sequential no. [PTRV_HDVRS]
    COSTDISTNO,                 -- SeqNo. CstDst. [COSTDISTNO]
    REF_KEY,                    -- 3-Byte field [CHAR3]
    COST_ASSIGNMENT_TYPE,       -- Cost Assignment Type [FITV_COST_ASSIGNMENT_TYPE]
    PERC_SHARE,                 -- Percent Cost Assign [PERC_SHARE]
    COMP_CODE,                  -- Company Code [BUKRS]
    BUS_AREA,                   -- Business Area [GSBER]
    CO_AREA,                    -- CO Area [KOKRS]
    COSTCENTER,                 -- Cost Center [PTRV_WEB_INTERFACE_KOSTL]
    TRAVEL_ORDER,               -- Order [PTRV_WEB_INTERFACE_AUFNR]
    COST_OBJ,                   -- Cost Object [KSTRG]
    WBS_ELEMT,                  -- WBS Element [PTRA_WEB_INTERFACE_PS_POSID]
    NETWORK,                    -- Network [PTRV_WEB_INTERFACE_NPLNR]
    ACTIVITY,                   -- Activity No. [PTRV_WEB_INTERFACE_VORNR]
    SALES_ORD,                  -- Sales Order [PTRV_WEB_INTERFACE_KDAUF]
    S_ORD_ITEM,                 -- Sales Ord. Item [KDPOS]
    CO_BUSPROC,                 -- Business Proc. [PTRV_WEB_INTERFACE_CO_PRZNR]
    FUNDS_CTR,                  -- Funds Center [FISTL]
    FUND,                       -- Fund [BP_GEBER]
    FUNC_AREA,                  -- Functional Area [FKBER]
    GRANT_NBR,                  -- Grant [PTRV_WEB_INTERFACE_GM_GRANT_NB]
    CMMT_ITEM_LONG,             -- Commitment Item [PTRA_WEB_INTERFACE_FM_FIPEX]
    PROJECT_GUID,               -- UUID [SYSUUID_C]
    PROJECT_EXT_ID,             -- Project Number [PTRV_PROJECT_EXT_ID]
    TASK_ROLE_GUID,             -- UUID [SYSUUID_C]
    TASK_ROLE_EXT_ID,           -- Task/Role Number [PTRV_TASK_ROLE_EXT_ID]
    OBJECT_TYPE,                -- Object Type [PTRV_OBJ_TYPE]
    BUDGET_PERIOD,              -- Budget Period [FM_BUDGET_PERIOD]
    PRCTR,                      -- Profit Center [PRCTR]
    SEGMENT,                    -- Segment [FB_SEGMENT]
    CATEGORY,                   -- Cost Category [GLO_PTRV_WEB_COST_CAT]
    KBLNR,                      -- Earmarked funds [KBLNR_FI]
    KBLPOS,                     -- Document Item [KBLPOS]
    ERLKZ,                      -- Set "Completed" [REFSETERLK]
    DISPLAY_ONLY,               -- CstDst Displ-Only [COSTDIST_DISPLAY_ONLY]
    FIELD_GROUP,                -- Accounting Object [VDM_FIELDGROUP]
    FIELD_GROUP_DESCR,          -- FldGr [PTRV_WEB_FIELD_GROUP_DESCR]
    REC_SHARE_ABS,              -- Amount [GESBB]
    REC_CURR,                   -- Currency [WAERS]
    PERC_ABS,                   -- Amt/Percent [BETPR]
    REC_CURR_NAME,              -- Long Text [LTEXT]
    KEY_STOP,                   -- Dest.Assignment [KEYZI]
    COMP_CODE_NAME,             -- Long Text [LTEXT]
    BUS_AREA_NAME,              -- Long Text [LTEXT]
    CO_AREA_NAME,               -- Long Text [LTEXT]
    COSTCENTER_NAME,            -- Long Text [LTEXT]
    ORDER_NAME,                 -- Long Text [LTEXT]
    COST_OBJ_NAME,              -- Long Text [LTEXT]
    WBS_ELEMT_NAME,             -- Long Text [LTEXT]
    NETWORK_NAME,               -- Long Text [LTEXT]
    ACTIVITY_NAME,              -- Long Text [LTEXT]
    SALES_ORD_NAME,             -- Long Text [LTEXT]
    S_ORD_ITEM_NAME,            -- Long Text [LTEXT]
    CO_BUSPROC_NAME,            -- Long Text [LTEXT]
    FUNDS_CTR_NAME,             -- Long Text [LTEXT]
    FUND_NAME,                  -- Long Text [LTEXT]
    FUNC_AREA_NAME,             -- Long Text [LTEXT]
    GRANT_NBR_NAME,             -- Long Text [LTEXT]
    CMMT_ITEM_LONG_NAME,        -- Long Text [LTEXT]
    PROJECT_EXT_ID_NAME,        -- Long Text [LTEXT]
    TASK_ROLE_EXT_ID_NAME,      -- Long Text [LTEXT]
    BUDGET_PERIOD_NAME,         -- Long Text [LTEXT]
    CATEGORY_NAME,              -- Long Text [LTEXT]
    KBLNR_NAME,                 -- Long Text [LTEXT]
    KBLPOS_NAME,                -- Long Text [LTEXT]
    DUMMY_TRVCOST_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, COSTDISTNO, REF_KEY, COST_ASSIGNMENT_TYPE)
);

Learn More