I_Tendering2

Tendering 2 | view: ITENDERING2 | TRAN | Extraction: Not supported | Component: Analytics
Tables used: /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, /SCMB/HRP5561, T77S0
Column Name Description
TransportationOrderUUID Transportation Order UUID
TenderingUUID Tendering UUID
TenderingStepUUID Tendering Step UUID
TenderingRequestUUID Tendering Request UUID
TenderingResponseUUID Tendering Response UUID
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 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 Time Unit of Measure (DisplayTimeUnit):
MaxResponseDurationInDspUnit Tendering Maximum Response Duration 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
CarrierBusPurposeIsCompleted Carrier Business Purpose is Completed Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
TenderingLifeCycleStatus Tendering Life Cycle Status Show values
TenderingProcessResult Tendering Process Result Show values
TrAlcAndBusShrIsUpdtdByRFQ RFQ Updates Allocations and Business Shares Show values
CarrierAssignmentMethod Tendering Carrier Assignment Method Show values
TenderingType Tendering Type Show values
TndrgStepLifeCycleStatus Tendering Step Life Cycle Status Show values
TenderingProcessMode Tendering Process Mode Show values
RelativePriceLimitInPercent Tendering Relative Price Limit in Percent Show values
TndrgReqLifeCycleStatus Tendering Request Life Cycle Status Show values
TndrgReqdCarrBusPrpsIsCmpltd Business Purpose Completed Flag Show values
TenderingAwardStatus Tendering Award Status Show values
TenderingResponseCode Tendering Response Code Show values
TndrgQuotationEvalResult Tendering Quotation Evaluation Result Show values
TndrgSeldCarrBusPrpsIsCmpltd Business Purpose Completed Flag Show values
IsProposedFreightQuotation Tendering Is Proposed Freight Quotation Show values
QuotationReviewIsRequired Quotation Review is Required Show values
FreightQuotationStatus Freight Quotation Status Show values
Column Name Description Domain name
TransportationOrder Document /SCMTMS/TOR_ID
TenderingSequenceNumber Tendering Sequence Number
TenderingStepSequenceNumber Tendering Step Sequence Number
TenderingRequestSequenceNumber Tendering Request Sequence Number
TenderingResponseSqncNumber Tendering Response Sequence Number
CreationDateTime Created on Timestamp TZNTSTMPS
ChangedDateTime Created on Timestamp TZNTSTMPS
TranspOrdResponsiblePerson Person Responsible UNAME
PurchasingOrgExternalID Transportation Purchasing Organization /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Transportation Purchasing Group /SCMB/ORG_EXT_ID
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
TransportationMode Transportation Mode VKTRA
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
Carrier Carrier /SCMTMS/BU_PARTNER
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
TenderingCreationUser Tendering Created By User XUBNAME
TenderingChangeUser Tendering Changed By User XUBNAME
TenderingStartDateTime Tendering Start Date and Time TZNTSTMPS
TenderingEndDateTime Tendering End Date Time TZNTSTMPS
TenderingRequestedCarrier Tendering Requested Carrier BU_PARTNER
FreightQuotationDueDateTime Tendering Response Due Date and Time TZNTSTMPS
TenderingRejectionReason Tendering Rejection Reason /SCMTMS/REJ_REASON_CODE
TenderingSelectedCarrier Tendering Selected Carrier BU_PARTNER
HundredInPercent Hundred In Percent DEC3
Master Data Relations Join Conditions
Country key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • I_TENDERING2.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TENDERING2.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_TENDERING2.MANDT == T005.MANDT
Region code
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Source Location Region
  • Client
  • I_TENDERING2.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TENDERING2.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TENDERING2.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TENDERING2.SOURCELOCATIONREGION == T005S.BLAND
  • I_TENDERING2.MANDT == T005S.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • ?
  • ?
  • I_TENDERING2.MANDT == PLOGI.MANDT
  • I_TENDERING2.PURCHASINGGROUP == PLOGI.OBJID
  • I_TENDERING2.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TENDERING2.[column in domain "OTYPE"] == PLOGI.OTYPE
Purchasing Organization
  • Client
  • ?
  • ?
  • Purchasing Organization
  • I_TENDERING2.MANDT == PLOGI.MANDT
  • I_TENDERING2.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TENDERING2.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_TENDERING2.PURCHASINGORGANIZATION == PLOGI.OBJID
Country key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • I_TENDERING2.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TENDERING2.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_TENDERING2.MANDT == T005.MANDT
Region code
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Source Location Region
  • Client
  • I_TENDERING2.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TENDERING2.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TENDERING2.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TENDERING2.SOURCELOCATIONREGION == T005S.BLAND
  • I_TENDERING2.MANDT == T005S.MANDT
Business Document Type
  • Client
  • Business Document Type