C_TrvlCostAssgmtForArranger

DDL: C_TRVLCOSTASSGMTFORARRANGER Type: view_entity CONSUMPTION
69 Fields 1 Data Sources

Travel Request Cost Assgmt For Arranger

C_TrvlCostAssgmtForArranger is a Consumption CDS View that provides data about "Travel Request Cost Assgmt For Arranger" in SAP S/4HANA. It reads from 1 data source (I_TravelCostAssignment) and exposes 69 fields with key fields PersonnelNumber, TravelTripNumber, TravelReqUUID, SeqReqUUID, TravelRequestSequenceNumber.

Data Sources (1)

SourceAliasJoin Type
I_TravelCostAssignment I_TravelCostAssignment projection

Annotations (14)

NameValueLevelField
EndUserText.label Travel Request Cost Assgmt For Arranger view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources true view
AbapCatalog.extensibility.elementSuffix TCT view
AbapCatalog.extensibility.quota.maximumFields 350 view
AbapCatalog.extensibility.quota.maximumBytes 2240 view
UI.textArrangement #TEXT_ONLY view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber PersonnelNumber Personnel No.
KEY TravelTripNumber TravelTripNumber Trip Number
KEY TravelReqUUID TravelReqUUID UUID
KEY SeqReqUUID SeqReqUUID UUID
KEY TravelRequestSequenceNumber TravelRequestSequenceNumber Sequence Number
KEY CostAssignmentReferenceKey CostAssignmentReferenceKey Reference Key
KEY TravelCostAssignmentType TravelCostAssignmentType Cost Assignment Type
TravelExpnSequentialNumber TravelExpnSequentialNumber Sequential Number
CostAssgmtPercentageInQty CostAssgmtPercentageInQty Percentage
TrvlCostAssgmtPercentageUnit TrvlCostAssgmtPercentageUnit Unit
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
TravelOrder TravelOrder Order
CostObject CostObject Cost Object
WBSElement WBSElement WBS Internal ID
AccountAssignmentNetworkNumber AccountAssignmentNetworkNumber Network
Activity Activity VAT Activity
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
BusinessProcess BusinessProcess Business Process
FundCenterText FundCenterText Funds Center
Fund Fund Sender Fund
FunctionalArea FunctionalArea Sendr Fctl Area
GrantID GrantID Sender Grant
CommitmentItem CommitmentItem Commitment item
TravelRequestProjectUUID TravelRequestProjectUUID Project GUID
ExternalProjectNumber ExternalProjectNumber Project Number
TaskRoleUUID TaskRoleUUID Task Role GUID
TaskRoleNumber TaskRoleNumber Task / Role Number
CostAssignmentObjectType CostAssignmentObjectType Object Type
BudgetPeriod BudgetPeriod Budget Period
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
TravelRequestCostCategory TravelRequestCostCategory Cost Category
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
FundsMgmtCmtmtItemIsCompleted FundsMgmtCmtmtItemIsCompleted Set "Completed"
CostAssgmtLoclLastChgdDteTme CostAssgmtLoclLastChgdDteTme Changed On
DestinationAssignment DestinationAssignment Destination Assignment
CostDistrIsDspOnly CostDistrIsDspOnly Cost Distr Dsp Only
CompanyCodeName CompanyCodeName Company Name
BusinessAreaName BusinessAreaName Business Area Name
ControllingAreaName ControllingAreaName Long Text
CostCenterName CostCenterName Name
CostAssgmtOrderName CostAssgmtOrderName Long Text
CostObjectDesc CostObjectDesc Cost Object Name
WBSElementName WBSElementName Long Text
NetworkName NetworkName Long Text
ActivityName ActivityName Long Text
SalesOrderName SalesOrderName Long Text
SalesOrderItemName SalesOrderItemName Long Text
BusinessProcessName BusinessProcessName Long Text
FundCenterName FundCenterName Long Text
FundName FundName Long Text
FunctionalAreaName FunctionalAreaName Long Text
GrantExtendedName GrantExtendedName Long Text
CommitmentItemName CommitmentItemName Long Text
ProjectName ProjectName Long Text
TaskRoleName TaskRoleName Long Text
BudgetPeriodName BudgetPeriodName Long Text
CostAssignmentCategoryName CostAssignmentCategoryName Long Text
EarmarkedFundsDocName EarmarkedFundsDocName Long Text
EarmarkedFundsDocItemName EarmarkedFundsDocItemName Long Text
TravelRequestFieldGroup TravelRequestFieldGroup Accounting Object
TripFieldGroupName TripFieldGroupName Field Group Name
LastChangeDateTime LastChangeDateTime Timestamp
virtualTravelCostAssignmentTextltext

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 C_TrvlCostAssgmtForArranger.
-- 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 C_TrvlCostAssgmtForArranger AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  TravelReqUUID,
  SeqReqUUID,
  TravelRequestSequenceNumber,
  CostAssignmentReferenceKey,
  TravelCostAssignmentType,
  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,
  CostAssgmtLoclLastChgdDteTme,
  DestinationAssignment,
  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,
  LastChangeDateTime,
  virtual TravelCostAssignmentText : ltext AS virtualTravelCostAssignmentTextltext
FROM I_TravelCostAssignment
;

Learn More