E_TrvlExpnCostAssignmentDraft

DDL: E_TRVLEXPNCOSTASSIGNMENTDRAFT Type: view_entity EXTENSION

Trvl Expn Cost Assgmt - Extn

E_TrvlExpnCostAssignmentDraft is a Extension CDS View that provides data about "Trvl Expn Cost Assgmt - Extn" in SAP S/4HANA. It reads from 1 data source (trvs4_e_costas_d) and exposes 7 fields with key fields PersonnelNumber, TravelTripNumber, TravelReqUUID, SeqReqUUID, TravelRequestSequenceNumber.

Data Sources (1)

SourceAliasJoin Type
trvs4_e_costas_d Persistence from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Trvl Expn Cost Assgmt - Extn view
VDM.viewType #EXTENSION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix TCT view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.quota.maximumFields 238 view
AbapCatalog.extensibility.quota.maximumBytes 2240 view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber trvs4_e_costas_d personnelnumber Personnel No.
KEY TravelTripNumber trvs4_e_costas_d traveltripnumber Trip Number
KEY TravelReqUUID trvs4_e_costas_d travelrequuid UUID
KEY SeqReqUUID trvs4_e_costas_d seqrequuid UUID
KEY TravelRequestSequenceNumber trvs4_e_costas_d travelrequestsequencenumber Sequence Number
KEY CostAssignmentReferenceKey trvs4_e_costas_d costassignmentreferencekey Reference Key
KEY TravelCostAssignmentType trvs4_e_costas_d travelcostassignmenttype Cost Assignment Type

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 E_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 E_TrvlExpnCostAssignmentDraft AS
SELECT
  Persistence.personnelnumber AS PersonnelNumber,
  Persistence.traveltripnumber AS TravelTripNumber,
  Persistence.travelrequuid AS TravelReqUUID,
  Persistence.seqrequuid AS SeqReqUUID,
  Persistence.travelrequestsequencenumber AS TravelRequestSequenceNumber,
  Persistence.costassignmentreferencekey AS CostAssignmentReferenceKey,
  Persistence.travelcostassignmenttype AS TravelCostAssignmentType
FROM trvs4_e_costas_d AS Persistence
;