C_FreightSettlementCostQ

Freight Settlement Cost Query | view: CFSDCOSTQUERY | 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, T005, T005T, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SAPAPO/LOCT, /SAPAPO/TRTYPE, /SAPAPO/TRTYPET, HRP1000, T77S0, T005S, T005U, /SCMTMS/C_SFIR_T, /SCMTMS/C_SFIRTT, /SCMTMS/C_RES_BS, /SCMTMS/C_RESBST, /SCMTMS/C_TCCAT, /SCMTMS/C_TCCATT, /SCMTMS/D_TCHRGI, /SCMTMS/D_TCHRGE, /SCMTMS/D_TCHRGR, /SCMTMS/C_TCCLS, /SCMTMS/C_TCCLST, /SCMTMS/C_TCET, /SCMTMS/C_TCETT, /SCMTMS/C_SHTYP, /SCMTMS/C_SHTYPT, /SCMB/HRP5561, T77S0, TVTR, TVTRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
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
TransportationOrderUUID Transportation Order UUID (Char 32)
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
📏 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
📏 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
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
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
SupplierFreightInvoiceRequest Freight Settlement Document /SCMTMS/SFIR_ID
SuplrFrtInvcReqTypeDesc Short Description /SCMTMS/DESCRIPTION_S
SuplrFrtInvcReqCategoryDesc Short Text for Fixed Values DDTEXT
PurchasingOrganizationName Object Name TEXT40
PurchasingGroupName Object Name TEXT40
SuplrFrtInvcReqLifeCycStsDesc Short Text for Fixed Values DDTEXT
SuplrFrtInvcReqConstcyStsDesc Short Text for Fixed Values DDTEXT
SuplrFrtInvcReqArchStatusDesc Short Text for Fixed Values DDTEXT
SuplrFrtInvcReqConfStatusDesc Short Text for Fixed Values DDTEXT
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
BillFromPartyName null
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierName Carrier Name TEXT81
InvoicingStatusDesc Short Text for Fixed Values DDTEXT
TranspChargeCalcStatusDesc Short Text for Fixed Values DDTEXT
CarrierInvoicingStatusDesc Short Text for Fixed Values DDTEXT
TranspChargeItmInvcgStatusDesc Short Text for Fixed Values DDTEXT
TranspChargeCalcLevelDesc Short Text for Fixed Values DDTEXT
TransportationOrder Document /SCMTMS/TOR_ID
TransportationOrderCatDesc Short Text for Fixed Values DDTEXT
TransportationOrderTypeDesc Transportation Order Type Description /SCMTMS/TOR_TYPE_DESC
Shipper Shipper BU_PARTNER
ShipperName Shipper Name TEXT81
Consignee Ship-to Party BU_PARTNER
ConsigneeName Ship-To Party Name TEXT81
TranspOrdShippingType Shipping Type /SCMTMS/SHIPPING_TYPE
TranspOrdShippingTypeDesc Description /SCMTMS/DESCRIPTION_S
TranspOrdTrafficDirectionDesc Short Text for Fixed Values DDTEXT
PlngAndExecOrganization Planning and Execution Organization HROBJID
PlngAndExecOrganizationName Object Name TEXT40
PlngAndExecGroup Planning and Execution Group HROBJID
PlngAndExecGroupName Object Name TEXT40
TranspOrdLifeCycleStatusDesc Short Text for Fixed Values DDTEXT
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
MeansOfTransportDesc Means of Transport Description /SAPAPO/TR_TRATYDESCR
TransportationMode Transportation Mode VKTRA
TransportationModeDesc Transportation Mode Description
TransportationModeCategoryDesc Transportation Mode Category Description DDTEXT
TranspOrdPlanningStatusDesc Short Text for Fixed Values DDTEXT
SourceLocationUUID Source Location Universally Unique Identifier (CHAR 22) /SAPAPO/LOCID
SourceLocationName Location Description /SAPAPO/LOC_CHAR40K
SourceLocation Transportation Order Source Location /SAPAPO/LOCNO
SourceLocationTypeDesc Short Text for Fixed Values DDTEXT
SourceLocationCountryName Country/Region Name TEXT50
SourceLocationRegionName Description TEXT20
DestinationLocationUUID Destination Location UUID (CHAR 22) /SAPAPO/LOCID
DestinationLocationName Location Description /SAPAPO/LOC_CHAR40K
DestinationLocation Transportation Order Destination Location /SAPAPO/LOCNO
DestinationLocationTypeDesc Short Text for Fixed Values DDTEXT
DestinationLocationCountryName Country/Region Name TEXT50
DestinationLocationRegionName Description TEXT20
TranspChargeCalcSheetLineNmbr Calculation Sheet Line Number /SCMTMS/TRCHARG_LINE_NO
TranspChargeInstrnTypeDesc Short Text for Fixed Values DDTEXT
TranspChargeTypeDesc Description /SCMTMS/DESCRIPTION_M
TranspChargeSubCategoryDesc Description /SCMTMS/DESCRIPTION_M
TranspChargeCategoryDesc Description /SCMTMS/DESCRIPTION_S
TranspChargeCalcReslnBase Calculation Resolution Base /SCMTMS/TRCHARG_CLCRES_BASTP
TranspChargeCalcReslnBaseDesc Description /SCMTMS/DESCRIPTION_UL
Master Data Relations Join Conditions
Country key
  • Source Location Country/Region
  • Destination Location Country/Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTQ.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.MANDT == T005.MANDT
Region code
  • Source Location Country/Region
  • Destination Location Country/Region
  • Source Location Region
  • Destination Location Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTQ.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.SOURCELOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTQ.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTQ.MANDT == T005S.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • ?
  • ?
  • C_FREIGHTSETTLEMENTCOSTQ.MANDT == PLOGI.MANDT
  • C_FREIGHTSETTLEMENTCOSTQ.PURCHASINGGROUP == PLOGI.OBJID
  • C_FREIGHTSETTLEMENTCOSTQ.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FREIGHTSETTLEMENTCOSTQ.[column in domain "OTYPE"] == PLOGI.OTYPE
Purchasing Organization
  • Client
  • Purchasing Organization
  • ?
  • ?
  • C_FREIGHTSETTLEMENTCOSTQ.MANDT == PLOGI.MANDT
  • C_FREIGHTSETTLEMENTCOSTQ.PURCHASINGORGANIZATION == PLOGI.OBJID
  • C_FREIGHTSETTLEMENTCOSTQ.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FREIGHTSETTLEMENTCOSTQ.[column in domain "OTYPE"] == PLOGI.OTYPE
Country key
  • Source Location Country/Region
  • Destination Location Country/Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTQ.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.MANDT == T005.MANDT
Region code
  • Source Location Country/Region
  • Destination Location Country/Region
  • Source Location Region
  • Destination Location Region
  • Client
  • C_FREIGHTSETTLEMENTCOSTQ.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FREIGHTSETTLEMENTCOSTQ.SOURCELOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTQ.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FREIGHTSETTLEMENTCOSTQ.MANDT == T005S.MANDT
Type
  • Type
  • Client
Charge Category
  • Charge Category
  • Client
Charge Subcategory
  • Charge Subcategory
  • Client
Charge Type
  • Client
  • Charge Type
Business Document Type
  • Client
  • Business Document Type