C_TenderingQuery

Tendering Query | view: CTENDERINGQUERY | Extraction: Not supported | Component: Analytics
Tables used: SCAL_TT_DATE, /SCMTMS/D_TORTEN, /SCMTMS/D_TORTRQ, /SCMTMS/D_TORTRE, /SCMTMS/D_TORTST, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORSTP, ADCP, ADRC, BUT000, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SAPAPO/LOCT, /SAPAPO/TRTYPE, /SAPAPO/TRTYPET, HRP1000, T77S0, /SCMTMS/C_REJRN, /SCMTMS/C_REJRNT, /SCMB/HRP5561, TVTR, TVTRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
Column Name Description
TransportationOrder Document
TenderingSequenceNumber Tendering Sequence Number
TenderingStepSequenceNumber Tendering Step Sequence Number
TenderingRequestSequenceNumber Tendering Request Sequence Number
TenderingResponseSqncNumber Tendering Response Sequence Number
Column Name Description
💲 Display Currency (DisplayCurrency):
TndrgStepAbsltPrcLmtInDspCrcy Tendering Step Absolute Price Limit in Display Currency
TndrgReqAbsltPrcLmtInDspCrcy Tendering Request Absolute Price Limit in Display Currency
TndrgRspSubmdAmtInDspCrcy Tendering Response Submitted Amount in Display Currency
Column Name Description
📏 Display Number of Container Unit of Measure (DisplayNmbrOfCtnsUnit):
TranspOrdGrossWeightInDspUnit Transportation Order Gross Weight In Display Unit
TranspOrdGrossVolumeInDspUnit Transportation Order Gross Volume in Display Unit
TranspOrdQuantityInDisplayUnit Transportation Order Quantity In Display Unit
TranspOrdNumberOfCtnsInDspUnit Transportation Order Number of Containers In Display Unit
MaxResponseDurationInDspUnit Tendering Maximum Response Duration In Display Unit
RmngOpenTndrgReqTimeInDspUnit Remaining Open Tendering Request Duration in Display Unit
TenderingCycleTimeInDspUnit Tendering Cycle Time In Display Unit
TenderingAvgCycleTimeInDspUnit Tendering Average Cycle Time in Display Unit
Column Name Description
TenderingStartDate Tendering Start Date
TenderingResponseDate Tendering Response Date
Column Name Description
TransportationOrderExecSts Execution Status Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
CarrierOriginOfEntry Carrier Origin of Entry Show values
TransportationOrderCategory Business Document Category Show values
TransportationModeCategory Transportation Mode Category Show values
TenderingLifeCycleStatus Tendering Life Cycle Status Show values
TenderingProcessResult Tendering Process Result Show values
TenderingType Tendering Type Show values
TrAlcAndBusShrIsUpdtdByRFQ RFQ Updates Allocations and Business Shares Show values
TndrgStepLifeCycleStatus Tendering Step Life Cycle Status Show values
CarrierAssignmentMethod Tendering Carrier Assignment Method Show values
TenderingProcessMode Tendering Process Mode Show values
TndrgReqLifeCycleStatus Tendering Request Life Cycle Status Show values
TenderingAwardStatus Tendering Award Status Show values
TenderingResponseCode Tendering Response Code Show values
TndrgQuotationEvalResult Tendering Quotation Evaluation Result Show values
IsProposedFreightQuotation Tendering Is Proposed Freight Quotation Show values
QuotationReviewIsRequired Quotation Review is Required Show values
FreightQuotationStatus Freight Quotation Status Show values
TenderingRequestIsOpen Tendering Request Is Open Show values
TenderingRequestIsOverdue Tendering Request Is Overdue Show values
TndrgCarrierIsDiscrepant Tendering Carrier is Discrepant Show values
TenderingIsSuccessful Tendering Is Successful Show values
CarrierIsFromTendering Carrier is from Tendering Show values
FrtOrdHasCompletedTndrg Freight Order with Completed Tendering Show values
TenderingRequestIsCompleted Tendering Request is Completed Show values
TndrgResponseIsPositive Tendering Response Is Positive Show values
TndrgResponseIsNegative Negative Tendering Response Show values
TenderingHasCompletedCycle Tendering has Completed Cycle Show values
PeerToPeerTndrgIsSuccssfl Peer To Peer Tendering Is Successful Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID (Char 32) /SCMTMS/VDM_TOR_DB_KEY_HEX
TenderingStartDateTime Tendering Start Date and Time TZNTSTMPS
TenderingStartDateYear Tendering Start Date Year NUMC4
TenderingStartDateYearWeek Tendering Start Date Year Week NUMC6
TenderingStartDateYearMonth Tendering Start Date Year Month NUMC6
TenderingStartDateYearQuarter Tendering Start Date Year Quarter NUMC5
TransportationOrderTypeDesc Transportation Order Type Description /SCMTMS/TOR_TYPE_DESC
ChangedDateTime Created on Timestamp TZNTSTMPS
TransportationOrderExecStsDesc Short Text for Fixed Values DDTEXT
TranspOrdLifeCycleStatusDesc Short Text for Fixed Values DDTEXT
CarrierOriginOfEntryDesc Short Text for Fixed Values DDTEXT
PurchasingOrganizationName Object Name TEXT40
PurchasingGroupName Object Name TEXT40
PlngAndExecOrganization Planning and Execution Organization HROBJID
PlngAndExecOrganizationName Object Name TEXT40
PlngAndExecGroup Planning and Execution Group HROBJID
PlngAndExecGroupName Object Name TEXT40
TransportationOrderCatDesc Short Text for Fixed Values DDTEXT
TransportationMode Transportation Mode VKTRA
TransportationModeDesc Transportation Mode Description
TransportationModeCategoryDesc Transportation Mode Category Description DDTEXT
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
MeansOfTransportDesc Means of Transport Description /SAPAPO/TR_TRATYDESCR
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierName null
SourceLocationUUID Source Location Universally Unique Identifier (CHAR 22) /SAPAPO/LOCID
SourceLocationName Location Description /SAPAPO/LOC_CHAR40K
SourceLocation Transportation Order Source Location /SAPAPO/LOCNO
DestinationLocationUUID Destination Location UUID (CHAR 22) /SAPAPO/LOCID
DestinationLocationName Location Description /SAPAPO/LOC_CHAR40K
DestinationLocation Transportation Order Destination Location /SAPAPO/LOCNO
TenderingCreationUser Tendering Created By User XUBNAME
TenderingChangeUser Tendering Changed By User XUBNAME
TenderingLifeCycleStatusDesc Short Text for Fixed Values DDTEXT
TenderingProcessResultDesc Short Text for Fixed Values DDTEXT
TenderingTypeDesc Short Text for Fixed Values DDTEXT
TrAlcAndBusShrIsUpdtdByRFQDesc Short Text for Fixed Values DDTEXT
TndrgStepLifeCycleStatusDesc Short Text for Fixed Values DDTEXT
CarrierAssignmentMethodDesc Short Text for Fixed Values DDTEXT
TenderingProcessModeDesc Short Text for Fixed Values DDTEXT
AvgRelativePriceLimitInPercent Average Relative Price Limit In Percent /SCMTMS/VDM_RATIO
TndrgReqLifeCycleStatusDesc Short Text for Fixed Values DDTEXT
TenderingRequestedCarrier Tendering Requested Carrier BU_PARTNER
TenderingRequestedCarrierName null
FreightQuotationDueDateTime Tendering Response Due Date and Time TZNTSTMPS
TenderingRejectionReason Tendering Rejection Reason /SCMTMS/REJ_REASON_CODE
TenderingRejectionReasonDesc Tendering Response Rejection Reason (Description) /SCMTMS/REJ_REASON_CODE_D
TenderingAwardStatusDesc Short Text for Fixed Values DDTEXT
TenderingResponseCodeDesc Short Text for Fixed Values DDTEXT
TndrgQuotationEvalResultDesc Short Text for Fixed Values DDTEXT
TenderingSelectedCarrier Tendering Selected Carrier BU_PARTNER
TenderingSelectedCarrierName null
IsProposedFreightQuotationDesc Short Text for Fixed Values DDTEXT
QuotationReviewIsRequiredDesc Short Text for Fixed Values DDTEXT
FreightQuotationStatusDesc Short Text for Fixed Values DDTEXT
NumberOfTransportationOrders Number of Transportation Orders /SCMTMS/VDM_NUMBER_OF
NumberOfTenderings Number of Tenderings /SCMTMS/VDM_NUMBER_OF
NumberOfTenderingSteps Number of Tendering Steps /SCMTMS/VDM_NUMBER_OF
NumberOfTenderingRequests Number of Tendering Requests /SCMTMS/VDM_NUMBER_OF
NumberOfTenderingResponses Number of Tendering Responses /SCMTMS/VDM_NUMBER_OF
TenderingRequestIsOpenDesc Short Text for Fixed Values DDTEXT
TenderingRequestIsOverdueDesc Short Text for Fixed Values DDTEXT
NumberOfOpenTndrgRequests Number of Open Tendering Requests /SCMTMS/VDM_NUMBER_OF
NumberOfOverdueTndrgRequests Number of Overdue Tendering Requests /SCMTMS/VDM_NUMBER_OF
TndrgCarrierIsDiscrepantDesc Short Text for Fixed Values DDTEXT
NumberOfDiscrepantCarrierSel Number Of Discrepant Carrier Selection /SCMTMS/VDM_NUMBER_OF
TenderingIsSuccessfulDesc Short Text for Fixed Values DDTEXT
NumberOfSuccessfulTenderings Number of Successful Tenderings /SCMTMS/VDM_NUMBER_OF
CarrierIsFromTenderingDesc Short Text for Fixed Values DDTEXT
NumberOfCarriersFromTendering Number of Carriers from Tendering /SCMTMS/VDM_NUMBER_OF
FrtOrdHasCompletedTndrgDesc Short Text for Fixed Values DDTEXT
NumberOfFrtOrdsWithCmpltdTndrg Number of Freight Orders with Completed Tendering /SCMTMS/VDM_NUMBER_OF
TenderingSuccessRatio Tendering Success Ratio in Percent /SCMTMS/VDM_RATIO
FrtOrdsWithTenderingRatio Freight Orders With Tendering Ratio /SCMTMS/VDM_RATIO
CarrierFromTenderingRatio Carrier from Tendering Ratio (%) /SCMTMS/VDM_RATIO
TenderingRequestIsCmpltdDesc Short Text for Fixed Values DDTEXT
NumberOfCompletedTndrgRequests Number of Completed Tendering Requests /SCMTMS/VDM_NUMBER_OF
TndrgResponseIsPositiveDesc Short Text for Fixed Values DDTEXT
NumberOfPositiveTndrgResponses Number of Positive Tendering Responses /SCMTMS/VDM_NUMBER_OF
TndrgResponseIsNegativeDesc Short Text for Fixed Values DDTEXT
NumberOfNegativeTndrgResponses Number of Negative Tendering Responses /SCMTMS/VDM_NUMBER_OF
PositiveTenderingResponseRatio Positive Tendering Response Ratio (%) /SCMTMS/VDM_RATIO
NegativeTenderingResponseRatio Negative Tendering Response Ratio (%) /SCMTMS/VDM_RATIO
TenderingHasCompletedCycleDesc Short Text for Fixed Values DDTEXT
NumberOfCmpltdTenderingCycles Number of Completed Tendering Cycles /SCMTMS/VDM_NUMBER_OF
PeerToPeerTndrgIsSuccssflDesc Short Text for Fixed Values DDTEXT
NumberOfPeerToPeerTndrgCycles Number of Peer-to-Peer Tendering Cycles /SCMTMS/VDM_NUMBER_OF
NmbrOfSuccssflPeerToPeerTndrgs Number of Successful Peer-to-Peer Tenderings /SCMTMS/VDM_NUMBER_OF
AvgNumberOfPeerToPeerCycles Average Number of Peer to Peer Cycles /SCMTMS/VDM_RATIO
Master Data Relations Join Conditions
Purchasing Group
  • Purchasing Group
  • ?
  • ?
  • Client
  • C_TENDERINGQUERY.PURCHASINGGROUP == PLOGI.OBJID
  • C_TENDERINGQUERY.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_TENDERINGQUERY.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_TENDERINGQUERY.MANDT == PLOGI.MANDT
Purchasing Organization
  • ?
  • ?
  • Purchasing Organization
  • Client
  • C_TENDERINGQUERY.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_TENDERINGQUERY.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_TENDERINGQUERY.PURCHASINGORGANIZATION == PLOGI.OBJID
  • C_TENDERINGQUERY.MANDT == PLOGI.MANDT
Business Document Type
  • Business Document Type
  • Client