CDS Views for S4CRM: Analytics (CRM-S4-ANA)

CDS View NameDescriptionSQL View Name
C_DISCHANNELORGUNITVHSales Org specific Distribution ChannelCSDISCHSORGUNVH
C_EXPIRINGSRVCCONTRDETAILSExpiring Service Contract DetailsCEXPSRVCCONTR
C_INCMPLTSERVICEORDERQUERYIncomplete Service Order - QueryCINSRVCORDQRY
C_INCMPLTSRVCORDANLYSIncomplete Service OrdersCINCMPSRVORDANL
C_OVERDUESERVICEORDERDetailed Analysis Page for Overdue Service OrdersCOVERSERVORDDAP
C_SALESGROUPORGUNITVHSales Office specific Sales GroupCSOFFICEGRPORGVH
C_SALESOFFICEORGUNITVHSales Area specific Sales OfficeCSAREAOFCUNITVH
C_SALESORGANIZATIONUNITVHValue Help for Sales Organization UnitCSALESORGUNITVH
C_SALESORGDIVISIONVHSales Org/Dis Ch specific Org DivisionCSLORGDIVISIONVH
C_SALESORGUNITVHValue Help for Sales Organization UnitCSLSORGUNITVH
C_SERVICECONTRACTANALYTICSQRYService Contract Analytics QueryCSERVCONTRANAQRY
C_SERVICECONTRACTISSUEQRYAnalytical Query For Service Contract IssuesCSRVCCONTRISSQRY
C_SERVICECONTRFINLISTService Contract Finance ListCSERVCONTRFINLST
C_SERVICEDOCITEMANALYTICSQRYAnalytics Query for Srvc Trans. ItemCSERVDOCITANAQRY
C_SERVICEDOCREVENUEQUERYService Transaction Revenue - QueryCSRVCDOCREVQRY
C_SERVICEDOCUMENTTYPEVHService Document Type Value HelpCSERVDOCTYPEVH
C_SERVICEMGMTOVPGGLOBALFLTRQuery view for Service management filterCSERVMGTGLBFLTR
C_SERVICEORDERANALYTICSQRYService Order Analytics QueryCSERVORDANAQRY
C_SERVICEORDERISSUEQUERYService Order IssuesCSRVCORDISSUEQ
C_SERVICEORDERITEMISSUEQRYService transaction item issuesCSRVORDITMISSQRY
C_SERVICEORDERQUERYService Order - QueryCSRVCORDQRY
C_SERVICEORDERTYPEVHService Order TypeCSERVORDTYPEVH
C_SITNSRVCCONTREXPIRYDETAILSSituation handling for contractsCSTINSRVCEXP
C_SRVCCONTRFINANCECARDSrvc. Contrct Card -TCV & Profit marginCSRVCONTROVWCARD
C_SRVCCONTRFINANCIALQUERYFinance Data in Service Contract ΓÇô QueryCSRVCCONTRFINQRY
C_SRVCCONTRFINQUERY_2Finance Data in Service Contract ΓÇô QueryCSRVCCONTRFINQY2
C_SRVCCONTRINTORDERQUERYInternal Order of Srvc Contract ΓÇô QueryCSRVCONTINTQRY
C_SRVCORDCONFITEMSVISLFLTRSrvcOrder by Confirmation-Visual FilterCSOCNFITMVSLFLT
C_SRVCORDTRANTYPEVISLFLTRService Ord. Trans. Type Visual FilterCSRVORDTRNVSLFLT
I_CUSTMGMTISSUEBasic view for customer management issueICUSTMGMTISSUE
I_CUSTMGMTISSUETEXTText view for customer management issueICUSTMGMTISSTXT
I_SALESAREASALESOFFICEORGUNITSales Area of Org UnitISLSAREAORGUNT
I_SALESGROUPORGUNITSales Group Organization UnitISLSGRPORGUNT
I_SALESOFFICEORGUNITSales Office Organization UnitISLSOFFORGUNT
I_SALESORGANIZATIONORGUNITSales Organization UnitISALESORGNUNIT
I_SERVICECONTRACTCUBEService Contract CubeISERVCONTRCUBE
I_SERVICECONTRACTCUBE_2Service Contract - CubeISRVCCONTRCUBE2
I_SERVICECONTRACTFINDATACUBEService Contract Financial Data CubeISERVCONTRFINCBE
I_SERVICECONTRACTISSUECUBECube For Service Contract IssuesISRVCONTRISSUEC
I_SERVICECONTRACTPERIODICCUBEService Contract Cube with Periodic DataISERVCCONTRPERD
I_SERVICEDOCREVENUECUBEService Transaction Revenue - CubeISRVCDOCREVCUBE
I_SERVICEDOCUMENTITEMCUBEService Transaction Item CubeISERVDOCITEMCUBE
I_SERVICEORDERCUBEService Order - CubeISERVORDCUBE
I_SERVICEORDERCUBE_2Service Order - CubeISERVORDCUBE2
I_SERVICEORDERISSUECUBECube for service order issuesISRVCORDISSUEC
I_SERVICEORDERITEMCUBECube for Service Order ItemISRVCORDITMCUBE
I_SERVICEORDERITEMISSUECService order item issue cubeISRVORDITMISSUEC
I_SERVICEORDERPERIODCODEService Order Period CodeISRVCORDPRD
I_SERVICEORDERPERIODCODETEXTService Order Period Code TextISRVCORDPRDTXT
I_SRVCCONFISSUEBasic view for customer management conf issue categoryISRVCCONFISS
I_SRVCCONFISSUETEXTText view for customer management conf issue categoryISRVCCONFISSTXT
I_SRVCCONTRACTEXPIRYPERIODService Contract Expiry PeriodISRVCONTREXPRD
I_SRVCCONTRACTEXPIRYPERIODTXTService Contract Expiry Period TextISRVCONTREXPRDTX
I_SRVCCONTRFINANCIALCUBEService Contract Financial - CubeISRVCCONTRFINC
I_SRVCCONTRGLACCTLINEITEMCUBEGL Account Item for Srvc Contract - CubeISRVCCONTRGLCBE
I_SRVCCONTRINTORDERCUBEInternal Order of Srvc Contract - CubePSRVINTORDCUB
I_SRVCDOCFUPINTERNALORDERFollow-Up Internal Order of Srvc TransacISRVFUPINTORD
I_SRVCORDCONFSTATUSService Order Confirmed StatusISRVCORDCONFITM
I_SRVCORDCONFSTATUSTEXTService Order Confirmed Status TextISVORDCONFITMTX
P_BUSSOLNPRTFLOALLITEMP View for All itemsPBSPALLITEM
P_BUSSOLNPRTFLOSLSORDERITMP View for sales order itemPBSPSLSORDITEM
P_BUSSOLNPRTFLOSRVCCONTRITMP View for service contract itemPBSPSRVCCONTITM
P_BUSSOLNPRTFLOSRVCORDERITMP View for service order itemPBSPSRVCORITM
P_CALENDARCalendarPCALENDAR
P_CALENDARENDWEEKCalendarPCALENDARENDWK
P_CALENDARWEEKCalendarPCALENDARWK
P_CALENDARYEARCalendar Year in IntegerPCALENDARYEAR
P_EXPRGSRVCCONTRITMCHKVALIDITYExpiring Service Contract Item at HeaderPEXPSRVCONTRITCV
P_EXPRGSRVCCONTRITMFORALERTSExpiring Service Contract Item at HeaderPEXPSRVCONTRITMA
P_EXPRGSRVCCONTRITMVALDTYDAYSDetermine Service Contract Item Validity DaysPEXPSRVCONTRITMV
P_SERVICECONTRACTDATACALCService Contract CubePSRVCCONTRCALC
P_SERVICECONTRACTDATACUBEService Contract CubePSRVCCONTRCUBE
P_SERVICECONTRACTISSUEKEYKeys For Service Contract IssuesPSRVCONTRISSKEYS
P_SERVICEDOCITEMAVGDURATIMEService Item Avg Duration Time CalcPSERVITMAVGDURTM
P_SERVICEDOCITEMAVGDURATIONAverage Duration Of Service Trans. ItemsPSERVITMAVGDUR
P_SERVICEDOCITEMFUNCLOCFunction location text for service document itemPSRVCDOCFUNLOC
P_SERVICEDOCLINITMFINCONVDATAService Document Finance Data Conversion Line Item LevelPSRVCDOCCONVITM
P_SERVICEDOCLINITMFINDATAService Document Finance Data Line Item LevelPSRVCDOCFINITM
P_SERVICEORDERDATACUBEService Order Data CubePSERVORDDCUBE
P_SERVICEORDERISSUEKEYKeys for service order items with issues including catagoryPSRVCORDISSKEYS
P_SERVICEORDERITEMDATACUBEHelper view for Service Order Item CubePSRVORDIEMDTCB
P_SERVICETRANSACTIONISSUEKEYSKeys for service order items with issues including catagoryPSRVCTRNISSKEYS
P_SRVCCONTRDAYSService Contract DaysPSRVCCONTRCTDAYS
P_SRVCCONTRFINYear to Date Service contract financial dataPSRVCCONTRFIN
P_SRVCCONTRFINANCEFinancial Data of Service ContractPSRVCCONTRCTFIN
P_SRVCCONTRFINPERIODICSUMService Contract Aggregated Finance Data with periodic dataPSRVCCONTRPERDC
P_SRVCCONTRFINSUMService Contract Aggregated Finance DataPSRVCCONTRCTSUM
P_SRVCCONTRGLACCTSUMCARDService Contract Finance CubePSRVCCONTRGLSUM
P_SRVCCONTRLINITMFINCONVDATAService Contract Finance Data Conversion Line Item LevelPSRVCONTCONVITM
P_SRVCCONTRLISTService Contracts ListPSRVCCONTRLIST
P_SRVCDOCINTORDFINCNVRSNDATAService Document Internal Order Finance Conversion DataPSRVINTORDCONV
P_SRVCDOCINTORDFINDATAService Document Internal Order Finance DataPSRVCINTORDDAT
P_SRVCDOCREVENUEFOR2YEARSService Document Revenue for Last year and Current yearPSRVCDOCREVYRS
P_SRVCORDDISTINCTCONFEXISTService Order with ConfirmationPSRVCONFDSTEXST
P_SRVCORDITMCONFEXISTService Order Item Confirmation Issues CountPSRVCONFEXIST
P_SRVCTRANSACTIONISSUEITEMC001View for items with issue C001/C001 - No ConfirmationPSRVCISSITMC001
P_SRVCTRANSACTIONISSUEITEMC002View for items with issue C001/C002 - Conf. Contain ErrorsPSRVCISSITMC002
P_SRVCTRANSACTIONISSUEITEMC003View for items with issue C001/C003 - Open ConfirmationsPSRVCISSITMC003
P_SRVCTRANSACTIONISSUEITEMC004View for items with issue C001/C004 - No Final ConfirmationPSRVCISSITMC004
P_SRVCTRANSACTIONISSUEITEMC005View for items with issue C001/C005 - More t. 1 Final Conf.PSRVCISSITMC005
P_SRVCTRANSACTIONISSUEITEME001View for items with issue E001 - Has ErrorPSRVCISSITME001
P_SRVCTRANSACTIONISSUEITEMKEYSKeys for service order items with issues including catagoryPSRVCTRNISSITMKS
P_SRVCTRANSACTIONISSUESHDRKEYSKeys for service order items with issues including catagoryPSRVCTRHISSHDRKS
P_SRVCTRANSACTIONISSUETIMESTMPView for items with issue C001/C001 - No ConfirmationPSRVCISSITSTMP