E_TrvlReqCostAssignmentDraft

DDL: E_TRVLREQCOSTASSIGNMENTDRAFT Type: view_entity EXTENSION

Trvl Req Cost Assgmt - Extn

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

Data Sources (1)

SourceAliasJoin Type
trvs4_costass_d Persistence from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Trvl Req 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 350 view
AbapCatalog.extensibility.quota.maximumBytes 2240 view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber trvs4_costass_d personnelnumber Personnel No.
KEY TravelTripNumber trvs4_costass_d traveltripnumber Trip Number
KEY TravelReqUUID trvs4_costass_d travelrequuid UUID
KEY SeqReqUUID trvs4_costass_d seqrequuid UUID
KEY TravelRequestSequenceNumber trvs4_costass_d travelrequestsequencenumber Sequence Number
KEY CostAssignmentReferenceKey trvs4_costass_d costassignmentreferencekey Reference Key
KEY TravelCostAssignmentType trvs4_costass_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_TrvlReqCostAssignmentDraft.
-- 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_TrvlReqCostAssignmentDraft 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_costass_d AS Persistence
;