I_RO_ElectronicDocTransptRegn

DDL: I_RO_ELECTRONICDOCTRANSPTREGN Type: view_entity BASIC Package: GLO-EDO-RO
43 Fields 2 Data Sources

eDocument Romania Transport Registration

I_RO_ElectronicDocTransptRegn is a Basic CDS View that provides data about "eDocument Romania Transport Registration" in SAP S/4HANA. It reads from 2 data sources (I_ElectronicDoc, R_RO_ElectronicDocTransptRegn) and exposes 43 fields with key field RO_ElectronicDocTranspRegnUUID. Part of development package GLO-EDO-RO.

Data Sources (2)

SourceAliasJoin Type
I_ElectronicDoc EDoc inner
R_RO_ElectronicDocTransptRegn ROTrreg from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label eDocument Romania Transport Registration view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY RO_ElectronicDocTranspRegnUUID R_RO_ElectronicDocTransptRegn RO_ElectronicDocTranspRegnUUID eDocument GUID
RO_ElectronicDocSenderTaxId R_RO_ElectronicDocTransptRegn RO_ElectronicDocSenderTaxId CIF Number
RO_EDocTranspRegnIndexID R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnIndexID Index ID
RO_EDocTranspRegnUniqueID R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnUniqueID UIT
RO_EDocTranspRegnModifDateTime R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnModifDateTime
RO_EDocTranspRegnVehRegnNumber R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnVehRegnNumber Vehicle Reg Num
RO_EDocTranspRegnTrailerRegn1 R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnTrailerRegn1 Tow Registration 1
RO_EDocTranspRegnTrailerRegn2 R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnTrailerRegn2 Tow Registration 2
RO_EDocTranspRegnRemarksDesc R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnRemarksDesc Remarks
RO_EDocTranspRegnCarrCtry R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnCarrCtry Carrier Country
RO_EDocTranspRegnCarrCode R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnCarrCode Carrier Code
RO_EDocTranspRegnCarrName R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnCarrName Carrier Name
RO_EDocTranspRegnRespDate R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnRespDate
RO_EDocTranspRegnConfCode R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnConfCode Confirmation Code
RO_EDocTranspRegnConfDetText R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnConfDetText Confirmation Detail
RO_EDocTranspRegnTranspDate R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnTranspDate Transportation Date
RO_EDocTranspRegnTraceID R_RO_ElectronicDocTransptRegn RO_EDocTranspRegnTraceID Trace ID
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Value
ElectronicDocCountry I_ElectronicDoc ElectronicDocCountry CtryReg ISO Cd
ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType SRVC Source Type
ElectronicDocSourceKey I_ElectronicDoc ElectronicDocSourceKey Source System Key
ElectronicDocType I_ElectronicDoc ElectronicDocType eDoc Type
ElectronicDocProcessStatus I_ElectronicDoc ElectronicDocProcessStatus Work Item ID
ElectronicDocLastChangedByUser I_ElectronicDoc ElectronicDocLastChangedByUser User Name
ElectronicDocLastChangeDate I_ElectronicDoc ElectronicDocLastChangeDate Time Stamp
ElectronicDocLastChangeTime I_ElectronicDoc ElectronicDocLastChangeTime Time Stamp
ElectronicDocCreatedByUser I_ElectronicDoc ElectronicDocCreatedByUser Version Created By
ElectronicDocCreationDate I_ElectronicDoc ElectronicDocCreationDate Time Stamp
ElectronicDocCreationTime I_ElectronicDoc ElectronicDocCreationTime Time
ElectronicDocSrceCreatedByUser I_ElectronicDoc ElectronicDocSrceCreatedByUser Source Crted By
ElectronicDocProcess I_ElectronicDoc ElectronicDocProcess Trans.
ElectronicDocLastProcStep I_ElectronicDoc ElectronicDocLastProcStep Last ProcStep
ElectronicDocLastProcStepVar I_ElectronicDoc ElectronicDocLastProcStepVar Last Variant
ElectronicDocProcessVersion I_ElectronicDoc ElectronicDocProcessVersion Process Version
ElectronicDocStatus I_ElectronicDoc ElectronicDocStatus Workflow Status
ElectronicDocPostingDate I_ElectronicDoc ElectronicDocPostingDate Posting Date
ElectronicDocReferenceProcess I_ElectronicDoc ElectronicDocReferenceProcess Reference Proc.
ElectronicDocInterfaceType I_ElectronicDoc ElectronicDocInterfaceType Plug-In Interface Tp
ElectronicDocInterfaceUUID I_ElectronicDoc ElectronicDocInterfaceUUID Interface GUID
ElectronicDocFileUUID I_ElectronicDoc ElectronicDocFileUUID File GUID
ElectronicDocInterfaceID I_ElectronicDoc ElectronicDocInterfaceID Interface ID
ElectronicDocInterfaceVersion I_ElectronicDoc ElectronicDocInterfaceVersion Version
ElectronicDocMetaStatus I_ElectronicDoc ElectronicDocMetaStatus Status

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_RO_ElectronicDocTransptRegn.
-- 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_RO_ElectronicDocTransptRegn AS
SELECT
  ROTrreg.RO_ElectronicDocTranspRegnUUID AS RO_ElectronicDocTranspRegnUUID,
  ROTrreg.RO_ElectronicDocSenderTaxId AS RO_ElectronicDocSenderTaxId,
  ROTrreg.RO_EDocTranspRegnIndexID AS RO_EDocTranspRegnIndexID,
  ROTrreg.RO_EDocTranspRegnUniqueID AS RO_EDocTranspRegnUniqueID,
  ROTrreg.RO_EDocTranspRegnModifDateTime AS RO_EDocTranspRegnModifDateTime,
  ROTrreg.RO_EDocTranspRegnVehRegnNumber AS RO_EDocTranspRegnVehRegnNumber,
  ROTrreg.RO_EDocTranspRegnTrailerRegn1 AS RO_EDocTranspRegnTrailerRegn1,
  ROTrreg.RO_EDocTranspRegnTrailerRegn2 AS RO_EDocTranspRegnTrailerRegn2,
  ROTrreg.RO_EDocTranspRegnRemarksDesc AS RO_EDocTranspRegnRemarksDesc,
  ROTrreg.RO_EDocTranspRegnCarrCtry AS RO_EDocTranspRegnCarrCtry,
  ROTrreg.RO_EDocTranspRegnCarrCode AS RO_EDocTranspRegnCarrCode,
  ROTrreg.RO_EDocTranspRegnCarrName AS RO_EDocTranspRegnCarrName,
  ROTrreg.RO_EDocTranspRegnRespDate AS RO_EDocTranspRegnRespDate,
  ROTrreg.RO_EDocTranspRegnConfCode AS RO_EDocTranspRegnConfCode,
  ROTrreg.RO_EDocTranspRegnConfDetText AS RO_EDocTranspRegnConfDetText,
  ROTrreg.RO_EDocTranspRegnTranspDate AS RO_EDocTranspRegnTranspDate,
  ROTrreg.RO_EDocTranspRegnTraceID AS RO_EDocTranspRegnTraceID,
  EDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  EDoc.ElectronicDocCountry AS ElectronicDocCountry,
  EDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  EDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  EDoc.ElectronicDocType AS ElectronicDocType,
  EDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  EDoc.ElectronicDocLastChangedByUser AS ElectronicDocLastChangedByUser,
  EDoc.ElectronicDocLastChangeDate AS ElectronicDocLastChangeDate,
  EDoc.ElectronicDocLastChangeTime AS ElectronicDocLastChangeTime,
  EDoc.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  EDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  EDoc.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  EDoc.ElectronicDocSrceCreatedByUser AS ElectronicDocSrceCreatedByUser,
  EDoc.ElectronicDocProcess AS ElectronicDocProcess,
  EDoc.ElectronicDocLastProcStep AS ElectronicDocLastProcStep,
  EDoc.ElectronicDocLastProcStepVar AS ElectronicDocLastProcStepVar,
  EDoc.ElectronicDocProcessVersion AS ElectronicDocProcessVersion,
  EDoc.ElectronicDocStatus AS ElectronicDocStatus,
  EDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  EDoc.ElectronicDocReferenceProcess AS ElectronicDocReferenceProcess,
  EDoc.ElectronicDocInterfaceType AS ElectronicDocInterfaceType,
  EDoc.ElectronicDocInterfaceUUID AS ElectronicDocInterfaceUUID,
  EDoc.ElectronicDocFileUUID AS ElectronicDocFileUUID,
  EDoc.ElectronicDocInterfaceID AS ElectronicDocInterfaceID,
  EDoc.ElectronicDocInterfaceVersion AS ElectronicDocInterfaceVersion,
  EDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus
FROM R_RO_ElectronicDocTransptRegn AS ROTrreg
INNER JOIN I_ElectronicDoc AS EDoc ON /* join condition not captured in parsed metadata */
;

Learn More