I_TrvlExpnReceiptCostAssgmtTP

DDL: I_TRVLEXPNRECEIPTCOSTASSGMTTP Type: view_entity TRANSACTIONAL
72 Fields 1 Data Sources

Trvl Expn Receipt Cost Assgmt - TP

I_TrvlExpnReceiptCostAssgmtTP is a Transactional CDS View that provides data about "Trvl Expn Receipt Cost Assgmt - TP" in SAP S/4HANA. It reads from 1 data source (I_TrvlExpnReceiptCostAssgmt) and exposes 72 fields with key fields PersonnelNumber, TravelTripNumber, CostAssignmentReferenceKey, TravelRequestSequenceNumber, TravelCostAssignmentType.

Data Sources (1)

SourceAliasJoin Type
I_TrvlExpnReceiptCostAssgmt I_TrvlExpnReceiptCostAssgmt projection

Annotations (9)

NameValueLevelField
EndUserText.label Trvl Expn Receipt Cost Assgmt - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (72)

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
TrvlCostAssgmtReceiptAmount TrvlCostAssgmtReceiptAmount Amount
PaymentCurrency PaymentCurrency Payment Currency
TrvlCostAssgmtAmtOrPctg TrvlCostAssgmtAmtOrPctg Amt/Percent
LastChangeDateTime LastChangeDateTime Timestamp
RcptsCostLoclLastChgdDteTme RcptsCostLoclLastChgdDteTme Changed On
DestinationAssignment DestinationAssignment Destination Assignment

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_TrvlExpnReceiptCostAssgmtTP.
-- 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_TrvlExpnReceiptCostAssgmtTP 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,
  TrvlCostAssgmtReceiptAmount,
  PaymentCurrency,
  TrvlCostAssgmtAmtOrPctg,
  LastChangeDateTime,
  RcptsCostLoclLastChgdDteTme,
  DestinationAssignment
FROM I_TrvlExpnReceiptCostAssgmt
;

Learn More