P_CDS_EDM_TESTVIEW

Private View for EDM conversion AUnits | view: PCDSEDMTESTV | TRAN | Extraction: Not supported | Component: Situation handling across applications, generic
Tables used: SFLIGHT
Column Name Description
carrid FK Airline Code
connid FK Flight Connection Number
fldate Flight date
Column Name Description
cur_EdmDecimal Airfare
Column Name Description
Column Name Description
fldate Flight date
Column Name Description
int_EdmInt32 Maximum Capacity in Business Class Show values
Column Name Description Domain name
edmString null
x16_carrid_edm_UUID null
c16_NO_EdmGuid Field of length 16 CHAR16
c22_EdmGuid Text string 22 characters CHAR22
c26_edm_EdmGuid Character field length 26 CHAR26
c32_EdmGuid Character field, length 32 CHAR32
c36_EdmGuid null
c22_EdmGuid_2 16 Byte UUID in 22 Characters (Usually Base64 Encoded) SYSUUID_C22
c26_EdmGuid_2 16 byte UUID in 26 chars (usually Base 32 encoded) SYSUUID_C26
c32_EdmGuid_2 16-byte UID in 32 chars (hexadecimal) SYSUUID_C32
c36_EdmGuid_2 16 byte UUID in 36 chars according to RFC4122 SYSUUID_C36
c1_edmBoolean Single-Character Flag CHAR1
c14_EdmDateTimeOffset Text field length 14 CHAR14
Master Data Relations Join Conditions
Generic foreign key
  • Airline Code
  • ?
  • P_CDS_EDM_TESTVIEW.CARRID == SCARR.CARRID
  • P_CDS_EDM_TESTVIEW.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Plan
  • Airline Code
  • Flight Connection Number
  • ?
  • P_CDS_EDM_TESTVIEW.CARRID == SPFLI.CARRID
  • P_CDS_EDM_TESTVIEW.CONNID == SPFLI.CONNID
  • P_CDS_EDM_TESTVIEW.[column in domain "S_MANDT"] == SPFLI.MANDT