CDS Views for Cross functions (TM-CF)

CDS View NameDescriptionSQL View Name
I_ARCHIVINGSTATUSArchiving StatusIARCHIVINGSTS
I_ARCHIVINGSTATUSTEXTArchiving Status TextIARCHIVINGSTST
I_BLOCKCATEGORYBlock CategoryIBLOCKCATEGORY
I_BLOCKCATEGORYTEXTBlock Category - TextIBLOCKCATEGORYT
I_BLOCKREASONCODEBlock Reason CodeIBLOCKREASONCODE
I_BLOCKREASONCODETEXTBlock Reason Code - TextIBLOCKREASONCDT
I_BLOCKSTATUSBlock StatusIBLOCKSTATUS
I_BLOCKSTATUSTEXTBlock Status TextIBLOCKSTATUSTEXT
I_BOPFADDRUUID2ADDRIDMAPMap BOPF Address UUID to Address IDsIBOPFADRUUIDMAP
I_BUSTRANSDOCTYPECODEBusiness Transaction Document Type CodeIBTDTYPECODE
I_BUSTRANSDOCTYPECODETEXTBusiness Transaction Doc. Type Code TextIBTDTYPETEXT
I_CARRIERASSIGNMENTMETHODCarrier Assignment MethodICARRASSGMMETH
I_CARRIERASSIGNMENTMETHODTEXTCarrier Assignment Method TextICARRASSGMMETHT
I_CARRIERINVOICINGSTATUSCarrier Invoicing StatusCARRIERINVSTS
I_CARRIERINVOICINGSTATUSTEXTCarrier Invoicing Status TextICARRIERINVSTST
I_CARRIERISFROMTENDERINGIndicator that Carrier is from TenderingIISCARRFROMTEND
I_CARRIERISFROMTENDERINGTEXTText of Indicator that Carrier is from TenderingIISCARRFROMTENDT
I_CARRIERORIGINOFENTRYCarrier Origin of EntryICARRIERORIGIN
I_CARRIERORIGINOFENTRYTEXTCarrier Origin of Entry TextICARRIERORIGINT
I_DISCREPANCYTYPEDiscrepancy TypeIDSCRCYTYPE
I_DISCREPANCYTYPETEXTDiscrepancy Type TextIDSCRCYTYPETEXT
I_DOMAINDomainIDOMAIN
I_DOMAINFIXEDVALUEDomain Fixed ValueIDOMFIXVAL
I_DOMAINFIXEDVALUETEXTDomain Fixed Value TextIDOMFIXVALTEXT
I_FREIGHTQUOTATIONSTATUSFreight Quotation StatusIFREQUOTSTATUS
I_FREIGHTQUOTATIONSTATUSTEXTFreight Quotation Status TextIFREQUOTSTATUST
I_FRTORDHASCOMPLETEDTNDRGIndicator that Freight Order has completed TenderingIHASFOCOMPLTEND
I_FRTORDHASCOMPLETEDTNDRGTText of Ind. that Freight Order has completed TenderingIHASFOCOMPLTENDT
I_GEOGRAPHICALENTITYTYPEGeographical Entity TypeIGEOENTITYTYPE
I_GEOGRAPHICALENTITYTYPETEXTGeographical Entity Type TextIGEOENTITYTYPET
I_INVOICINGISBLOCKEDInidcator that Invoicing is BlockedIFSDBLOCK
I_INVOICINGISBLOCKEDTEXTInid. that Invoicing is Blocked TextIFSDBLOCKTEXT
I_INVOICINGSTATUSInvoicing StatusIINVSTATUS
I_INVOICINGSTATUSTEXTInvoicing Status TextIINVSTATUSTEXT
I_ISMULTIITEMIndicator that Transportation Order Item is Multi ItemITORITEMMULTI
I_ISMULTIITEMTEXTTransportation Order Item is Multi Item TextITORITEMMULTIT
I_ISPROPOSEDFREIGHTQUOTATIONIndicator that Freight Quotation Is proposed Freight Quot.IISPROPFRTQTAN
I_ISPROPOSEDFREIGHTQUOTATIONTText of Indicator that Is Proposed Freight QuotationIISPROPFRTQTANT
I_LOCATIONADDRESSVHLocation Value help with Address AttributesILOCADDR_VH
I_MEANSOFTRANSPORTMeans of TransportIMEANSOFTRANSP
I_MEANSOFTRANSPORTTEXTMeans of Transport TextIMEANSOFTRANSPT
I_MULTIITEMTransportation Order Item is Multi ItemITORITMMULTI
I_MULTIITEMTEXTTransportation Order Item is Multi Item Description TextITORITMMULTIT
I_PEERTOPEERTNDRGISSUCCSSFLIndicator for successfull Tendering Peer-to-Peer CyclesIISP2PTENDSUCC
I_PEERTOPEERTNDRGISSUCCSSFLTText of Indicator successfull Tendering Peer-to-Peer-CyclesIISP2PTENDSUCCT
I_QUOTATIONREVIEWISREQUIREDIndicator that Quotation Review is requiredIISQTANREVRQD
I_QUOTATIONREVIEWISREQUIREDTText of Indicator that Quotation Review is requiredIISQTANREVRQDT
I_SUPLRFRTINVCREQCATEGORYSupplier Freight Invoice Request CategoryISFIRCATEGORY
I_SUPLRFRTINVCREQCATEGORYTEXTSupplier Freight Invoice Request Category TextISFIRCATEGORYT
I_SUPLRFRTINVCREQCONFSTATUSSupplier Freight Invoice Req. Confirmation StatusISFIRCONFSTATUS
I_SUPLRFRTINVCREQCONFSTATUSTSupplier Freight Invoice Req. Conf. Status TextISFIRCONFSTATUST
I_SUPLRFRTINVCREQCONSTCYSTSFreight Settlement Cost Consistency StatusICONSTCYSTS
I_SUPLRFRTINVCREQCONSTCYSTSTFreight Settlement Cost Consistency Status TextICONSTCYSTSTEXT
I_SUPLRFRTINVCREQLIFECYCSTSSupplier Freight Invoice Req. Life Cycle StatusISFIRLCSTATUS
I_SUPLRFRTINVCREQLIFECYCSTSTSupplier Freight Invc. Req. Life Cycle Status TextISFIRLCSTATUTT
I_SUPLRFRTINVCREQTYPESupplier Freight Invoice Request TypeISFIRTYPE
I_SUPLRFRTINVCREQTYPETEXTSupplier Freight Invoice Request Type TextISFIRTYPETEXT
I_TENDERINGAWARDSTATUSTendering Award StatusITENDAWARDSTS
I_TENDERINGAWARDSTATUSTEXTTendering Award Status TextITENDAWARDSTST
I_TENDERINGHASCOMPLETEDCYCLEIndicator that Tendering has completed CycleIHASCOMPLTEND
I_TENDERINGHASCOMPLETEDCYCLETText of Indicator that Tendering has completed CycleIHASCOMPLTENDT
I_TENDERINGISSUCCESSFULIndicator that Tendering is SuccessfulIISTENDSUCC
I_TENDERINGISSUCCESSFULTEXTText of Indicator that Tendering is SuccessfulIISTENDSUCCT
I_TENDERINGLIFECYCLESTATUSTendering Life Cycle StatusITENDLIFECYCSTS
I_TENDERINGLIFECYCLESTATUSTTendering Life Cycle Status TextITENDLIFECYCSTST
I_TENDERINGPROCESSMODETendering Process ModeITENDPROCMODE
I_TENDERINGPROCESSMODETEXTTendering Process Mode TextITENDPROCMODET
I_TENDERINGPROCESSRESULTTendering Process ResultITENDPROCRESULT
I_TENDERINGPROCESSRESULTTEXTTendering Process Result TextITENDPROCRESULTT
I_TENDERINGREJECTIONREASONTendering Rejection ReasonITENDREJREASON
I_TENDERINGREJECTIONREASONTEXTTendering Rejection Reason TextITENDREJREASONT
I_TENDERINGREQUESTISCMPLTDTEXTText Indicator Tendering Req completedIISTENDCOMPLT
I_TENDERINGREQUESTISCOMPLETEDIndicator that Tendering is completedIISTENDCOMPL
I_TENDERINGREQUESTISOPENIndicator that Tendering Request is OpenIISTENDREQOPEN
I_TENDERINGREQUESTISOPENTEXTText of Indicator that Tendering Request is OpenIISTENDREQOPENT
I_TENDERINGREQUESTISOVERDUEIndicator that Tendering Request is OverdueIISTENDREQOVRD
I_TENDERINGREQUESTISOVERDUETText of Indicator that Tendering Request is OverdueIISTENDREQOVRDT
I_TENDERINGRESPONSECODETendering Response CodeITENDRESCODE
I_TENDERINGRESPONSECODETTendering Response Code TextITENDRESCODETEXT
I_TENDERINGTYPETendering TypeITENDTYPE
I_TENDERINGTYPETEXTTendering Type TextITENDTYPETEXT
I_TMLOCATIONDESCRIPTIONHarmonized Location Description for TMITMLOCDESCR
I_TNDRGCARRIERISDISCREPANTIndicator that Tendering Carrier is DiscrepantIISTENDCARRDSCR
I_TNDRGCARRIERISDISCREPANTTEXTText of Indicator that Tendering Carrier is DiscrepantIISTENDCARRDSCRT
I_TNDRGQUOTATIONEVALRESULTTendering Quotation Evaluation ResultITENDQUOTEVALRE
I_TNDRGQUOTATIONEVALRESULTTEXTTendering Quotation Evaluation Result TextITENDQUOTEVALRET
I_TNDRGREQLIFECYCLESTATUSTendering Request Life Cycle StatusITENDREQLCSTS
I_TNDRGREQLIFECYCLESTATUSTEXTTendering Request Life Cycle Status TextITENDREQLCSTST
I_TNDRGRESPONSEISNEGATIVEIndicator that Tendering Response is NegativeIISTENDRSPNEG
I_TNDRGRESPONSEISNEGATIVETEXTText of Indicator that Tendering Response is NegativeIISTENDRSPNEGT
I_TNDRGRESPONSEISPOSITIVEIndicator that Tendering Response is PositiveIISTENDRSPPOS
I_TNDRGRESPONSEISPOSITIVETEXTText of Indicator that Tendering Response is PositiveIISTENDRSPPOST
I_TNDRGSTEPLIFECYCLESTATUSTendering Step Life Cycle StatusITENDSTEPLCSTS
I_TNDRGSTEPLIFECYCLESTATUSTEXTTendering Step Life Cycle Status TextITENDSTEPLCSTST
I_TRADELANEORIENTATIONTrade Lane OrientationIORIENTATION
I_TRADELANEORIENTATIONTEXTTrade Lane Orientation TextIORIENTATIONTEXT
I_TRALCANDBUSSHRISUPDTDBYRFQInd TrAlc BusShr update by RFQIISUPDATEDBYRFQ
I_TRALCANDBUSSHRISUPDTDBYRFQTTransp. Allocation & Business Share is updated by RFQ TextIISUPDATEDBYRFQT
I_TRANSPAIRLINEIATACODETransporation IATA CodeITIATAC
I_TRANSPAIRLINEIATACODETEXTTransportation Airline IATA Code TextITIATACTEXT
I_TRANSPALLOCBUCKETTYPETransp Allocation Bucket TypeITALBUCKETTYPE
I_TRANSPALLOCBUCKETTYPETEXTAllocation Bucket Type TextITALBUCKETTYPET
I_TRANSPALLOCCATEGORYAllocation CategoryITALCATEGORY
I_TRANSPALLOCCATEGORYTEXTAllocation Category TextITALCATEGORYTEXT
I_TRANSPALLOCTYPEAllocation TypeITALTYPE
I_TRANSPALLOCTYPETEXTAllocation Type TextITALTYPETEXT
I_TRANSPBUSINESSPARTNERVHTM Business Partner value helpIBP_VH
I_TRANSPCARRIERVHTM Carrier value helpICARRIER_VH
I_TRANSPEXECCARRIERVHTM Execution Carrier value helpIEXECCARRIER_VH
I_TRANSPEXECDSCRCYSUBCATTransportation Order Execution Discrepancy SubcategoryITORDSCRPSUBCAT
I_TRANSPEXECDSCRCYSUBCATTEXTTransportation Order Execution Discrepancy Subcategory TextITORDSCRPSUBCATT
I_TRANSPHNDLGEXECSTATUSTransportation Handling Execution StatusITRHDLEXECST
I_TRANSPHNDLGEXECSTATUSTEXTTransp. Handling Execution Status TextITRHDLEXECSTTEXT
I_TRANSPMOVEMENTTYPETransportation Order Movement TypeITORMVTYPE
I_TRANSPMOVEMENTTYPETEXTTransportation Order Movement Type TextITORMVTYPETEXT
I_TRANSPORDBLOCKISOVERRULEDTransportation Order Block is OverruledITORBLKOVERRULED
I_TRANSPORDBLOCKISOVERRULEDTTransportation Order Block is Overruled - TextITORBLKOVERRULDT
I_TRANSPORDDELIVERYSTATUSTransportation Order Delivery StatusITORDLVSTS
I_TRANSPORDDELIVERYSTATUSTDelivery Status of a Transportation Order TextITORDLVSTSTXT
I_TRANSPORDEVENTCODETransp Order Event CodeIEVENTCODE
I_TRANSPORDEVENTCODETEXTTransp Order Event Code TextIEVENTCODETEXT
I_TRANSPORDEVENTISDELAYEDIndicator that Transportation Order Event is DelayedIISTOREVTDLYD
I_TRANSPORDEVENTISDELAYEDTEXTText of Indicator that Transportation Order Event is DelayedIISTOREVTDLYDT
I_TRANSPORDEVENTISONTIMEIndicator that Transportation Order Event is On TimeIISTOREVTONTIME
I_TRANSPORDEVENTISONTIMETEXTText of Indicator that Transportation Order Event is On TimeIISTOREVTONTIMET
I_TRANSPORDEVENTISRECALLEDIndicator that Transp. Order Event is RecalledIEVENTREVOKED
I_TRANSPORDEVENTISRECALLEDTEXTDescription of Recalled Transp. Order Event Ind.IEVENTREVOKEDT
I_TRANSPORDEVENTISTIMERLVTIndicator that Transportation Order Event is Time RelevantIISTOREVTTMERLVT
I_TRANSPORDEVENTISTIMERLVTTEXTText of Indicator that Transp. Order Event is Time RelevantIISTOREVTTMERLTT
I_TRANSPORDEVENTSTATUSTransportation Order Event StatusIEVENTSTATUS
I_TRANSPORDEVENTSTATUSTEXTTransportation Order Event Status TextIEVENTSTATUST
I_TRANSPORDEXECINFOSOURCETransportation Order: Execution Info SourceIEXECINFOSRC
I_TRANSPORDEXECINFOSOURCETEXTTransportation Order: Execution Info Source TextIEXECINFOSRCTXT
I_TRANSPORDEXECUTIONBLOCKTEXTInd Transp Ord Exe Block - TextIEXECBLOCKTEXT
I_TRANSPORDEXECUTIONISBLOCKEDIndicator of Transportation Order Execution BlockIEXECBLOCK
I_TRANSPORDHASQTYDISCREPANCYInd. that Transp. Order has Discrepant QuantityIQTYDISCREPANCY
I_TRANSPORDHASQTYDISCREPANCYTDesc. of Transp. Order Quantity Discrepancy Ind.IQTYDISCREPANCYT
I_TRANSPORDISDISCREPANTIndicator that Transportation Order is DiscrepantIDISCREPANCY
I_TRANSPORDISDISCREPANTTEXTTransp Order discrep ind textIDISCREPANCYTEXT
I_TRANSPORDISDLYDINTRANSITIndicator that Transp. Order is delayed and in TransitIISTORDLYDTRNST
I_TRANSPORDISDLYDINTRANSITTText of Ind. that Transp. Order is Delayed and In TransitIISTORDLYDTRNSTT
I_TRANSPORDISDSCRPTWTHOUTBLKInd. Transp. Order is Discrepant without BlockIDSCRCYNOBLOCK
I_TRANSPORDISDSCRPTWTHOUTBLKTDesc. of Ind. Discrepant Transp. Order w/o BlockIDSCRCYNOBLOCKT
I_TRANSPORDISINTRANSITIndicator that Transportation Order is In TransitIISTORTRANSIT
I_TRANSPORDISINTRANSITTEXTText of Indicator that Transportation Order is In TransitIISTORTRANSITT
I_TRANSPORDITEMCATEGORYTransportation Order Item CategoryITORITEMCAT
I_TRANSPORDITEMCATEGORYTEXTTransportation Order Item Category TextITORITEMCATTEXT
I_TRANSPORDITEMTYPETransportation Order Item TypeITORITEMTYPE
I_TRANSPORDITEMTYPETEXTTransportation Order Item Type TextITORITEMTYPETEXT
I_TRANSPORDLIFECYCLESTATUSTransportation Order Life Cycle StatusITORLIFECYCSTS
I_TRANSPORDLIFECYCLESTATUSTEXTTransp. Order Life Cycle Status TextITORLIFECYCSTST
I_TRANSPORDPLANNINGBLOCKIndicator of Transp. Ord. Planning BlockIPLANNINGBLOCK
I_TRANSPORDPLANNINGBLOCKTEXTInd. Transp. Ord. Planning Block TextIPLANNINGBLOCKT
I_TRANSPORDPLANNINGSTATUSTransportation Order Planning StatusITORPLANSTATUS
I_TRANSPORDPLANNINGSTATUSTTransp. Order Planning Status TextITORPLANSTATUST
I_TRANSPORDSHIPPINGTYPETransportation Order Shipping TypeITMSHIPPINGTYPE
I_TRANSPORDSHIPPINGTYPETEXTTransportation Order Shipping Type TextITMSHIPPINGTYPET
I_TRANSPORDSTAGECATEGORYTransportation Order Stage CategoryITORSTAGECAT
I_TRANSPORDSTAGECATEGORYTEXTTransportation Order Stage Category TextITORSTAGECATT
I_TRANSPORDSTAGEPLNSTATUSTransportation Order Planning StatusITORSTGPLANSTAT
I_TRANSPORDSTAGEPLNSTATUSTTransportation Order Planning Status TextITORSTGPLANSTATT
I_TRANSPORDSTAGETYPETransportation Order Stage TypeITORSTAGETYPE
I_TRANSPORDSTAGETYPETEXTTransportation Order Stage Type TextITORSTAGETYPET
I_TRANSPORDSTOPCATEGORYTransportation Order Stop CategoryITORISTOPCAT
I_TRANSPORDSTOPCATEGORYTEXTTransportation Order Stop Category TextITORSTOPCATT
I_TRANSPORDSTOPROLETransportation Order Stop RoleITORSTOPROLE
I_TRANSPORDSTOPROLETEXTTransportation Order Stop Role TextITORSTOPROLETEXT
I_TRANSPORDTRAFFICDIRECTIONTransportation Order Traffic DirectionITRAFFICDIR
I_TRANSPORDTRAFFICDIRECTIONTTransp. Ord. Traffic Direction TextITRAFFICDIRTEXT
I_TRANSPORTATIONACTIVITYTransportation ActivityITRANSPACTIVITY
I_TRANSPORTATIONACTIVITYTEXTTransportation Activity TextITRANSPACTIVITYT
I_TRANSPORTATIONMODETransportation ModeITRMODE
I_TRANSPORTATIONMODECATEGORYTransportation Mode CategoryITRMODECAT
I_TRANSPORTATIONMODECATEGORYTTransportation Mode Category TextITRMODECATTEXT
I_TRANSPORTATIONMODETEXTTransportation Mode TextITRMODETEXT
I_TRANSPORTATIONORDERCATEGORYTransportation Order CategoryITORCATEGORY
I_TRANSPORTATIONORDERCATEGORYTTransportation Order Category TextITORCATEGORYTEXT
I_TRANSPORTATIONORDEREXECSTSTransportation Order Execution StatusIEXECSTATUS
I_TRANSPORTATIONORDEREXECSTSTTransp. Order Execution Status TextIEXECSTATUSTEXT
I_TRANSPORTATIONORDERTYPETransportation Order TypeITORTYPE
I_TRANSPORTATIONORDERTYPETEXTTransportation Order Type TextITORTYPETEXT
I_TRANSPPRODUCTProduct in Transportation ManagementITRANSPPROD
I_TRANSPPRODUCTVHTM Product value helpIPRODUCT_VH
I_TRANSPSCACCODETransportation SCAC CodeITSCACC
I_TRANSPSCACCODETEXTTransportation SCAC Code TextITSCACCTEXT