C_ReceiptCostAssgmtArranger

DDL: C_RECEIPTCOSTASSGMTARRANGER Type: view_entity CONSUMPTION
73 Fields 1 Data Sources

Travel Expense Receipt Cost Assignment

C_ReceiptCostAssgmtArranger is a Consumption CDS View that provides data about "Travel Expense Receipt Cost Assignment" in SAP S/4HANA. It reads from 1 data source (I_TrvlExpnReceiptCostAssgmt) and exposes 73 fields with key fields PersonnelNumber, TravelTripNumber, CostAssignmentReferenceKey, TravelRequestSequenceNumber, TravelCostAssignmentType.

Data Sources (1)

SourceAliasJoin Type
I_TrvlExpnReceiptCostAssgmt I_TrvlExpnReceiptCostAssgmt projection

Annotations (9)

NameValueLevelField
EndUserText.label Travel Expense Receipt Cost Assignment view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber PersonnelNumber Personnel No.
KEY TravelTripNumber TravelTripNumber Trip Number
KEY CostAssignmentReferenceKey CostAssignmentReferenceKey Reference Key
KEY TravelRequestSequenceNumber TravelRequestSequenceNumber Sequence Number
KEY TravelCostAssignmentType TravelCostAssignmentType Cost Assignment Type
KEY TravelReqUUID TravelReqUUID UUID
KEY SeqReqUUID SeqReqUUID UUID
KEY ReceiptCostAssgmtSeqReqUUID ReceiptCostAssgmtSeqReqUUID UUID
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"
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
TrvlCostAssgmtAmtOrPctg TrvlCostAssgmtAmtOrPctg Amt/Percent
LastChangeDateTime LastChangeDateTime Timestamp
TrvlCostAssgmtReceiptAmount TrvlCostAssgmtReceiptAmount Amount
PaymentCurrency PaymentCurrency Payment Currency
RcptsCostLoclLastChgdDteTme RcptsCostLoclLastChgdDteTme Changed On
DestinationAssignment DestinationAssignment Destination Assignment
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_ReceiptCostAssgmtArranger.
-- 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_ReceiptCostAssgmtArranger AS
SELECT
  PersonnelNumber,
  TravelTripNumber,
  CostAssignmentReferenceKey,
  TravelRequestSequenceNumber,
  TravelCostAssignmentType,
  TravelReqUUID,
  SeqReqUUID,
  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,
  BusinessAreaName,
  ControllingAreaName,
  CostCenterName,
  CostAssgmtOrderName,
  CostObjectDesc,
  WBSElementName,
  NetworkName,
  ActivityName,
  SalesOrderName,
  SalesOrderItemName,
  BusinessProcessName,
  FundCenterName,
  FundName,
  FunctionalAreaName,
  GrantExtendedName,
  CommitmentItemName,
  ProjectName,
  TaskRoleName,
  BudgetPeriodName,
  CostAssignmentCategoryName,
  EarmarkedFundsDocName,
  EarmarkedFundsDocItemName,
  TravelRequestFieldGroup,
  TripFieldGroupName,
  TrvlCostAssgmtAmtOrPctg,
  LastChangeDateTime,
  TrvlCostAssgmtReceiptAmount,
  PaymentCurrency,
  RcptsCostLoclLastChgdDteTme,
  DestinationAssignment,
  virtual TravelCostAssignmentText : ltext AS virtualTravelCostAssignmentTextltext
FROM I_TrvlExpnReceiptCostAssgmt
;

Learn More