C_FreightSettlementCostC

Freight Settlement Cost Cube | view: CFSDCOSTCUBE | TRAN | Extraction: Not supported | Component: Analytics
Tables used: SCAL_TT_DATE, /SCMTMS/D_SF_ROT, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORSTS, /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
SuplrFrtInvcReqUUID Freight Settlement Document UUID (Char 32)
TransportationChargesObjUUID Transportation Charge Object UUID
TranspChargeItemUUID Transportation Charge Item UUID
TranspChargeItemElementUUID Transportation Charge Item Element UUID
Column Name Description
💲 Display Currency (DisplayCurrency):
CreditAmountInDisplayCurrency Credit Amount in Display Currency (Maximum Length)
InvoicedAmountInDspCurrency Invoiced Amount In Display Currency (Maximum Length)
CostAmountInDisplayCurrency Cost Amount in Display Currency (Maximum Length)
Column Name Description
📏 Display Weight Unit of Measure (DisplayWeightUnit):
TranspOrdGrossWeightInDspUnit Transportation Order Gross Weight In Display Unit
TranspOrdNetWeightInDspUnit Transportation Order Net Weight In Display Unit
TranspOrdTareWeightInDspUnit Transportation Order Tare Weight In Display Unit
📏 Display Volume Unit of Measure (DisplayVolumeUnit):
TranspOrdGrossVolumeInDspUnit Transportation Order Gross Volume in Display Unit
📏 Display Quantity Unit of Measure (DisplayQuantityUnit):
TranspOrdQuantityInDisplayUnit Transportation Order Quantity In Display Unit
TranspOrdAltvQtyInDspUnit Transportation Order Alternative Quantity In Display Unit
TranspOrdBaseQtyInDspUnit Transportation Order Base Quantity In Display Unit
📏 Display Number of Container Unit of Measure (DisplayNmbrOfCtnsUnit):
TranspOrdNumberOfCtnsInDspUnit Transportation Order Number of Containers In Display Unit
📏 Display Length Unit (DisplayLengthUnit):
TranspOrdDistanceInDspUnit Transportation Order Stage Distance In Display Unit
📏 Display Time Unit of Measure (DisplayTimeUnit):
TranspOrdNetDurationInDspUnit Transportation Order Net Duration in Display Unit
Column Name Description
InvoiceDate Posting Date
Column Name Description
SuplrFrtInvcReqCategory Freight Settlement Document Category Show values
SuplrFrtInvcReqLifeCycSts Life Cycle Status of Freight Settlement Document Show values
SuplrFrtInvcReqConstcySts Consistency Status Show values
SuplrFrtInvcReqArchStatus Archiving Status Show values
SuplrFrtInvcReqConfStatus Confirmation Status Show values
BillFromPtyBusPrpsIsCompleted Bill-From Party Business Purpose is Completed Show values
CarrierBusPurposeIsCompleted Carrier Business Purpose is Completed Show values
InvoicingStatus Transportation Charge Invoicing Status Show values
TranspChargeCalcStatus Charge Calculation Status Show values
CarrierInvoicingStatus Carrier Invoicing Status Show values
TranspChargeItmInvcgStatus Transportation Charge Item Invoicing Status Show values
TranspChargeCalcLevel Calculation Level Show values
TransportationOrderCategory Business Document Category 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
TransportationModeCategory Transportation Mode Category Show values
TranspOrdPlanningStatus Planning Status Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
TranspChargeInstrnType Instruction Type Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID (Char 32) /SCMTMS/VDM_TOR_DB_KEY_HEX
SupplierFreightInvoiceRequest Freight Settlement Document /SCMTMS/SFIR_ID
PurchasingOrgExternalID Transportation Purchasing Organization /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Transportation Purchasing Group /SCMB/ORG_EXT_ID
InvoiceDateYearWeek Invoice Year Week NUM6
InvoiceDateYearMonth Invoice Year Month NUM6
InvoiceDateYearQuarter Invoice Year Quarter NUM5
InvoiceDateYear Invoice Year NUM4
BillFromParty Invoicing Party /SCMTMS/SFIR_INV_BILLFROMPARTY
Carrier Carrier /SCMTMS/BU_PARTNER
RefTransportationOrderNodeUUID Transportation Order UUID /SCMTMS/VDM_TOR_DB_KEY
TransportationOrder Document /SCMTMS/TOR_ID
TranspOrdResponsiblePerson Person Responsible UNAME
Shipper Shipper BU_PARTNER
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
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
TransportationMode Transportation Mode VKTRA
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
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
TranspChargeCalcSheetLineNmbr Calculation Sheet Line Number /SCMTMS/TRCHARG_LINE_NO
TranspChargeCalcReslnBase Calculation Resolution Base /SCMTMS/TRCHARG_CLCRES_BASTP
TranspChargeItmElmntCalcDteTme Calculation Date Timestamp TZNTSTMPS
Master Data Relations Join Conditions
Bill-From Party Authorization Group
  • ?
  • Shipper Authorization Group
  • Carrier Authorization Group
  • Ship-to Party Authorization Group
  • Bill-From Party Authorization Group
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_FREIGHTSETTLEMENTCOSTC.SHIPPERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CARRIERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CONSIGNEEAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.BILLFROMPTYAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == TB037.CLIENT
Carrier Authorization Group
  • ?
  • Shipper Authorization Group
  • Carrier Authorization Group
  • Ship-to Party Authorization Group
  • Bill-From Party Authorization Group
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_FREIGHTSETTLEMENTCOSTC.SHIPPERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CARRIERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CONSIGNEEAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.BILLFROMPTYAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == TB037.CLIENT
Ship-to Party Authorization Group
  • ?
  • Shipper Authorization Group
  • Carrier Authorization Group
  • Ship-to Party Authorization Group
  • Bill-From Party Authorization Group
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_FREIGHTSETTLEMENTCOSTC.SHIPPERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CARRIERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CONSIGNEEAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.BILLFROMPTYAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == TB037.CLIENT
Country key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == T005.MANDT
Region code
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Source Location Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTC.SOURCELOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == T005S.MANDT
Purchasing Group
  • ?
  • ?
  • Client
  • Purchasing Group
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == PLOGI.MANDT
  • C_FREIGHTSETTLEMENTCOSTC.PURCHASINGGROUP == PLOGI.OBJID
Purchasing Organization
  • ?
  • ?
  • Client
  • Purchasing Organization
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == PLOGI.MANDT
  • C_FREIGHTSETTLEMENTCOSTC.PURCHASINGORGANIZATION == PLOGI.OBJID
Shipper Authorization Group
  • ?
  • Shipper Authorization Group
  • Carrier Authorization Group
  • Ship-to Party Authorization Group
  • Bill-From Party Authorization Group
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_FREIGHTSETTLEMENTCOSTC.SHIPPERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CARRIERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.CONSIGNEEAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.BILLFROMPTYAUTHORIZATIONGROUP == TB037.AUGRP
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == TB037.CLIENT
Country key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == T005.MANDT
Region code
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Source Location Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTC.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTC.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTC.SOURCELOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTC.MANDT == T005S.MANDT
Type
  • Client
  • Type
Charge Category
  • Charge Category
  • Client
Charge Subcategory
  • Charge Subcategory
  • Client
Charge Type
  • Charge Type
  • Client
Business Document Type
  • Business Document Type
  • Client