I_TranspOrdInvcgBlockSts

Transportation Order Invoicing Block Status | view: IINVCGBLOCKSTS | TRAN | Extraction: Not supported | Component: Analytics
Tables used: /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORBLK, /SCMTMS/D_TORSTP, ADCP, ADRC, BUT000, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SCMTMS/D_TCHRGI, /SCMTMS/D_TCHRGE, /SCMTMS/D_TCHRGR, /SCMB/HRP5561, T77S0
Column Name Description
TransportationOrderUUID Transportation Order UUID
SuplrFrtInvcReqUUID NodeID
TranspChargeItemUUID Transportation Charge Item UUID
TransportationChargesObjUUID Transportation Charge Object UUID
TranspChargeItemElementUUID Transportation Charge Item Element UUID
TransportationOrderBlockUUID Transportaton Order Block UUID
Column Name Description
Column Name Description
📏 Gross Weight Unit of Measure (TranspOrdGrossWeightUnit):
TranspOrdGrossWeight Transportation Order Gross Weight
📏 Gross Volume Unit of Measure (TranspOrdGrossVolumeUnit):
TranspOrdGrossVolume Transportation Order Gross Volume
📏 Quantity Unit of Measure (TranspOrdQuantityUnit):
TranspOrdQuantity Transportation Order Quantity
📏 Number of TEU Unit of Measure (TranspOrdNumberOfCtnsUnit):
TranspOrdNumberOfCtns Transportation Order Number Of Containers
Column Name Description
TranspOrdLfcycStsChgDte Transportation Order Lifecycle Status Change Date
Column Name Description
TransportationOrderCategory Business Document Category Show values
DangerousGoodsAreContained Dangerous Goods Show values
TranspOrdPlanningBlock Planning Block Show values
TranspOrdExecutionIsBlocked Execution Block Show values
InvoicingIsBlocked Freight Settlement Document Block Show values
InvoicingBlockCategory Invoicing Block Category Show values
CarrierBusPurposeIsCompleted Carrier Business Purpose is Completed Show values
CarrierOriginOfEntry Carrier Origin of Entry Show values
ShipperBusPurposeIsCompleted Shipper Business Purpose Is Completed Show values
ConsigneeBusPurposeIsCompleted Ship-To Party Business Purpose is Completed Show values
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
TranspOrdPlanningStatus Planning Status Show values
TransportationOrderExecSts Execution Status Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
TransportationModeCategory Transportation Mode Category Show values
Column Name Description Domain name
TransportationOrder Document /SCMTMS/TOR_ID
TranspOrdResponsiblePerson Person Responsible UNAME
Carrier Carrier /SCMTMS/BU_PARTNER
Shipper Shipper BU_PARTNER
ConsigneeUUID Business Partner GUID SYSUUID
Consignee Ship-to Party BU_PARTNER
TranspOrdShippingType Shipping Type /SCMTMS/SHIPPING_TYPE
PlngAndExecOrganization Planning and Execution Organization HROBJID
PlngAndExecOrgExternalID Transportation Execution Organization /SCMB/ORG_EXT_ID
PlngAndExecGroup Planning and Execution Group HROBJID
PlngAndExecGroupExternalID Transportation Execution Group /SCMB/ORG_EXT_ID
PurchasingOrgExternalID Transportation Purchasing Organization /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Transportation Purchasing Group /SCMB/ORG_EXT_ID
TranspOrdLfcycStsChgDteTime Created on Timestamp TZNTSTMPS
SourceLocationUUID Source Location Universally Unique Identifier (CHAR 22) /SAPAPO/LOCID
SourceLocation Transportation Order Source Location /SAPAPO/LOCNO
DestinationLocationUUID Destination Location UUID (CHAR 22) /SAPAPO/LOCID
DestinationLocation Transportation Order Destination Location /SAPAPO/LOCNO
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
TransportationMode Transportation Mode VKTRA
Master Data Relations Join Conditions
Carrier Authorization Group
  • ?
  • Carrier Authorization Group
  • Ship-to Party Authorization Group
  • Shipper Authorization Group
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_TRANSPORDINVCGBLOCKSTS.CARRIERAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.CONSIGNEEAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.SHIPPERAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == TB037.CLIENT
Ship-to Party Authorization Group
  • ?
  • Carrier Authorization Group
  • Ship-to Party Authorization Group
  • Shipper Authorization Group
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_TRANSPORDINVCGBLOCKSTS.CARRIERAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.CONSIGNEEAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.SHIPPERAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == TB037.CLIENT
Country key
  • Source Location Country/Region
  • Destination Location Country/Region
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == T005.MANDT
Region code
  • Source Location Country/Region
  • Destination Location Country/Region
  • Destination Location Region
  • Source Location Region
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TRANSPORDINVCGBLOCKSTS.SOURCELOCATIONREGION == T005S.BLAND
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == T005S.MANDT
Reason for Freight Settlement Document Block
  • Reason for Freight Settlement Document Block
  • Client
Purchasing Group
  • Purchasing Group
  • ?
  • ?
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.PURCHASINGGROUP == PLOGI.OBJID
  • I_TRANSPORDINVCGBLOCKSTS.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORDINVCGBLOCKSTS.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == PLOGI.MANDT
Purchasing Organization
  • Purchasing Organization
  • ?
  • ?
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.PURCHASINGORGANIZATION == PLOGI.OBJID
  • I_TRANSPORDINVCGBLOCKSTS.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORDINVCGBLOCKSTS.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == PLOGI.MANDT
Shipper Authorization Group
  • ?
  • Carrier Authorization Group
  • Ship-to Party Authorization Group
  • Shipper Authorization Group
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_TRANSPORDINVCGBLOCKSTS.CARRIERAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.CONSIGNEEAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.SHIPPERAUTHORIZATIONGROUP == TB037.AUGRP
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == TB037.CLIENT
Country key
  • Source Location Country/Region
  • Destination Location Country/Region
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == T005.MANDT
Region code
  • Source Location Country/Region
  • Destination Location Country/Region
  • Destination Location Region
  • Source Location Region
  • Client
  • I_TRANSPORDINVCGBLOCKSTS.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDINVCGBLOCKSTS.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TRANSPORDINVCGBLOCKSTS.SOURCELOCATIONREGION == T005S.BLAND
  • I_TRANSPORDINVCGBLOCKSTS.MANDT == T005S.MANDT
Business Document Type
  • Client
  • Business Document Type