I_TrvlExpnReceiptCostAssgmt

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_TrvlExpnReceiptCostAssgmt.
-- 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_TrvlExpnReceiptCostAssgmt AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  CostAssignmentReferenceKey,
  TravelRequestSequenceNumber,
  TravelCostAssignmentType,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS TravelReqUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS SeqReqUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS ReceiptCostAssgmtSeqReqUUID,
  TravelExpnSequentialNumber,
  CostAssgmtPercentageInQty,
  TrvlCostAssgmtPercentageUnit,
  CompanyCode,
  BusinessArea,
  ControllingArea,
  CostCenter,
  TravelOrder,
  CostObject,
  WBSElement,
  AccountAssignmentNetworkNumber,
  Activity,
  SalesOrder,
  SalesOrderItem,
  BusinessProcess,
  FundCenterText,
  Fund,
  FunctionalArea,
  GrantID,
  CommitmentItem,
  TravelRequestProjectUUID,
  ExternalProjectNumber,
  TaskRoleUUID,
  TaskRoleNumber,
  CostAssignmentObjectType,
  BudgetPeriod,
  ProfitCenter,
  Segment,
  TravelRequestCostCategory,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  FundsMgmtCmtmtItemIsCompleted,
  CostDistrIsDspOnly,
  CompanyCodeName,
  cast( _BusinessAreaText.BusinessAreaName as vdm_bus_area_name ) AS BusinessAreaName,
  ControllingAreaName,
  CostCenterName,
  CostAssgmtOrderName,
  CostObjectDesc,
  WBSElementName,
  NetworkName,
  ActivityName,
  SalesOrderName,
  SalesOrderItemName,
  BusinessProcessName,
  FundCenterName,
  FundName,
  FunctionalAreaName,
  GrantExtendedName,
  CommitmentItemName,
  ProjectName,
  TaskRoleName,
  BudgetPeriodName,
  CostAssignmentCategoryName,
  EarmarkedFundsDocName,
  EarmarkedFundsDocItemName,
  TravelRequestFieldGroup,
  TripFieldGroupName,
  TrvlCostAssgmtReceiptAmount,
  PaymentCurrency,
  cast( tstmp_current_utctimestamp() as vdm_lastchangedon) AS LastChangeDateTime,
  cast(0.0000000 as abp_lastchange_tstmpl) AS RcptsCostLoclLastChgdDteTme,
  DestinationAssignment
FROM I_TravelCostAssignmentData
LEFT OUTER JOIN I_TravelExpense AS _TravelExpense ON PersonnelNumber = _TravelExpense.PersonnelNumber AND TravelTripNumber = _TravelExpense.TravelTripNumber AND TravelReqUUID = _TravelExpense.TravelReqUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [1]
;