CDS Views for Analytics (TM-CF-ANA)

CDS View NameDescriptionSQL View Name
C_BUSINESSSHARECOMPLIANCECBusiness Share Compliance CubeCBSCOMPLIANCEC
C_BUSINESSSHARECOMPLIANCEQBusiness Share Compliance QueryCBSCOMPLIANCEQ
C_FREIGHTSETTLEMENTCOSTCFreight Settlement Cost CubeCFSDCOSTCUBE
C_FREIGHTSETTLEMENTCOSTQFreight Settlement Cost QueryCFSDCOSTQUERY
C_FRTBKGEXECUTIONCUBEFreight Booking Execution Event CubeCFRTBKGEXECCUBE
C_FRTBKGEXECUTIONQUERYFreight Booking Execution Event QueryCFRTBKGEXECQUERY
C_FRTBKGEXECUTIONSTSCFreight Booking Execution Status CubeCFRTBKGEXECSTSC
C_FRTBKGEXECUTIONSTSQFreight Booking Execution Status QueryCFRTBKGEXECSTSQ
C_FRTBKGQUANTITYCUBEFreight Booking Quantity CubeCFRTBKGQUANTITYC
C_FRTBKGQUANTITYQUERYFreight Booking Quantity QueryCFRTBKGQUANTITYQ
C_FRTORDEXECUTIONCUBEFreight Order Execution Event CubeCFRTORDEXECCUBE
C_FRTORDEXECUTIONQUERYFreight Order Execution Event QueryCFRTORDEXECQUERY
C_FRTORDEXECUTIONSTSCFreight Order Execution Status CubeCFRTORDEXECSTSC
C_FRTORDEXECUTIONSTSQFreight Order Execution Status QueryCFRTORDEXECSTSQ
C_FRTORDQUANTITYCUBEFreight Order Quantity CubeCFRTORDQUANTITYC
C_FRTORDQUANTITYQUERYFreight Order Quantity QueryCFRTORDQUANTITYQ
C_TENDERINGCUBETendering CubeCTENDERINGCUBE
C_TENDERINGFILTERTendering FilterCTENDERINGFILTER
C_TENDERINGQUERYTendering QueryCTENDERINGQUERY
C_TRANSPALLOCCOMPLIANCECTransportation Allocation Compliance CubeCTALCOMPLCUBE
C_TRANSPALLOCCOMPLIANCEQTransportation Allocation Compliance QueryCTALCOMPLQUERY
C_TRANSPBUSPERFMNTRORDDETQTransp. Bus. Perf. Mon. - Ord.Det. QueryCTRBUSPFMONORDDQ
C_TRANSPBUSPERFMNTRORDQTransp. Bus. Perf. Mon. - Order QueryCTRBUSPFMONORDQ
C_TRANSPORD2FORBUSDSHBRDQTransp. Bus. Perf. Dshbrd. - Ord 2 QueryCTORROOT2SACQANA
C_TRANSPORDBLOCKFORBUSDSHBRDQTransp. Bus. Perf. Dshbrd. - Block QueryCTORBLKSACQANA
C_TRANSPORDDETFORBUSDSHBRDQTransp. Bus. Perf. Dshbrd. - Ord Det QryCTORROOTDSACANAQ
C_TRANSPORDEXECFORBUSDSHBRDQTransp. Bus. Perf. Dshbrd. - Exec. QueryCTOREXESACQANA
C_TRANSPORDFORBUSDSHBRDQTransp. Bus. Perf. Dshbrd. - Ord QueryCTORROOTSACANAQ
C_TRANSPORDINVCGBLOCKSTSCTransportation Order Invoicing Block Status CubeCINVCGBLOCKSTSC
C_TRANSPORDINVCGBLOCKSTSQTransportation Order Invoicing Block Status QueryCINVCGBLOCKSTSQ
C_TRANSPORDITEMANLYTSDEXData Extraction for Transp Order Anlyts Root and ItemCTRANSPORDITMDEX
I_BUSINESSSHAREBusiness ShareIBUSINESSSHARE
I_BUSINESSSHARE2Business Share 2IBUSINESSSHARE2
I_BUSINESSSHAREENRCDBusiness Share EnrichedIBUSINESSSHAREE
I_BUSINESSSHARETARGETBusiness Share TargetIBSTARGET
I_BUSINESSSHARETARGETENRCDBusiness Share Target EnrichedIBSTARGETE
I_FREIGHTSETTLEMENTCOSTFreight Settlement CostIFSCOST
I_FREIGHTSETTLEMENTCOST3Freight Settlement Cost 3IFSCOST3
I_LASTFIVEQUARTERSDATEDate with Last Five Quarters InformationILASTFIVEQTRSDTE
I_LASTMONTHDATEDate with Last Month InformationILASTMONTHDATE
I_PEERTOPEERTENDERINGTendering Peer-to-Peer CyclesITENDP2PCYCLES
I_SUPLRFRTINVCREQENRCDSupplier Freight Invoice Request EnrichedISFIRENRCD
I_SUPLRFRTINVCREQENRCDSTDVHSupplier Freight Invoice Request EnrichedISFIRE__VH
I_SUPPLIERFREIGHTINVOICEREQSupplier Freight Invoice RequestISFIR
I_TENDERINGTenderingITENDERING
I_TENDERING2Tendering 2ITENDERING2
I_TENDERINGACCEPTANCETendering AcceptanceITENDACCEPTANCE
I_TENDERINGCYCLETIMETendering Cycle TimeITENDCYCTIME
I_TENDERINGDISCREPANCYTendering DiscrepancyITENDDISCREPANCY
I_TENDERINGENRCDTendering EnrichedITENDERINGE
I_TENDERINGMAXIMUMSEQUENCENMBRTendering Max Sequence NumberITENDMAXTENDSEQ
I_TENDERINGOPENTendering Open RequestsITENDOPENREQ
I_TENDERINGPERCENTAGETendering PercentageITENDPERCENTAGE
I_TENDERINGREQUESTTendering RequestITENDREQUEST
I_TENDERINGREQUESTENRCDTendering Request EnrichedITENDREQUESTE
I_TENDERINGRESPONSETendering ReponseITENDRESPONSE
I_TENDERINGRESPONSEENRCDTendering Response EnrichedITENDRESPONSEE
I_TENDERINGRESPONSEMAXSQNCNMBRTendering Response Maximum Sequence NumberITENDMAXRSPSEQ
I_TENDERINGSTEPTendering StepITENDSTEP
I_TENDERINGSTEPENRCDTendering Step EnrichedITENDSTEPE
I_TENDERINGSTEPMAXSEQUENCENMBRTendering Step Max Sqnc NmbrITENDMAXSTPSEQ
I_TMBLOCKREASONBlock ReasonITMBLOCKREASON
I_TMBUSINESSPARTNERBYINTKEYBusiness PartnerITMBPBYINTKEY
I_TMORGANIZATIONALUNITOrganizational UnitITMORGUNIT
I_TMORGANIZATIONALUNITFUNCTEXTOrganizational Unit Func TextITMORGUNITFUNCT
I_TMORGANIZATIONALUNITFUNCTIONOrganizational Unit FunctionITMORGUNITFUNC
I_TMORGANIZATIONALUNITROLEOrganizational Unit RoleITMORGUNITROLE
I_TMORGANIZATIONALUNITROLETEXTOrganizational Unit Role TextITMORGUNITROLET
I_TMORGANIZATIONALUNITTEXTOrganizational Unit TextITMORGUNITTEXT
I_TMORGUNITTOFUNCTIONOrganizational Unit to FunctionITMORGUNITTOFUNC
I_TRADELANETrade LaneITRADELANE
I_TRADELANESTDVHTrade LaneITL__VH
I_TRANSPALLOCBUCKETAllocation BucketITALBUCKET
I_TRANSPALLOCBUCKETENRCDAllocation Bucket EnrichedITALBUCKETE
I_TRANSPALLOCCOMPLIANCETransportation AllocationITALCOMPLIANCE
I_TRANSPALLOCENRCDTransportation Alloc EnrichedITRANSPALLOCE
I_TRANSPALLOCENRCDSTDVHTransportation Alloc EnrichedITAE__VH
I_TRANSPBUSDSHBRDFLXBLINTVLFlxbl Intvl for Transp Bus DashboardITRBUSPFSACDINT
I_TRANSPBUSPERFMNTRFLXBLINTVLFlxbl. Intvl. f. Transp. Bus. Perf. Mon.ITRBUSPFMONINT
I_TRANSPBUSPERFMNTRORDCTransp. Bus. Perf. Mon. - Root CubeITRBUSPFMONORD
I_TRANSPBUSPERFMNTRORDDETCTransp Bus Perf Mon Root Det - CubeITRBUSPFMONORDDE
I_TRANSPCHARGEITEMELEMENTENRCDTransportation Charge Item Element enrichedITCITMELEMENRCD
I_TRANSPCHARGEITEMENRCDTransportation Charge Item enrichedITCHRGITEMENRCD
I_TRANSPCHARGEOBJECTENRCDTransportation Charge Object enrichedITCHRGOBJCTENRCD
I_TRANSPMGMTBPBYINTKEYSTDVHBusiness PartnerITMBPBIK__VH
I_TRANSPMGMTORGUNITSTDVHOrganizational UnitITMOU__VH
I_TRANSPORDANLYTSFORMNTRTOR Root Analytics for CloudITORROOTANAMNTR
I_TRANSPORDBLOCKANALYTICSTransportation Order Block AnalyticsITRANSPORDBLKANA
I_TRANSPORDBLOCKENRCDTransportation Order Block EnrichedITORBLOCKENRCD
I_TRANSPORDBLOCKFORBUSDSHBRDTOR Block Analytics for SAC DashboardITORBLKSACANA
I_TRANSPORDBLOCKFORBUSDSHBRDCTransp. Bus. Perf. Dshbrd. - Block QueryITORBLKSACCANA
I_TRANSPORDDETANLYTSFORMNTRTOR Root Detail Analytics for CloudITORROOTDANAMNTR
I_TRANSPORDDETFORBUSDSHBRDTOR Item Analytics for SAC DashboardITORROOTDSACANA
I_TRANSPORDDETFORBUSDSHBRDCTOR Det Analytics for SAC Dshbrd - CubeITORROOTDSACANAC
I_TRANSPORDDLYDINTRANSITDelayed in Transit Transportation OrderITORTRANSITDELAY
I_TRANSPORDENRCDSTDVHTransportation Order EnrichedITOE__VH
I_TRANSPORDEVENTDELAYTransportation Order Event DelayIEXECDELAY
I_TRANSPORDEXECANLYTSFORMNTRTOR Execution Analytics for CloudITOREXEANAMNTR
I_TRANSPORDEXECANLYTSFORMNTR2TOR Execution Stage Analytics for CloudITOREXEANAMNTR2
I_TRANSPORDEXECFORBUSDSHBRDTOR Exec Analytics for SAC DashboardITOREXESACANA
I_TRANSPORDEXECFORBUSDSHBRDCTOR Exec Analytics for SAC Dshbrd - CubeITOREXESACCANA
I_TRANSPORDEXECUTION2Transportation Order Execution 2ITOREXECUTION2
I_TRANSPORDEXECUTIONANALYTICSTransportation Order Execution AnalyticsITRANSPORDEXEANA
I_TRANSPORDEXECUTIONENRCDTransportation Order Execution EnrichedITOREXECUTIONE
I_TRANSPORDEXECUTIONSTSTransportation Order Execution 1IEXECUTIONSTS
I_TRANSPORDFORBUSDSHBRDTOR Root Analytics for SAC DashboardITORROOTSACANA
I_TRANSPORDFORBUSDSHBRDCTOR Root Analytics for SAC Dshbrd - CubeITORROOTSACANAC
I_TRANSPORDINTRANSITIn Transit Transportation OrderITORTRANSIT
I_TRANSPORDINVCGBLOCKSTSTransportation Order Invoicing Block StatusIINVCGBLOCKSTS
I_TRANSPORDITEMANALYTICSTransportation Order Item AnalyticsITRANSPORDITMANA
I_TRANSPORDITEMANLYTSDEXPREPTransp Order Item Anlyts DEX PreparationITRANSPORDANAIEP
I_TRANSPORDQUANTITYTransportation Order QuantityITORQUANTITY
I_TRANSPORDQUANTITY2Transportation Order Quantity 2ITORQUANTITY2
I_TRANSPORDSTAGEANALYTICSTransportation Order Stage AnalyticsITRANSPORDSTGANA
I_TRANSPORDSTAGEENRCDTransportation Order Stage enrichedITORSTAGEE
I_TRANSPORDSTOPANALYTICSTransportation Order Stop AnalyticsITRANSPORDSTPANA
I_TRANSPORTATIONALLOCATIONTransportation AllocationITRANSPALLOC
I_TRANSPORTATIONORDERANALYTICSTransportation Order AnalyticsITRANSPORDANA
I_TRANSPORTATIONORDERENRCDTransportation Order EnrichedITRANSPORDERE
I_TRANSPORTATIONORDERITEMENRCDTransportation Order Item enrichedITORITEME
I_TRANSPORTATIONORDERSTOPENRCDTransportation Order Stop enrichedITORSTOPE
I_YEARMONTHDATETIMEYear Month with TimestampsIYEARMONTHDTETME
P_FREIGHTSETTLEMENTCOST2Freight Settlement Cost 2PFSCOST2
P_PEERTOPEERTENDERINGPeer-to-Peer TenderingPTENDP2PCYCLES
P_TENDERINGACCEPTANCETendering AcceptancePTENDACCEPTANCE
P_TENDERINGOPENOpen Tendering RequestsPTENDOPEN
P_TRANSPALLOCCOMPLIANCE2Transportation Allocation 2PTALCOMPLIANCE2
P_TRANSPORDDLYDINTRANSITTransportation Order delayed in TransitPTORDELAY
P_TRANSPORDDLYDINTRANSIT2Delayed in Transit Transportation Order (2)PTORDELAY2
P_TRANSPORDINTRANSITTransportation Order in TransitPTORTRANSIT
P_TRANSPORDINTRANSIT2in Transit Transportation Order (2)PTORTRANSIT2
P_TRANSPORDSUMARRIVALDELAYAggregation of Arrival Delays per Transportation OrderPTORSUMARRDLY
P_TRANSPORDSUMMEDSTAGEMEASURESTransportation Order Stage Measures by Transportation OrderPTORSUMSTAGEM