CDS Views for S4CRM: Reporting (CRM-S4-REP)

CDS View NameDescriptionSQL View Name
CRMS4_ACPT_STATUSAcceptance StatusCRMS4_ACPTSTATUS
CRMS4_ACTIVATION_STATUSActivation StatusCRMS4_ACTISTATUS
CRMS4_ACTV_EQUIP_SEARCHActivity Equipment SearchCRMS4_ACTVEQUIP
CRMS4_ACTV_SEARCHActivity SearchCRMS4_ACTVSEARCH
CRMS4_ARCB_STATUSArchivable StatusCRMS4_ARCBSTATUS
CRMS4_ARCD_STATUSArchived StatusCRMS4_ARCDSTATUS
CRMS4_BILL_STATUSBilling StatusCRMS4_BILLSTATUS
CRMS4_CANC_STATUSCancelled StatusCRMS4_CANCSTATUS
CRMS4_CHKLST_EXEC_STATUSChecklist Item Execution StatusCRMS4_CHKLSTATUS
CRMS4_COTS_STATUSContract Time Slice StatusCRMS4_COTSSTATUS
CRMS4_DELI_STATUSDelivery StatusCRMS4_DELISTATUS
CRMS4_DIRECTION_TEXTDirection TextCRMS4_DIRECTIONT
CRMS4_DMEA_H_SEARCHEnforcement Action Header SearchCRMS4_DMEAHSRCH
CRMS4_DUPL_STATUSDuplicate StatusCRMS4_DUPLSTATUS
CRMS4_ERMS_CAT_CTMultilevel Categorization DescriptionCRMS4_ERMSCATCT
CRMS4_ERRO_STATUSError StatusCRMS4_ERROSTATUS
CRMS4_FBIL_STATUSFor Billing StatusCRMS4_FBILSTATUS
CRMS4_GDIS_STATUSGoods Issue StatusCRMS4_GDISSTATUS
CRMS4_KNAR_SEARCHKnowledge Article SearchCRMS4_KNARSEARCH
CRMS4_LEAD_H_SEARCHLead HeaderCRMS4_LEADHSRCH
CRMS4_LEAD_SOURCELead Source DescriptionCRMS4_LEADSOURCE
CRMS4_LEAD_TYPELead Type DescriptionCRMS4_LEADTYPE
CRMS4_LFCY_OPPT_STATUSOpportunity Life Cycle StatusCRMS4_LCOPPTSTAT
CRMS4_LFCY_STATUSLife Cycle StatusCRMS4_LFCYSTATUS
CRMS4_MAGR_A_SRCMaster AgreementCRMS4_MAGRASRCH
CRMS4_MAGR_H_SRCMaster Agreement HeaderCRMS4_MAGRHSRCH
CRMS4_MAGR_I_SRCMaster Agreement ItemsCRMS4_MAGRISRCH
CRMS4_NOTIF_REQ_STATUSStatus to indicate Notification Req/NotCRMS4_NOTREQSTAT
CRMS4_OBJECT_LINKAGE_PREDECESRObject Linkage with CRM Predecessor objectCRMS4_OBJLINKPRE
CRMS4_OBJECT_LINKAGE_SUCCESSORObject Linkage with Successor CRM objects VONACRMS4_OBJLINKSUC
CRMS4_OPEN_STATUSOpen StatusCRMS4_OPENSTATUS
CRMS4_OPPT_A_SRCOpportunity/Lead SearchCRMS4_OPPTASRCH
CRMS4_OPPT_H_SEARCHOpportunity/Lead HeaderCRMS4_OPPTHSRCH
CRMS4_OPPT_IMPOROpportunity Priority/Lead PriorityCRMS4_OPPTIMPOR
CRMS4_OPPT_I_SEARCHOpportunity/Lead ItemCRMS4_OPPTISRCH
CRMS4_OPPT_SEARCHOpportunity/Lead SearchCRMS4_OPPTSEARCH
CRMS4_PREQ_I_SEARCHPayment Request ItemCRMS4_PREQISRCH
CRMS4_PROC_TYPEProcess Type TextCRMS4_PROCTYPE
CRMS4_PSDP_A_SRCSocial Deduction Plan SearchCRMS4_PSDPASRCH
CRMS4_PSDP_H_SEARCHSocial Deduction Plan HeaderCRMS4_PSDPHSRCH
CRMS4_PSDP_I_SEARCHSocial Deduction Plan ItemCRMS4_PSDPISRCH
CRMS4_PSOA_A_SRCSocial ApplicationCRMS4_PSOAASRCH
CRMS4_PSOA_H_SEARCHSocial Application HeaderCRMS4_PSOAHSRCH
CRMS4_PSOA_I_SEARCHSocial Application ItemCRMS4_PSOAISRCH
CRMS4_PSOA_I_U_SEARCHSocial Application Item UnionCRMS4_PSOAIUSRCH
CRMS4_PSSP_A_SRCSocial Service Plan SearchCRMS4_PSSPASRCH
CRMS4_PSSP_H_SEARCHSocial Service Plan HeaderCRMS4_PSSPHSRCH
CRMS4_PSSP_I_SEARCHSocial Service Plan ItemCRMS4_PSSPISRCH
CRMS4_PSSP_SEARCHSocial Service Plan SearchCRMS4_PSSPSRCH
CRMS4_PS_ACTV_STATUSSocial Service Activation StatusCRMS4_PSACTVSTAT
CRMS4_PS_APPR_STATUSSocial Services Approval StatusCRMS4_PSAPPRSTAT
CRMS4_PS_DEC_TYPESocial Services Decision CategoryCRMS4_PSDECITYPE
CRMS4_PS_LFCY_STATUSSocial Services Lifecycle StatusCRMS4_PSLFCYSTAT
CRMS4_PS_REQ_TYPESocial Services Request TypeCRMS4_PSREQTYPE
CRMS4_PS_SDP_CREA_STATUSSocial Deduction Plan Item Creation StatusCRMS4_PSDPCRSTAT
CRMS4_PS_SDP_LFCY_STATUSSocial Deduction Plan Lifecycle StatusCRMS4_PSDPLCSTAT
CRMS4_PS_SDP_RELE_STATUSSocial Deduction Plan Item Release StatusCRMS4_PSDPRLSTAT
CRMS4_PS_SOA_LFCY_STATUSSocial Application Lifecycle StatusCRMS4_PSOALCSTAT
CRMS4_PS_SSP_CREA_STATUSSocial Service Plan Item Creation StatusCRMS4_PSSPCRSTAT
CRMS4_PS_SSP_ENTI_STATUSSocial Service Plan Item Entitled StatusCRMS4_PSSPEDSTAT
CRMS4_PS_SSP_LFCY_STATUSSocial Service Plan Lifecycle StatusCRMS4_PSSPLCSTAT
CRMS4_PS_SSP_REDU_STATUSSocial Service Plan Reduction Decision StatusCRMS4_PSSPRDSTAT
CRMS4_PS_SSP_RELE_STATUSSocial Service Plan Item Release StatusCRMS4_PSSPRLSTAT
CRMS4_PS_SSP_RELM_STATUSRelease Mode of an EntitlementCRMS4_PSSPRMSTAT
CRMS4_PS_SSP_RREQ_STATUSSocial Service Plan Rerun Required StatusCRMS4_PSSPRRSTAT
CRMS4_QUOT_STATUSQuotation StatusCRMS4_QUOTSTATUS
CRMS4_REF_OBJECTReference Object for Service ItemCRMS4_REFOBJ
CRMS4_RELE_STATUSReleased StatusCRMS4_RELESTATUS
CRMS4_SERV_A_SRCServiceCRMS4_SERVASRCH
CRMS4_SERV_H_SEARCHService HeaderCRMS4_SERVHSRCH
CRMS4_SERV_I_SEARCHService ItemsCRMS4_SERVISRCH
CRMS4_SERV_SEARCHServiceCRMS4_SERVSEARCH
CRMS4_SERV_U_SEARCHUnion of Items with Service HeaderCRMS4_SERVUSRCH
CRMS4_SKWG_ATTACHMENTAttachment Availability for Business TxnCRMS4_SKWGATTACH
CRMS4_SKWG_BRELKnowledge Warehouse Links for Srvc DocsCRMS4_SKWGBREL
CRMS4_TECH_RESTechnical ResourcesCRMS4_TECHRES
C_CUSTMGMTSALESORGSETTINGSales Organization SettingCSALESORGSTTG
C_SERVICEDOCUMENTPROCFLOWService Document Process Flow NodeCSRVCDOCPROCFLW
C_TECHOBJSERVICEORDERService order for technical objectCTECHOBJSRVORD
ESH_N_SOLUTIONORDERAnchor view -SOLUTIONORDERESH_L_SOLUORDER
ESH_N_SRVCCONFAnchor view -SRVCCONFESH_L_SRVCCONF
ESH_N_SRVCCONTRAnchor view -SRVCCONTRESH_L_SRVCCONTR
ESH_N_SRVCQTANAnchor view -SRVCQTANESH_L_SRVCQTAN
ESH_N_SRVORDAnchor view -SRVORDESH_L_SRVORD
ESH_S_SOLUTIONORDERSearch view -SOLUTIONORDERESH_U_SOLUORDER
ESH_S_SRVCCONFSearch view -SRVCCONFESH_U_SRVCCONF
ESH_S_SRVCCONTRSearch view -SRVCCONTRESH_U_SRVCCONTR
ESH_S_SRVCQTANSearch view -SRVCQTANESH_U_SRVCQTAN
ESH_S_SRVORDSearch view -SRVORDESH_U_SRVORD
E_ACTIVITYDOCUMENTActivity ExtensionEACTIVITYDOC
E_CUSTMGMTMASTERAGREEMENTMaster Agreement ExtensionECUSTMGMTMAGR
E_CUSTMGMTMSTRAGRMTITEMMaster Agreement Item ExtensionECUSTMGMTMAGRI
E_ENFORCEMENTACTIONEnforcement Action ExtensionEENFORCEMENTACTN
E_KNOWLEDGEARTICLEKnowledge Article ExtensionEKNOWLEDGEARTICL
E_PRESALESDOCUMENTPresales Document ExtensionEPRESALESDOC
E_PRESALESDOCUMENTITEMPresales Document Item ExtensionEPRESALESDOCITEM
E_SERVICEDOCUMENTService Document ExtensionESERVICEDOCUMENT
E_SERVICEDOCUMENTITEMService Document Item ExtensionESERVICEDOCITM
E_SOCIALAPPLICATIONSocial Application ExtensionESOCIALAPPL
E_SOCIALAPPLICATIONITEMSocial Application Item ExtensionESOCIALAPPLITM
E_SOCIALDEDUCTIONPLANSocial Deduction Plan ExtensionESOCIALDEDCTNPLN
E_SOCIALDEDUCTIONPLANITEMSocial Deduction Plan Item ExtensionESOCIALDEDPLNITM
E_SOCIALSERVICEPLANSocial Service Plan ExtensionESOCIALSERVPLAN
E_SOCIALSERVICEPLANITEMSocial Service Plan Item ExtensionESOCIALSRVPLNITM
I_BILLGREQITMSETTLMTSTATUSBilling Request Item Settlement StatusIBILLREQISTLSTAT
I_BILLGREQITMSETTLMTSTATUSTEXTBilling Request Item Settlement Status TextIBILREQISTLSTATX
I_BILLINGREQUESTITEMBillg Request Line for Srvc TransactionIBILLGREQITEM
I_BUSINESSACTIVITYCATEGORYActivity CategoryIBUSACTVCATEGORY
I_BUSINESSACTIVITYCATEGORYTEXTActivity Category - TextIBUSACTVCATETEXT
I_CUSTMGMTBUSOBJTYPEBus Object Type of Service TransactionICUSTMGMTBOTYPE
I_CUSTMGMTBUSOBJTYPETEXTBus Obj Type of Srvc Transaction - TextICUSTMGTBOTYPTXT
I_CUSTMGMTEXTREFIDExternal Reference IDICUSTMGTEXTREFID
I_CUSTMGMTITMBUSOBJTYPEBus Obj Type of Srvc Transaction ItemICUSTMGTITMBOTYP
I_CUSTMGMTITMBUSOBJTYPETEXTBus Obj Type of Srvc Trans Item - TextICSMGITMBOTYPTXT
I_CUSTMGMTPARTNERCustomer Management PartnerICUSTMGMTPARTNER
I_CUSTMGMTPARTNERFUNCTEXTService Document Partner Function TextICUSTPARTFUNCTXT
I_CUSTMGMTSALESORGSETTINGSales Organization SettingI_SALESORGSTTG
I_RESPONSEPROFILEResponse Profile ViewIRSPPRFL
I_RESPONSEPROFILETEXTResponse Profile TextIRSPPRFLTXT
I_SALESORGANIZATIONUNITSales Organizational UnitISALESORGUNIT
I_SALESORGANIZATIONUNITTEXTSales Organizational Unit - TextISALESORGUNITTXT
I_SERVICECANCELLATIONPARTYService Cancellation PartyISRVCCANCPARTY
I_SERVICECANCELLATIONPARTYTEXTText for Service Cancellation PartyISRVCCANCPARTYT
I_SERVICECANCELLATIONREASONService Cancellation ReasonISRVCCANCREASON
I_SERVICECANCLNREASONTEXTText for Service Cancellation ReasonISRVCCANCREASONT
I_SERVICECONTRACTCANCLNSTSService Contract Cancellation StatusISRVCCNTCANCSTS
I_SERVICECONTRACTCANCLNSTSTXTText for Service Contract CancellationISRVCCNTCANCSTST
I_SERVICECONTRACTSTDVHService Contract Value HelpISERVCONTRVH
I_SERVICECONTRACTTYPESTDVHService Contract Type Value HelpISERVCONTRTYPEVH
I_SERVICEDEFECTService DefectISERVICEDEFECT
I_SERVICEDOCBILLINGSTATUSBilling Status of Service TransactionISERVDOCBILLSTAT
I_SERVICEDOCBILLINGSTATUSTEXTBilling Status of Srvc Transaction - TextISERVDOCBILSTATX
I_SERVICEDOCERRORSTATUSError Status of Service TransactionISERVDOCERRSTAT
I_SERVICEDOCERRORSTATUSTEXTError Status of Srvc Transaction - TextISERVDOCERRSTATX
I_SERVICEDOCITEMCATEGORYCategory of Service Transaction ItemISERVDOCITMCAT
I_SERVICEDOCITEMCATEGORYTEXTCategory of Service Transac Item - TextISERVDOCITMCATXT
I_SERVICEDOCITEMTYPESLSSTTGSales Setting for Srvc Trans Item CatISERVDOCITMSLSTG
I_SERVICEDOCOPENSTATUSOpen Status of Service TransactionISERVDOCOPNSTAT
I_SERVICEDOCOPENSTATUSTEXTOpen Status of Srvc Transaction - TextISERVDOCOPNSTATX
I_SERVICEDOCPROBLEMCATEGORYBasic view for service transaction problem categoryISRVCDOCPROBCAT
I_SERVICEDOCRELEASEDFORBILLINGService document released for billingISRVDOCRELDFRBLN
I_SERVICEDOCUMENTService TransactionISERVDOC
I_SERVICEDOCUMENTENHCDService Transaction EnhancedISERVDOCENHCD
I_SERVICEDOCUMENTFIXEDPRICEService Document Fixed PriceISERVDOCFXDPRICE
I_SERVICEDOCUMENTITEMService Transaction ItemISERVDOCITM
I_SERVICEDOCUMENTITEMENHCDService Transaction Item EnhancedISERVDOCITMENHCD
I_SERVICEDOCUMENTITEMPRDCSSRService Document Item PredecessorISERVDOCITMPRE
I_SERVICEDOCUMENTITEMPRDCSSR_2Preceding Transaction of Srvc Trans ItemISERVDOCITMPRE2
I_SERVICEDOCUMENTITEMPRDCSSR_3Preceding Transaction of Srvc Trans ItemISRVCITMPRD3
I_SERVICEDOCUMENTITEMSUCCESSORService Document Item SuccessorISERVDOCITMSUCC
I_SERVICEDOCUMENTITEMSUCCSSR_2Follow-Up Transaction of Srvc Trans ItemISERVDOCITMSUCC2
I_SERVICEDOCUMENTITEMSUCCSSR_3Follow-Up Transaction of Srvc Trans ItemISRVCDOCITMSUCC3
I_SERVICEDOCUMENTPREDECESSORPreceding Service TransactionISERVDOCPRE
I_SERVICEDOCUMENTPRIORITYService Transaction PriorityISERVDOCPRIO
I_SERVICEDOCUMENTPRIORITYTEXTService Transaction Priority - TextISERVDOCPRIOTEXT
I_SERVICEDOCUMENTREFOBJECTReference Object of Service TransactionISERVDOCREFOBJ
I_SERVICEDOCUMENTSTATUSService Transaction StatusISERVDOCSTAT
I_SERVICEDOCUMENTSTATUSTEXTService Transaction Status - TextISERVDOCSTATTEXT
I_SERVICEDOCUMENTSUCCESSORFollow-Up Service TransactionISERVDOCSUCC
I_SERVICEDOCUMENTTYPEService Transaction TypeISERVDOCTYPE
I_SERVICEDOCUMENTTYPESTDVHService Document Type Value HelpISERVDOCTYPEVH
I_SERVICEDOCUMENTTYPETEXTService Transaction Type - TextISERVDOCTYPETEXT
I_SERVICEORDERCONFSTDVHService Confirmation Value HelpISERVORDCONFVH
I_SERVICEORDERSTDVHService Order Value HelpISERVORDVH
I_SERVICEORDERTEMPLATESTDVHService Order Template Value HelpISRVCORDTMPLVH
I_SERVICEORDERTYPEVHService Order Type Value HelpISERVORDTYPEVH
I_SERVICEPRODUCTLISTService Product ListISERVPRODLIST
I_SERVICEPROFILEService Profile ViewISRVCPRFL
I_SERVICEPROFILETEXTService Profile TextISRVCPRFLTXT
I_SERVICERISKBasic view for service riskISERVICERISK
I_SERVICERISKTEXTText view for service riskISRVCRISKTEXT
I_SRVCCONFRELDFORCMPLTBILLGService Conf Reld for Complete BillingISERVCONFRLDCMBL
I_SRVCCONFRELDFORPRTLBILLGPartial Billing Based on Service ConfISERVCONFRLPRTBL
I_SRVCDOCBYDOCUMENTTYPEService Transaction by Transaction TypeISRVCDOCSRCH
I_SRVCDOCDELIVERYSTATUSDelivery Status of Service TransactionISERVDELSTAT
I_SRVCDOCDELIVERYSTATUSTEXTDelivery Status of Srvc Transac - TextISERVDELSTATTXT
I_SRVCDOCESCALATIONEscalation Level of Service TransactionISERVESCSTAT
I_SRVCDOCESCALATIONTEXTEscalation Level of Srvc Transac - TextISERVESCSTATTXT
I_SRVCDOCGOODSISSUESTATUSGoods Issue Status for Srvc TransactionISERVGISTAT
I_SRVCDOCGOODSISSUESTATUSTEXTGoods Issue Status for Srvc Trans - TextISERVGITATTXT
I_SRVCDOCIMPACTImpact of Service DocumentISERVIMPSTAT
I_SRVCDOCIMPACTTEXTText view for Impact of Service DocumentISERVIMPSTATTXT
I_SRVCDOCITEMBYDOCUMENTTYPESrvc Transaction Item by Transac TypeISRVCDOCITMSRCH
I_SRVCDOCPROBLEMCATEGORYTEXTText view for service transaction problem categoryISRVCDOCPCATTXT
I_SRVCDOCQUOTATIONSTATUSQuotation Status of Service TransactionISERVQTNSTAT
I_SRVCDOCQUOTATIONSTATUSTEXTQuotation Status of Srvc Transac - TextISERVQTNSTATTXT
I_SRVCDOCREJECTIONSTATUSRejection Status of Service TransactionISERVREJSTAT
I_SRVCDOCREJECTIONSTATUSTEXTRejection Status of Srvc Transac - TextISERVREJSTATTXT
I_SRVCDOCRELEASESTATUSRelease Status of Service TransactionISERVRELDSTAT
I_SRVCDOCRELEASESTATUSTEXTRelease Status of Srvc Transac - TextISERVRELDSTATTXT
I_SRVCDOCRELFORBILLGSTSRelease for Billing Status of Srvc TransISERVDOCRELBLSTS
I_SRVCDOCRELFORBILLGSTSTEXTRel for Billg Sts of Srvc Trans - TextISERVDOCRELBLSTX
I_SRVCDOCURGENCYUrgency Status of Service DocumentISERVUGRSTAT
I_SRVCDOCURGENCYTEXTText view for Urgency Status of Service DocumentISERVUGRSTATTXT
I_SRVCORDITMCONFRELEVANCEConf Relevance for Related Service OrderISERVCONFRELSTS
I_SRVCORDITMCONFRELEVANCETEXTConf Relevance for Reltd Srvc Ord ΓÇô TextISERVCONFRELSTTX
I_SRVCORDITMRELEASEDFORBILLGService Order Item Released for BillingISERVORDRLSDBLLG
I_SRVCQTANACCEPTANCESTATUSStatus of Service QuotationISERVQNSTAT
I_SRVCQTANACCEPTANCESTATUSTEXTStatus of Service Quotation - TextISERVQNSTATTXT
I_SRVCREFERENCEOBJECTTYPEType of Service Reference ObjectISERVREFOBJTYPE
I_SRVCREFERENCEOBJECTTYPETEXTType of Service Reference Object - TextISERVREFOBJTYPTT
I_TECHOBJSERVICEORDERService order for technical objectITECHOBJSRVORD
P_SERVICEDOCUMENTFIXEDPRICEService Document Fixed PriceISERVDOCFIXPRICE