R_TrvlExpnCostAssignmentDraft

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 R_TrvlExpnCostAssignmentDraft.
-- 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 R_TrvlExpnCostAssignmentDraft AS
SELECT
  TrvExpnCostAssignmentDraft.personnelnumber AS PersonnelNumber,
  TrvExpnCostAssignmentDraft.traveltripnumber AS TravelTripNumber,
  TrvExpnCostAssignmentDraft.travelrequuid AS TravelReqUUID,
  TrvExpnCostAssignmentDraft.seqrequuid AS SeqReqUUID,
  TrvExpnCostAssignmentDraft.travelrequestsequencenumber AS TravelRequestSequenceNumber,
  TrvExpnCostAssignmentDraft.costassignmentreferencekey AS CostAssignmentReferenceKey,
  TrvExpnCostAssignmentDraft.travelcostassignmenttype AS TravelCostAssignmentType,
  TrvExpnCostAssignmentDraft.travelexpnsequentialnumber AS TravelExpnSequentialNumber,
  TrvExpnCostAssignmentDraft.costassgmtpercentageinqty AS CostAssgmtPercentageInQty,
  TrvExpnCostAssignmentDraft.companycode AS CompanyCode,
  TrvExpnCostAssignmentDraft.businessarea AS BusinessArea,
  TrvExpnCostAssignmentDraft.controllingarea AS ControllingArea,
  TrvExpnCostAssignmentDraft.costcenter AS CostCenter,
  TrvExpnCostAssignmentDraft.travelorder AS TravelOrder,
  TrvExpnCostAssignmentDraft.costobject AS CostObject,
  TrvExpnCostAssignmentDraft.wbselement AS WBSElement,
  TrvExpnCostAssignmentDraft.accountassignmentnetworknumber AS AccountAssignmentNetworkNumber,
  TrvExpnCostAssignmentDraft.activity AS Activity,
  TrvExpnCostAssignmentDraft.salesorder AS SalesOrder,
  TrvExpnCostAssignmentDraft.salesorderitem AS SalesOrderItem,
  TrvExpnCostAssignmentDraft.businessprocess AS BusinessProcess,
  TrvExpnCostAssignmentDraft.fundcentertext AS FundCenterText,
  TrvExpnCostAssignmentDraft.fund AS Fund,
  TrvExpnCostAssignmentDraft.functionalarea AS FunctionalArea,
  TrvExpnCostAssignmentDraft.grantid AS GrantID,
  TrvExpnCostAssignmentDraft.commitmentitem AS CommitmentItem,
  TrvExpnCostAssignmentDraft.travelrequestprojectuuid AS TravelRequestProjectUUID,
  TrvExpnCostAssignmentDraft.externalprojectnumber AS ExternalProjectNumber,
  TrvExpnCostAssignmentDraft.taskroleuuid AS TaskRoleUUID,
  TrvExpnCostAssignmentDraft.taskrolenumber AS TaskRoleNumber,
  TrvExpnCostAssignmentDraft.costassignmentobjecttype AS CostAssignmentObjectType,
  TrvExpnCostAssignmentDraft.budgetperiod AS BudgetPeriod,
  TrvExpnCostAssignmentDraft.profitcenter AS ProfitCenter,
  TrvExpnCostAssignmentDraft.segment AS Segment,
  TrvExpnCostAssignmentDraft.travelrequestcostcategory AS TravelRequestCostCategory,
  TrvExpnCostAssignmentDraft.earmarkedfundsdocument AS EarmarkedFundsDocument,
  TrvExpnCostAssignmentDraft.earmarkedfundsdocumentitem AS EarmarkedFundsDocumentItem,
  TrvExpnCostAssignmentDraft.fundsmgmtcmtmtitemiscompleted AS FundsMgmtCmtmtItemIsCompleted,
  TrvExpnCostAssignmentDraft.costdistrisdsponly AS CostDistrIsDspOnly,
  TrvExpnCostAssignmentDraft.companycodename AS CompanyCodeName,
  TrvExpnCostAssignmentDraft.businessareaname AS BusinessAreaName,
  TrvExpnCostAssignmentDraft.controllingareaname AS ControllingAreaName,
  TrvExpnCostAssignmentDraft.costcentername AS CostCenterName,
  TrvExpnCostAssignmentDraft.costassgmtordername AS CostAssgmtOrderName,
  TrvExpnCostAssignmentDraft.costobjectdesc AS CostObjectDesc,
  TrvExpnCostAssignmentDraft.wbselementname AS WBSElementName,
  TrvExpnCostAssignmentDraft.networkname AS NetworkName,
  TrvExpnCostAssignmentDraft.activityname AS ActivityName,
  TrvExpnCostAssignmentDraft.salesordername AS SalesOrderName,
  TrvExpnCostAssignmentDraft.salesorderitemname AS SalesOrderItemName,
  TrvExpnCostAssignmentDraft.businessprocessname AS BusinessProcessName,
  TrvExpnCostAssignmentDraft.fundcentername AS FundCenterName,
  TrvExpnCostAssignmentDraft.fundname AS FundName,
  TrvExpnCostAssignmentDraft.functionalareaname AS FunctionalAreaName,
  TrvExpnCostAssignmentDraft.grantextendedname AS GrantExtendedName,
  TrvExpnCostAssignmentDraft.commitmentitemname AS CommitmentItemName,
  TrvExpnCostAssignmentDraft.projectname AS ProjectName,
  TrvExpnCostAssignmentDraft.taskrolename AS TaskRoleName,
  TrvExpnCostAssignmentDraft.budgetperiodname AS BudgetPeriodName,
  TrvExpnCostAssignmentDraft.costassignmentcategoryname AS CostAssignmentCategoryName,
  TrvExpnCostAssignmentDraft.earmarkedfundsdocname AS EarmarkedFundsDocName,
  TrvExpnCostAssignmentDraft.earmarkedfundsdocitemname AS EarmarkedFundsDocItemName,
  TrvExpnCostAssignmentDraft.travelrequestfieldgroup AS TravelRequestFieldGroup,
  TrvExpnCostAssignmentDraft.tripfieldgroupname AS TripFieldGroupName,
  TrvExpnCostAssignmentDraft.trvlcostassgmtreceiptamount AS TrvlCostAssgmtReceiptAmount,
  TrvExpnCostAssignmentDraft.paymentcurrency AS PaymentCurrency,
  TrvExpnCostAssignmentDraft.trvlcostassgmtamtorpctg AS TrvlCostAssgmtAmtOrPctg,
  TrvExpnCostAssignmentDraft.lastchangedatetime AS LastChangeDateTime,
  TrvExpnCostAssignmentDraft.costassgmtlocllastchgddtetme AS CostAssgmtLoclLastChgdDteTme,
  TrvExpnCostAssignmentDraft.trvlcostassgmtpercentageunit AS TrvlCostAssgmtPercentageUnit,
  TrvExpnCostAssignmentDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  TrvExpnCostAssignmentDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  TrvExpnCostAssignmentDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  TrvExpnCostAssignmentDraft.draftentityoperationcode AS DraftEntityOperationCode,
  TrvExpnCostAssignmentDraft.hasactiveentity AS HasActiveEntity,
  TrvExpnCostAssignmentDraft.accountassgmtntwknmbr_h AS AccountAssgmtNtwkNmbr_H,
  TrvExpnCostAssignmentDraft.activity_h AS Activity_H,
  TrvExpnCostAssignmentDraft.budgetperiod_h AS BudgetPeriod_H,
  TrvExpnCostAssignmentDraft.businessarea_h AS BusinessArea_H,
  TrvExpnCostAssignmentDraft.businessprocess_h AS BusinessProcess_H,
  TrvExpnCostAssignmentDraft.commitmentitem_h AS CommitmentItem_H,
  TrvExpnCostAssignmentDraft.companycode_h AS CompanyCode_H,
  TrvExpnCostAssignmentDraft.controllingarea_h AS ControllingArea_H,
  TrvExpnCostAssignmentDraft.costassignmentobjecttype_h AS CostAssignmentObjectType_H,
  TrvExpnCostAssignmentDraft.costcenter_h AS CostCenter_H,
  TrvExpnCostAssignmentDraft.costobject_h AS CostObject_H,
  TrvExpnCostAssignmentDraft.earmarkedfundsdocument_h AS EarmarkedFundsDocument_H,
  TrvExpnCostAssignmentDraft.earmarkedfundsdocumentitem_h AS EarmarkedFundsDocumentItem_H,
  TrvExpnCostAssignmentDraft.externalprojectnumber_h AS ExternalProjectNumber_H,
  TrvExpnCostAssignmentDraft.functionalarea_h AS FunctionalArea_H,
  TrvExpnCostAssignmentDraft.fund_h AS Fund_H,
  TrvExpnCostAssignmentDraft.fundcentertext_h AS FundCenterText_H,
  TrvExpnCostAssignmentDraft.fndsmgmtcmtmtitmiscmpltd_h AS FndsMgmtCmtmtItmIsCmpltd_H,
  TrvExpnCostAssignmentDraft.grantid_h AS GrantID_H,
  TrvExpnCostAssignmentDraft.profitcenter_h AS ProfitCenter_H,
  TrvExpnCostAssignmentDraft.salesorder_h AS SalesOrder_H,
  TrvExpnCostAssignmentDraft.salesorderitem_h AS SalesOrderItem_H,
  TrvExpnCostAssignmentDraft.segment_h AS Segment_H,
  TrvExpnCostAssignmentDraft.taskrolenumber_h AS TaskRoleNumber_H,
  TrvExpnCostAssignmentDraft.taskroleuuid_h AS TaskRoleUUID_H,
  TrvExpnCostAssignmentDraft.travelorder_h AS TravelOrder_H,
  TrvExpnCostAssignmentDraft.travelrequestcostcategory_h AS TravelRequestCostCategory_H,
  TrvExpnCostAssignmentDraft.travelrequestfieldgroup_h AS TravelRequestFieldGroup_H,
  TrvExpnCostAssignmentDraft.travelrequestprojectuuid_h AS TravelRequestProjectUUID_H,
  TrvExpnCostAssignmentDraft.wbselement_h AS WBSElement_H
FROM trvs4_e_costas_d AS TrvExpnCostAssignmentDraft
LEFT OUTER JOIN E_TrvlExpnCostAssignmentDraft AS _ExtensionCostAssignment ON PersonnelNumber = _ExtensionCostAssignment.PersonnelNumber AND TravelTripNumber = _ExtensionCostAssignment.TravelTripNumber AND TravelReqUUID = _ExtensionCostAssignment.TravelReqUUID AND SeqReqUUID = _ExtensionCostAssignment.SeqReqUUID AND TravelRequestSequenceNumber = _ExtensionCostAssignment.TravelRequestSequenceNumber AND CostAssignmentReferenceKey = _ExtensionCostAssignment.CostAssignmentReferenceKey AND TravelCostAssignmentType = _ExtensionCostAssignment.TravelCostAssignmentType  -- association [1..1]
;