I_TravelCostAssignmentData

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TravelCostAssignmentData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_TravelCostAssignmentData AS
SELECT
  pernr AS PersonnelNumber,
  reinr AS TravelTripNumber,
  cast( hdvrs as vdm_sequentialnumber preserving type ) AS TravelExpnSequentialNumber,
  cast( costdistno as vdm_costdistno preserving type ) AS TravelRequestSequenceNumber,
  cast( ref_key as vdm_costassignment_refkey preserving type ) AS CostAssignmentReferenceKey,
  cost_assignment_type AS TravelCostAssignmentType,
  cast( perc_share as vdm_perc_share preserving type ) AS CostAssgmtPercentageInQty,
  comp_code AS CompanyCode,
  bus_area AS BusinessArea,
  co_area AS ControllingArea,
  CostCenter,
  travel_order AS TravelOrder,
  cost_obj AS CostObject,
  wbs_elemt AS WBSElement,
  network AS AccountAssignmentNetworkNumber,
  Activity,
  sales_ord AS SalesOrder,
  s_ord_item AS SalesOrderItem,
  co_busproc AS BusinessProcess,
  funds_ctr AS FundCenterText,
  Fund,
  func_area AS FunctionalArea,
  grant_nbr AS GrantID,
  cast( cmmt_item_long as fm_fipex preserving type ) AS CommitmentItem,
  cast( project_guid as vdm_project_guid preserving type ) AS TravelRequestProjectUUID,
  project_ext_id AS ExternalProjectNumber,
  cast( task_role_guid as vdm_task_role_guid preserving type ) AS TaskRoleUUID,
  cast( task_role_ext_id as vdm_taskrolenumber preserving type ) AS TaskRoleNumber,
  object_type AS CostAssignmentObjectType,
  budget_period AS BudgetPeriod,
  prctr AS ProfitCenter,
  Segment,
  category AS TravelRequestCostCategory,
  kblnr AS EarmarkedFundsDocument,
  kblpos AS EarmarkedFundsDocumentItem,
  erlkz AS FundsMgmtCmtmtItemIsCompleted,
  cast( display_only as vdm_costdistrisdsponly preserving type ) AS CostDistrIsDspOnly,
  cast( comp_code_name as vdm_comp_code_name preserving type ) AS CompanyCodeName,
  cast( bus_area_name as vdm_bus_area_name preserving type ) AS BusinessAreaName,
  co_area_name AS ControllingAreaName,
  cast( costcenter_name as vdm_costcenter_name preserving type ) AS CostCenterName,
  order_name AS CostAssgmtOrderName,
  cast( cost_obj_name as vdm_cost_obj_name preserving type ) AS CostObjectDesc,
  wbs_elemt_name AS WBSElementName,
  network_name AS NetworkName,
  activity_name AS ActivityName,
  sales_ord_name AS SalesOrderName,
  s_ord_item_name AS SalesOrderItemName,
  co_busproc_name AS BusinessProcessName,
  funds_ctr_name AS FundCenterName,
  fund_name AS FundName,
  func_area_name AS FunctionalAreaName,
  grant_nbr_name AS GrantExtendedName,
  cmmt_item_long_name AS CommitmentItemName,
  project_ext_id_name AS ProjectName,
  task_role_ext_id_name AS TaskRoleName,
  budget_period_name AS BudgetPeriodName,
  category_name AS CostAssignmentCategoryName,
  kblnr_name AS EarmarkedFundsDocName,
  kblpos_name AS EarmarkedFundsDocItemName,
  rec_share_abs AS TrvlCostAssgmtReceiptAmount,
  rec_curr AS PaymentCurrency,
  cast( field_group as vdm_fieldgroup preserving type) AS TravelRequestFieldGroup,
  cast( field_group_descr as vdm_tripfieldgroupname preserving type ) AS TripFieldGroupName,
  cast( '%' as unit ) AS TrvlCostAssgmtPercentageUnit,
  perc_abs AS TrvlCostAssgmtAmtOrPctg,
  key_stop AS DestinationAssignment,
  hextobin('00') AS AccountAssgmtNtwkNmbr_H,
  hextobin('00') AS Activity_H,
  hextobin('00') AS BudgetPeriod_H,
  hextobin('00') AS BusinessArea_H,
  hextobin('00') AS BusinessProcess_H,
  hextobin('00') AS CommitmentItem_H,
  hextobin('00') AS CompanyCode_H,
  hextobin('00') AS ControllingArea_H,
  hextobin('00') AS CostAssignmentObjectType_H,
  hextobin('00') AS CostCenter_H,
  hextobin('00') AS CostObject_H,
  hextobin('00') AS EarmarkedFundsDocument_H,
  hextobin('00') AS EarmarkedFundsDocumentItem_H,
  hextobin('00') AS ExternalProjectNumber_H,
  hextobin('00') AS FunctionalArea_H,
  hextobin('00') AS Fund_H,
  hextobin('00') AS FundCenterText_H,
  hextobin('00') AS FndsMgmtCmtmtItmIsCmpltd_H,
  hextobin('00') AS GrantID_H,
  hextobin('00') AS ProfitCenter_H,
  hextobin('00') AS SalesOrder_H,
  hextobin('00') AS SalesOrderItem_H,
  hextobin('00') AS Segment_H,
  hextobin('00') AS TaskRoleNumber_H,
  hextobin('00') AS TaskRoleUUID_H,
  hextobin('00') AS TravelOrder_H,
  hextobin('00') AS TravelRequestCostCategory_H,
  hextobin('00') AS TravelRequestFieldGroup_H,
  hextobin('00') AS TravelRequestProjectUUID_H,
  hextobin('00') AS WBSElement_H,
  hextobin('00') AS CostAssgmtPercentageInQty_H,
  hextobin('00') AS TrvlCostAssgmtReceiptAmount_H
FROM trvs4_costass
LEFT OUTER JOIN E_TravelCostAssignmentData AS _ExtensionCostAssignment ON PersonnelNumber = _ExtensionCostAssignment.PersonnelNumber AND TravelTripNumber = _ExtensionCostAssignment.TravelTripNumber AND TravelExpnSequentialNumber = _ExtensionCostAssignment.TravelExpnSequentialNumber AND CostAssignmentReferenceKey = _ExtensionCostAssignment.CostAssignmentReferenceKey AND TravelCostAssignmentType = _ExtensionCostAssignment.TravelCostAssignmentType AND TravelRequestSequenceNumber = _ExtensionCostAssignment.TravelRequestSequenceNumber  -- association [0..1]
;