C_FrtOrdGenDataBasicFacts

Freight Order: General Data | view: CTORFOGEN | TRAN | Extraction: Not supported | Component: Freight Order Management
Tables used: /SCMTMS/D_TOREXE, /SCMTMS/D_FAGROT, /SCMTMS/D_TORROT, /SCMTMS/D_TORITE, /SCMTMS/D_TORSUM, /SCMTMS/D_TORSTP, MARA, ADCP, ADRC, BUT000, /SCMTMS/C_BTDTY, /SCMTMS/C_BTDTYT, T001, TKA02, TCURV, TCURW, /SCMTMS/D_TCDROT, TINC, TINCT, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SAPAPO/LOCT, TMFG, TMFGT, HRP1000, T77S0, SOTR_TEXT, TVZBT, MAKT, /SCMTMS/D_CHXRAT, /SCMTMS/D_TCHRGI, /SCMTMS/D_TCHRGR, /SCMTMS/C_DIMWP, /SCMTMS/C_DIMWPT, /SCMB/HRP5561, TTGR, TTGRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
Column Name Description
TransportationOrderUUID Transportation Order UUID
Column Name Description
💲 Document Currency (TranspChargeDocumentCurrency):
TranspChrgTotalAmtInDocCrcy null
💲 Goods Value Currency (TranspOrdGoodsValueCrcy):
TranspOrdGoodsValueAmount null
Column Name Description
📏 Gross Weight Unit of Measure (TranspOrdGrossWeightUnit):
TranspOrdGrossWeight Quantity
📏 Gross Volume Unit of Measure (TranspOrdGrossVolumeUnit):
TranspOrdGrossVolume Quantity
📏 Quantity Unit of Measure (TranspOrdQuantityUnit):
TranspOrdQuantity Quantity
📏 Display Length Unit (DisplayLengthUnit):
TranspOrdDistanceInDspUnit Quantity
Column Name Description
TranspOrdDepartureDate null
TranspOrdDepartureTime null
TranspOrdArrivalDate null
TranspOrdArrivalTime null
TranspOrdOrderDate null
TranspOrdOrderTime null
Column Name Description
TransportationOrderCategory Business Document Category Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
TranspOrdPlanningStatus Planning Status Show values
TransportationOrderExecSts Execution Status Show values
TranspOrderDngrsGdsSts Dangerous Goods Status Show values
TranspChargeCalcStatus Charge Calculation Status Show values
FrtCostDistrStatus Cost Distribution Status Show values
Column Name Description Domain name
FreightOrder Document /SCMTMS/TOR_ID
TransportationOrderTypeDesc Transportation Order Type Description /SCMTMS/TOR_TYPE_DESC
TranspOrdPartnerReference Partner Reference Number CHAR35
PurchasingOrgExternalID Organizational Unit: External ID /SCMB/ORG_EXT_ID
PurchasingOrganizationName Object Name TEXT40
PurchasingGroupExternalID Organizational Unit: External ID /SCMB/ORG_EXT_ID
PurchasingGroupName Object Name TEXT40
PlngAndExecOrganization Organizational Unit: External ID /SCMB/ORG_EXT_ID
PlngAndExecGroup Organizational Unit: External ID /SCMB/ORG_EXT_ID
PurgOrgCompanyCode Company Code Procuring the Transportation Service BUKRS
PurgOrgCompanyCodeName Name of Company Code or Company TEXT25
TranspOrdResponsiblePerson Person Responsible UNAME
TransportationMode Transportation Mode VKTRA
TranspOrdMaxUtilznRatio Maximum Utilization
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierName null
StandardCarrierAlphaCode Standard Carrier Alpha Code /SCMTMS/SCACD
Shipper Shipper BU_PARTNER
Consignee Ship-to Party BU_PARTNER
TranspOrdLifeCycleStatusDesc Short Text for Fixed Values DDTEXT
TranspOrdPlanningStatusDesc Short Text for Fixed Values DDTEXT
TransportationOrderExecStsDesc Short Text for Fixed Values DDTEXT
TranspOrderDngrsGdsStsDesc Short Text for Fixed Values DDTEXT
SourceLocation Location
SourceLocationLabel null
TranspOrdDepartureDateTime Created on Timestamp TZNTSTMPS
DestinationLocation Location
DestinationLocationLabel null
TranspOrdArrivalDateTime Created on Timestamp TZNTSTMPS
TranspOrdOrderDateTime Created on Timestamp TZNTSTMPS
TranspOrdDelivCrtnPrgrsRatio null
TranspOrdDelivCrtnPrgrsPct null
TransportationChargesObjUUID Transportation Charge Object UUID /BOBF/CONF_KEY
TranspChargeCalcStsCriticality null
TransportationAgreementUUID Internal Universally Unique Identifier
TransportationAgreement Agreement /SCMTMS/FAG_ID
FrtCostDistrRootUUID NodeID /BOBF/CONF_KEY
Master Data Relations Join Conditions
Purchasing Group
  • Purchasing Group
  • Client
  • ?
  • ?
  • C_FRTORDGENDATABASICFACTS.PURCHASINGGROUP == PLOGI.OBJID
  • C_FRTORDGENDATABASICFACTS.MANDT == PLOGI.MANDT
  • C_FRTORDGENDATABASICFACTS.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTORDGENDATABASICFACTS.[column in domain "OTYPE"] == PLOGI.OTYPE
Purchasing Organization
  • Client
  • Purchasing Organization
  • ?
  • ?
  • C_FRTORDGENDATABASICFACTS.MANDT == PLOGI.MANDT
  • C_FRTORDGENDATABASICFACTS.PURCHASINGORGANIZATION == PLOGI.OBJID
  • C_FRTORDGENDATABASICFACTS.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTORDGENDATABASICFACTS.[column in domain "OTYPE"] == PLOGI.OTYPE
Goods Value Currency
  • Client
  • Goods Value Currency
  • C_FRTORDGENDATABASICFACTS.MANDT == TCURC.MANDT
  • C_FRTORDGENDATABASICFACTS.TRANSPORDGOODSVALUECRCY == TCURC.WAERS
Business Document Type
  • Business Document Type
  • Client