CDS Views for Public Sector Management (PSM)

CDS View NameDescriptionSQL View Name
C_BUDGETDOCUMENTITEMRECEIVERTPBudget Document Receiver ItemCBDGTDOCITRECVTP
C_BUDGETDOCUMENTITEMSENDERTPBudget Transfer Sender ItemCBDGTDOCITSENDTP
C_BUDGETDOCUMENTTPBudget TransferCBDGTDOCHEADERTP
C_BUDGETINGTYPEVHValue Help for Budgeting TypesCBDGTTYPEVH
C_FISCALYEARFORCOMPANYCODEVHFiscal Year For Company Code Value HelpCFISCALYEARCCVH
C_PUBSECBDGTMGMTAVAILYCTRLSITNPSM Anchor & Trigger Obj. for BMAVC SH CCPUBSECBMAVCSH
I_BUDGETDOCNUMBERSTDVHBudget Document Number Standard Value HelpIBDGTDOCNBR_VH
I_BUDGETDOCUMENTBudget Document headerIBDGTDOCUMENT
I_BUDGETDOCUMENTBASICBudget Document header - basicIBDGTDOCBASIC
I_BUDGETDOCUMENTITEMBudget Document ItemIBDGTDOCITEM
I_BUDGETDOCUMENTITEMBASICBudget document item - basicIBDGTDOCITBASIC
I_BUDGETDOCUMENTITEMRECEIVERTPBudget Document Item -Transactional ViewIBDGTDOCITRECVTP
I_BUDGETDOCUMENTITEMSENDERTPBudget Document Sender ItemIBDGTDOCITSENDTP
I_BUDGETDOCUMENTSTATUSBudget Document StatusIBDGTDOCSTATUS
I_BUDGETDOCUMENTSTATUSTEXTBudget Document Status TextIBDGTDOCSTATUST
I_BUDGETDOCUMENTTPBudget Document header - TransactionalIBDGTDOCHEADERTP
I_BUDGETDOCUMENTTYPEBudget Document TypeIBDGTDOCTYPE
I_BUDGETDOCUMENTTYPETEXTText of a Budget Document TypeIBDGTDOCTYPET
I_BUDGETPLANNINGCATEGORYPlanning Category used During BudgetingIBDGTPLANNINGCAT
I_BUDGETPLANNINGCATEGORYVHSearch Help for Budget Planning CategoryIBDGTPLANCATVH
I_BUDGETPROCESSGROUPBudget Process GroupIBDGTPROCGR
I_BUDGETPROCESSGROUPTEXTBudget Process Group TextIBDGTPROCGRT
I_BUDGETPROCESSTRANSFERBudget Process for TransferIFIBDGTPROCTRANS
I_GLACCOUNTFORPUBLICSECTORFM Settings for GL AccountsIPSMS4CGLACCTX
I_PUBSECBDGTACCTREVNEXPNCODERevenue and Expense Code for Bdgt AcctsIPSMS4CBDREEX
I_PUBSECBDGTACCTREVNEXPNTEXTRevenue and Expense Code - TextIPSMS4CBDREEXT
I_PUBSECBDGTCNSMPNAMTTYPEBudget Consumption Amount TypeIPSMS4CBDCNATY
I_PUBSECBDGTCNSMPNAMTTYPETEXTBudget Consumption Amount Type - TextIPSMS4CBDCNATYT
I_PUBSECBDGTCNSMPNTYPEBudget Consumption TypeIPSMS4CBDCNSTY
I_PUBSECBDGTCNSMPNTYPETEXTBudget Consumption Type - TextIPSMS4CBDCNSTYT
I_PUBSECBDGTMGMTAVAILYCTRLSITNPSM Anchor & Trigger Obj. for BMAVC SH BIPUBSECBMAVCSH
I_PUBSECCTRLOBJBDGTACCOUNTPublic Sector Control Object for a Budget AccountIPUBSECCTRLBA
I_PUBSECCTRLOBJBDGTACCOUNTMAPPublic Sector mapping Control Object for Budget AccountIPUBSECCTRLBAMAP
I_PUBSECCTRLOBJBDGTPERIODPublic Sector Control Object for a Budget PeriodIPUBSECCTRLBP
I_PUBSECCTRLOBJBDGTPERIODMAPPublic Sector mapping Control Object for Budget PeriodIPUBSECCTRLBPMAP
I_PUBSECCTRLOBJCOSTCENTERPublic Sector Control Object for a Cost CenterIPUBSECCTRLCC
I_PUBSECCTRLOBJCOSTCENTERMAPPublic Sector mapping Control Object for Cost CenterIPUBSECCTRLCCMAP
I_PUBSECCTRLOBJFUNCAREAPublic Sector Control Object for a Functional AreaIPUBSECCTRLFA
I_PUBSECCTRLOBJFUNCAREAMAPPublic Sector mapping Control Object for Func. AreaIPUBSECCTRLFAMAP
I_PUBSECCTRLOBJFUNDPublic Sector Control Object for a FundIPUBSECCTRLFU
I_PUBSECCTRLOBJFUNDMAPPublic Sector mapping Control Object for FundIPUBSECCTRLFUMAP
I_PUBSECCTRLOBJPROFILECURDATEPublic Sector AVC Profile to Current DateIPSMS4CAVCPDT
I_PUBSECCTRLOBJWBSELEMENTPublic Sector Control Object for a WBS ElementIPUBSECCTRLWB
I_PUBSECCTRLOBJWBSELEMENTMAPPublic Sector mapping Control Object for WBS ElementIPUBSECCTRLWBMAP
I_PUBSECFLEXIBLEUPDATEDATEPSM: Flexible Update Date by UserIPSMFLXUPDDATE
I_PUBSECHIERARCHYPublic Sector HierarchyIPUBSECHIER
I_PUBSECHIERARCHYTEXTPublic Sector Hierarchy - TextIPUBSECHIERT
I_PUBSECSUBSTNVALDTNCNTXTPublic sector contexts for substitution and validationIPSMSUBVALCNTXT
PSM_AVC_BUDGET_ACCOUNT_BASICBasic Fund View for HierarchyPSMAVCBABASIC
PSM_AVC_BUDGET_ACCOUNT_SOURCEBasic Fund View for HierarchyPSMAVCBASOURCE
PSM_AVC_BUDGET_PERIOD_BASICBasic Fund View for HierarchyPSMAVCBPBASIC
PSM_AVC_BUDGET_PERIOD_SOURCEBasic Fund View for HierarchyPSMAVCBPSOURCE
PSM_AVC_COST_CENTER_BASICBasic Fund View for HierarchyPSMAVCCCBASIC
PSM_AVC_COST_CENTER_SOURCEBasic Fund View for HierarchyPSMAVCCCSOURCE
PSM_AVC_FUNCTIONAL_AREA_BASICBasic Fund View for HierarchyPSMAVCFABASIC
PSM_AVC_FUNCTIONAL_AREA_SOURCEBasic Fund View for HierarchyPSMAVCFASOURCE
PSM_AVC_FUND_BASICBasic Fund View for HierarchyPSMAVCFUBASIC
PSM_AVC_FUND_SOURCEBasic Fund View for HierarchyPSMAVCFUSOURCE
PSM_AVC_WBS_ELEMENT_BASICBasic Fund View for HierarchyPSMAVCWBBASIC
PSM_AVC_WBS_ELEMENT_SOURCEBasic Fund View for HierarchyPSMAVCWBSOURCE
P_ACDOCP_BDGTDOC_ITEMBudget Document Item - private viewPACDOCPBDGTIT
P_PUBSECCTRLOBJPROFILECURDATEPSM AVC Profile to Current DatePPSMS4CAVCPDT
P_PUBSECCTRLOBJPROFILECURDATE1PSM AVC Profile to Current Date (All From Years)PPSMS4CAVCPDT1
P_PUBSECCTRLOBJPROFILECURDATE2PSM AVC Profile to Current Date ( Latest From Year)PPSMS4CAVCPDT2
R_EARMARKEDFUNDSDOCUMENTITEMTPBus Obj Node Earmarked Funds Doc ItemREMRKDFNDSDITMTP
R_EARMARKEDFUNDSDOCUMENTTPBus Obj Earmarked Funds DocumentREMRKDFNDSDOCTP
R_EMRKDFNDSDOCITMMNLREDUCNTPBus Obj Node Emrkd Fnds Doc Mnl ReducnREFDITMMNLREDTP
R_PUBSECFLEXIBLEUPDATEDATETPPSM: Flexible Update Date by UserRPSMFLXUPDDATE