CDS Views for Supplier Data Management (SLC-SUP)

CDS View NameDescriptionSQL View Name
C_EMPLOYEEADDRESSEmployee User ID, Name and Org. InfoCSLCEMPLOYEEADD
C_PURCATCREABYVALUEHELPCreated-By User of Purchasing CategoryCPURCATCREABYVH
C_PURCATSTATUSVALUEHELPStatus of Purchasing CategoryCPURCATSTATUSVH
C_PURCATTARGETLANGVALUEHELPTarget Language of Purchasing CategoryCPURCATTARGETLVH
C_PURCATVALUEHELPPurchasing CategoryCPUCVH
C_PURGCATTRANSLSTSVALUEHELPTranslation Status of Purch. Cat.CPURGCATTSTSVH
C_SLCMGMTSUPPLIERPORTFOLIODisplay SuppliersCSLCSUPLRPRTFLOL
C_SLCQNAIRELIFECYCLESTSVHLifecycle StatusCSLCLIFECYCLEVH
C_SPLRACTYTSKCREABYVALUEHELPCreated-By User of Activity TaskCSPLACTTSKCRBYVH
C_SUPLRACTYEMPLRESPVALUEHELPEmployee Responsible for ActivityCSUPACTYEMPRESVH
C_SUPLRACTYPARTICIPVALUEHELPParticipant of ActivityCACTYPARTVH
C_SUPLRACTYPOTNTLEMPLRESPVHPotential resp.employees for an activityCSUACTPOEMPRSPVH
C_SUPLRACTYPRIOVALUEHELPPriority of ActivityCSUPLRACTPRVH
C_SUPLRACTYSTATVALUEHELPStatus of ActivityCSUPACTSTVH
C_SUPLRACTYSUPLRVALUEHELPSuppliers Affected by ActivityCSUPLRACTYSUPLVH
C_SUPLRACTYTASKVALUEHELPActivity TaskCSUPLRACTYTSKVH
C_SUPLRACTYTSKPRIOVALUEHELPPriority of Activity TaskCSUPLRACTTSKPRVH
C_SUPLRACTYTSKSTATPTVALUEHELPStatus of Activity Task for ParticipantCSUPACTTSKSTPTVH
C_SUPLRACTYTSKSUPLRVALUEHELPSuppliers Affected by TaskCSUPLACTTSKSUPVH
C_SUPLRACTYTYPEVALUEHELPActivity TypeCSUPLRACTYTYVH
C_SUPLRACTYVALUEHELPActivityCSUPLRACTYVH
C_SUPLREVALATTACHMENTSupplier Evaluation AttachmentCSUPLREVALATTCH
C_SUPLREVALRESPONSESupplier Evaluation ResponseCSUPEVALRESPONSE
C_SUPLREVALRESPONSEOPTIONSupplier Evaluation Response OptionCSUPEVALRSPOPT
C_SUPLREVALRESPONSEQNAIRESupplier Evaluation Response QuestionnaireCSUPEVALRSPQNRS
C_SUPLREVALRESPONSEQUESTIONSupplier Evaluation Response QuestionCSUPEVALRSPQST
C_SUPLREVALRESPONSESECTIONSupplier Evaluation Response SectionCSUPLEVARSPSEC
C_SUPPLIERACTIVITYOVPSupplier Activity Overview PageCSUPLRACTYOVP
C_SUPPLIERACTIVITYTASKSEARCHTask (Procurement)CSUPACTTSKSRCH
C_SUPPLIEREVALRESPONSELANGUAGESupplier Evaluation Response LanguageCSUPLEVALRESPLNG
ESH_N_SUPLR_QNAIREAnchor view -SUPLR_QNAIREESH_L_SUPLR_QNR
ESH_S_SUPLR_QNAIRESearch view -SUPLR_QNAIREESH_U_SUPLR_QNR
I_INACTIVESTATUSInactive StatusIINACTIVESTATUS
I_INACTIVESTATUSTEXTInactive Status - TextIINACTIVESTATUST
I_SLCCONSISTENCYSTATUSConsistency StatusISLCCONSSTS
I_SLCCONSISTENCYSTATUSTEXTConsistency Status - TextISLCCONSSTSTEXT
I_SLCCONTACTCARDSLC Contact CardISLCCONTACTCARD
I_SLCMGMTABCCLASSIFICATIONABC ClassificationISLCSABCCLA
I_SLCMGMTABCCLASSIFICATIONTEXTABC Classification - TextISLCSABCCLATXT
I_SLCMGMTQNAIREEXTNAMEAPI01External Name of QuestionnaireISLCQNREXTNAPI01
I_SLCMGMTQNAIREPURGCATAPI01Purchasing Category of QuestionnaireISLCQNRPUCAPI01
I_SLCMGMTQNAIREPURRRESPAPI01Purchaser Responsible for QuestionnaireISLCQNRPURRAPI01
I_SLCMGMTQNAIRETRNSLTNSTSAPI01Translation Status of QuestionnaireISLCQNRTRASAPI01
I_SLCMGMTSTRATEGICIMPORTANCEStrategic ImportanceISLCSIMPRTNC
I_SLCMGMTSTRATEGICIMPRTNCTEXTStrategic Importance - TextISLCSIMPRTNCTXT
I_SLCPARTYIDENTIFIERTYPEParty Identifier TypeISLCPTYIDFRTYPE
I_SLCPARTYIDENTIFIERTYPETEXTParty Identifier Type - TextISLCPTYIDFRTYPET
I_SLCPARTYROLEParty RoleISLCPARTYROLE
I_SLCPARTYROLETEXTParty Role - TextISLCPARTYROLET
I_SLCPARTYTYPEParty TypeISLCPARTYTYPE
I_SLCPARTYTYPETEXTParty Type - TextISLCPARTYTYPET
I_SLCPREFERREDANSWERPreferred AnswerISLCPREFANSWER
I_SLCPREFERREDANSWERTEXTPreferred Answer - TextISLCPREFANSWERT
I_SLCQNAIREQuestionnaireISLCQNAIR
I_SLCQNAIREEXTNAMEExternal Name of QuestionnaireISLCQNAIREXTNAME
I_SLCQNAIRELIFECYCLESTSLifecycle Status of QuestionnaireISLCQNAIRLFS
I_SLCQNAIRELIFECYCLESTSTEXTLifecycle Status of Questionnaire - TextISLCQNAIRLFST
I_SLCQNAIREPARTYParty Referenced in QuestionnaireISLCQNAIRPARTY
I_SLCQNAIREPURCHRESPPurchaser Responsible for QuestionnaireISLCQNAIRPUR
I_SLCQNAIREPURGCATPurchasing Category of QuestionnaireISLCQNAIRPURRESP
I_SLCQNAIRETRANSLATIONSTSQuestionnaire Translation StatusISLCQNAIRTRANSST
I_SLCQNAIREVALUEHELPQuestionnaireISLCQNAIRVH
I_SLCQUESTIONNOTEOPTIONQuestion Note OptionISLCQSTNOTEOPT
I_SLCQUESTIONNOTEOPTIONTEXTQuestion Note Option - TextISLCQSTNOTEOPTT
I_SLCQUESTIONTYPEQuestion TypeISLCQSTTYPE
I_SLCQUESTIONTYPETEXTQuestion Type - TextISLCQSTTYPETEXT
I_SLCTRANSLATIONSTATUSTranslation StatusISLCTRANSLSTS
I_SLCTRANSLATIONSTATUSTEXTTranslation Status - TextISLCTRANSLSTST
I_SLC_SUPPLIERVALUEHELPSupplierISLCSUPLRVH
I_SUPLREVALQUESTIONNAIREAPI01Supplier Evaluation QuestionnaireISLCEVLQNRAPI01
I_SUPPLIERCONTROLDATASupplier Control and Information DataISUPPLIERCONTROL
I_SUPPLIEREVALQUESTIONNAIRESupplier Evaluation QuestionnaireISLCEVALQNAIRE
I_SUPPLIERQUALIFICATIONLVLLevel of Supplier QualificationISUPQUALLVL
I_SUPPLIERQUALIFICATIONLVLTEXTLevel of Supplier Qualification - TextISUPQUALLVLTXT
I_SUPPLIERSUSTAINABILITYDATASupplier Sustainability DataISUPLRSUSTAINAB
P_RSPDISQUALIFYINGQSTCOUNTTotal number of disqualifying Questions in a QuestionnairePRSPDISQLQSTCNT
P_RSPMANDANSWEREDQSTCOUNTNumber of answered mandatory Questions in a QuestionnairePRSPANSMANQSTCNT
P_SLCCONTACTCARDSLC Contact CardPSLCCONTACTCARD
P_SLCPARTIESSLC PartiesPSLCPARTIES
P_SLCTEXTCOLLECTIONSupplier Lifecycle Text CollectionPSLCTXTCOL