I_TravelCostAssignment

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_TravelCostAssignment.
-- 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_TravelCostAssignment AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS TravelReqUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS SeqReqUUID,
  TravelRequestSequenceNumber,
  CostAssignmentReferenceKey,
  TravelCostAssignmentType,
  TravelExpnSequentialNumber,
  CostAssgmtPercentageInQty,
  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,
  BusinessAreaName,
  ControllingAreaName,
  CostCenterName,
  CostAssgmtOrderName,
  CostObjectDesc,
  WBSElementName,
  NetworkName,
  ActivityName,
  SalesOrderName,
  SalesOrderItemName,
  BusinessProcessName,
  FundCenterName,
  FundName,
  FunctionalAreaName,
  GrantExtendedName,
  CommitmentItemName,
  ProjectName,
  TaskRoleName,
  BudgetPeriodName,
  CostAssignmentCategoryName,
  EarmarkedFundsDocName,
  EarmarkedFundsDocItemName,
  TravelRequestFieldGroup,
  TripFieldGroupName,
  cast( tstmp_current_utctimestamp() as vdm_lastchangedon) AS LastChangeDateTime,
  cast(0.0000000 as abp_lastchange_tstmpl) AS CostAssgmtLoclLastChgdDteTme,
  TrvlCostAssgmtPercentageUnit,
  TrvlCostAssgmtAmtOrPctg,
  DestinationAssignment
FROM I_TravelCostAssignmentData
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]
;