CDS Views for Category Management (SLC-CAT)

CDS View NameDescriptionSQL View Name
A_PURGCATPurchasing CategoryAPURGCATRT
A_PURGCATDESCRIPTIONDescriptionAPURGCATDES
A_PURGCATMATERIALGROUPMaterial GroupAPURCATMATLGROUP
A_PURGCATMEMBERTeam MemberAPUCMEMBER
A_PURGCATPLANNEDSPENDPlanned SpendAPURGCATPSP
A_PURGCATPURCHASERRESPONSIBLEPurchaser ResponsibleAPUCPURRESP
A_PURGCATSUPPLIERSupplierAPURGCATSUPPLIER
A_PURGCATTRANSLATIONSTATUSTranslation StatusAPURGCATTRANSST
C_ACTIVITIESBYPURGCATSupplier ActivityCACTIESBYPURGCAT
C_MATERIALGROUPLONGTEXTText of a material groupCMATGROUPLTEXT
C_PURCATFORTRANSVALUEHELPPurchasing Categories to Be TranslatedCPURCATFORTRANVH
C_PURCATLASTCHBYVALUEHELPLast "Changed-By" User of Purch. Cat.CPURCATLSTCHBYVH
C_PURCATPURCHRESPVALUEHELPPurchaser Responsible for Purch. Cat.CPUCPURRESPVH
C_PURCHASINGCATEGORYFSPurchasing CategoryCPURGCATEGORYFS
C_PURCHASINGCATEGORYTRANSTTranslate Purchasing CategoriesCPURCATTRANST
C_PURGCATMATLGROUPMaterial GroupCPURCATMATLGROUP
C_PURGCATPLANSPENDPlanned SpendCPURCATPLANSPEND
C_SUPPLIERBYPURCHASINGCATSupplierCSUPLRBYPURGCAT
C_TRANSPURCATLASTCHANGEDBYVHLast Changed by Value HelpCTPUCLCHANGEDVH
C_TRANSPURGCATTRANSSTSVHTranslation Status of Purchasing CategoriesCTPURGCATTRANSVH
ESH_N_PURG_CATAnchor view -PURG_CATESH_L_PURG_CAT
ESH_S_PURG_CATSearch view -PURG_CATESH_U_PURG_CAT
I_PURCHASINGCATEGORYPurchasing CategoryIPURGCATRT
I_PURCHASINGCATEGORYDESCPurchasing Category DescriptionIPURGCATDES
I_PURCHASINGCATEGORYMATLGROUPPurchasing Category Material GroupIPURCATMATLGROUP
I_PURCHASINGCATEGORYPARTYPurchasing Category PartyIPURGCATPTY
I_PURCHASINGCATEGORYPLANSPENDPurchasing Category Planned SpendIPURGCATPSP
I_PURCHASINGCATEGORYPURCHRESPPurchasing category purchaser responsibleIPUCPURRESP
I_PURCHASINGCATEGORYSUPPLIERPurchasing Category SupplierIPURGCATSUPPLIER
I_PURCHASINGCATEGORYVALUEHELPPurchasing CategoryIPUCVH
I_PURCHASINGCATTRANSLATIONSTSPurchasing Category Translation StatusIPURGCATTRANSST
I_PURGCATAPI01Purchasing CategoryIPUCAPI01
I_PURGCATDESCRIPTIONAPI01Description of Purchasing CategoryIPUCDESCAPI01
I_PURGCATMATERIALGROUPAPI01Material Group for Purchasing CategoryIPUCMATLGRPAPI01
I_PURGCATMEMBERPurchasing Category Team MemberIPUCMEMBER
I_PURGCATMEMBERAPI01Team Member for Purchasing CategoryIPUCMEMBERPI01
I_PURGCATPARTYAPI01Party Referenced by Purchasing CategoryIPUCPARTYAPI01
I_PURGCATPLANSPENDAPI01Planned Spend for Purchasing CategoryIPUCPLSPENDAPI01
I_PURGCATPURCHASERRESPAPI01Purchaser Resp Referenced by Purg CatIPUCPURRESPAPI01
I_PURGCATSUPPLIERAPI01Supplier Referenced by Purg CategoryIPUCSUPLRAPI01
I_PURGCATTRANSLATIONSTSAPI01Translation Status of Purg CategoryIPUCTRSTAPI01
P_ASSIGNEDMATERIALSCOUNTNumber og assigned materials in a MaterialgroupPASSGDMATLCNT
P_DISPLAYCURRENCYDisplay Currency of the Total Amount KPIPDISPLAYCURRENCY
P_DISPLAYCURRENCYMATERIALGROUPDisplay currency used for Material Group related Spends(PUC)PDSPCRCYMATLGRP
P_DISPLAYCURRENCYSUPPLIERDisplay currency for supplier related spendsPDSPCRCYSUPLR
P_MATGROUPSUPPLIERSPENDIDCSpend per Supplier MaterialGroup combination in Disp CrcyPMGRPSUPLRSPNDID
P_MATGRPANNUALSPENDMaterial Group Annual SpendPMATGRPANLSPN
P_MATGRPSUPLRSPENDIDCRESpend per Supplier and Mat. Group restricted by a given datePMGRPSPLRSPNDIDR
P_OPENTASKCOUNTNumber of open Activity Tasks per ActivityPOPENTASKCOUNT
P_PURGCATSUPPLIERINFOSupplier Count Measures at Purchasing CategoryPPCATSUPLRINFO
P_SUPLRACTYTASKCOUNTCounter for Tasks inside of an ActivityPSUPLRACTYTCNT
P_SUPPLIERANNUALSPENDSupplier Spend (last 12 months)PSPLRANNUALSPEND
P_SUPPLIERMATERIALGROUPSPENDSupplier Material Group SpendPSUPLRMGRPSPND
P_SUPPLIERMATERIALGROUPSPEND2Supplier and Material Group Spends with Display CurrenciesPSUPLRMGRPSPND2
P_SUPPLIERSPENDPERMATGROUPSupplier Spend in Display Currency per Material GroupPUPLRSPDMATGRP
P_TASKCOUNTBYSTATUSNumber of tasks per StatusPTASKCNTBYSTATUS
P_TOTALORDERVALUEKPI Total Order Value of Purchasing Category FactsheetPTOTALORDERVALUE
P_TOTALSPENDINDSPCRCYTotal Spend in display currencyPTSPENDINDSPCRCY
P_TOTALTSKCOUNTTotal number of Tasks of an ActivityPTOTALTSKCOUNT