SAP Business Planning and Simulation Tables

Are you looking for the right table related to SAP Business Planning and Simulation Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Business Planning and Simulation (BW-PLA-BPS) module.

Top 10 tables in Business Planning and Simulation

TableDescription
UPF_PARAMPlanning Functions: Parameterization
UPC_OPTIOSPlanning: Conditions for Fields
UPB_PM_POFO_PROPCustomizing of Portfolio Graphics
BDSPHRI12BDS: Incoming Relationships of Physical Information Objects
UPC_AREA_MDKey Date for Master Data
UPC_DATASLICEData Slices
UPC_DISPATCHERTDispatcher in SEM-BPS - Text Table for Fcodes
BDSPHPR12BDS: Attributes of Physical Information Objects
UPC_APPLTApplications: Name
UPB_PM_DETAILTechnical Detail Settings of Folder

List of tables in Business Planning and Simulation

TableDescription
UPF_PARAMPlanning Functions: Parameterization
UPC_OPTIOSPlanning: Conditions for Fields
UPB_PM_POFO_PROPCustomizing of Portfolio Graphics
BDSPHRI12BDS: Incoming Relationships of Physical Information Objects
UPC_AREA_MDKey Date for Master Data
UPC_DATASLICEData Slices
UPC_DISPATCHERTDispatcher in SEM-BPS - Text Table for Fcodes
BDSPHPR12BDS: Attributes of Physical Information Objects
UPC_APPLTApplications: Name
UPB_PM_DETAILTechnical Detail Settings of Folder
UPC_KYFPROProperties of a Characteristic
UPB_PM_POFO_XMLCustomizing of Portfolio Graphics
UPC_FLDDSFields for Relations between Characteristics
UPC_AREAMMulti-Planning Areas
BDSPHF12BDS: Files of Physical Information Objects
BDSLOIO31BDS: Instances of Logical Information Objects
UPX_CUST_STEPCustomizing Framework: Steps
UPC_VAR_CHAVariables - Characteristics
UPC_VAR_EXITVariables
UPF_PARAMTPlanning Functions: Parameterizations
UPF_EXITPPlanning: Data Elements - Exits
UPF_PLNTPTPlanning Functions: Text Texts
UPC_BW_AREAPlanning Areas of the BW Application
UPF_BUNDLEBundle of Planning Functions
UPP_SPREADSPlanning: Spreadsheet Customizing
UPB_PS_NAME_TText Table of Planning Books
BDSCHKO31BDS: Check out Data for a Physical Information Object
UPC_GREPOBSDirectory of Obsolete Generated Reports for Plan. Func./Proc
UPB_PM_LEGENDEPlanning Folders: Legend
UPS_LOCKSLock Table for Status and Tracking System
UPS_STATUSMaster Data Table Status
BDSCHKO12BDS: Checkout Data for a Physical Information Object
UPF_GRP_PLNTPTypes of Planning Functions - Planning Functions
UPS_NAME_RESOLVETable of Permitted Applications for Name Resolve
UPC_CHAPROProperties of a Characteristic
UPF_TPGRPTypes of Planning Functions
UPC_AREAPlanning Areas
UPC_TRACE_LOGTrace Log
BDSPHHR12BDS: Outgoing Hyperlinks from Physical Objects
UPC_STEPSRelations between Characteristics of a Planning Area
UPC_PROFILE_BUPlanning Profiles - Planning Sequences
BDSLORI12BDS: Incoming Relationships of Logical Information Objects
UPC_VAR_HIEVariables - Hierarchies
UPX_SLC_SPREADLead Columns: Distribution Techniques
UPC_VAR_CHA_ACTVariables - Restricted Values
UPB_IA_SUBCLTPlanning Applications: Subclass - Text Table
UPC_AREA_DISPDispatcher of Sub-applications from Planning Area
UPS_HASHConnection Hierarchy Key/Hash
UPP_PARAMPlanning: Parameterization (Layouts)
UPC_GREPCATDirectory of Generated Reports (Plan. Func. & Plan. Process
UPX_KFS_CKFKey Figure Schemes for Planning Layouts: Calculated Key Figs
UPC_DARK2Control for Hidden Functions
UPX_LAYOUTEnhanced Planning Layouts: Main Table
UPX_LAYOUT_OFFBDOC: Offline Versions of the Layouts
BDSCHKF31BDS: File Name for Last Check-Out
UPC_STATISTIC3Statistic for Executing Planning Functions
UPWB_MDATATText Table for UPWB_MDATA
UPC_DISPATCHERDispatcher in SEM-BPS
UPC_STATISTICStatistic for Executing Planning Functions
UPS_HEADERHeader Selections for STS
UPWB_TEMPLATESTemplates to Genererate BSP Applications
UPX_GUIDTEXTUPX: Text Table for All GUIDs
BDSCONT12BDS: Table for Document Contents (Import/Export)
UPP_ELEMTPlanning: Column Elements Texts
UPWB_WEBAPPSTText Table for UPWB_WEBAPPS
UPC_PACKAGETPlanning Packages - Text Table
UPX_KPI_EVALBUFKPI Valuation for Alert: Result Buffer
UPB_PM_SETTINGSPlanning Folders: Technical Settings of All Folders
UPC_PROFILE_VARPlanning Profiles - Variables
BDSPHIO12BDS: Instances of Physical Information Objects
UPC_DARKControl for Hidden Functions
UPC_CHADEPCompoundend Values
UPX_CUST_STEP_TCustomizing Framework: Steps - Text Table
UPC_PACKAGEPlanning Packages
BDSPHRE31BDS: Outgoing Relationships of Physical Information Objects
UPC_PROFILE_MEPlanning Profiles - Functions
BDSREPR12BDS: Relationship Attributes
UPC_TYPETText Tables with Texts for the Types of Planning Objects
UPC_VAR_CHADEPAVariables - Selections using Hierarchies
UPX_KFS_PARAMFunction Parameters
UPB_IA_SUBCLPlanning Applications: Subclass
UPWB_WEBAPPSCurrent Web Applications
UPC_APPLApplications in SEM-BPS
UPX_CUST_FCTRY_TCustomizing Framework: Factories - Text Tables
UPX_DSRC_CHANMUPX: Data Sources - Header
UPS_EVENTSTable for Event Coupling in Planning Session
UPF_PARGDParameterization - GUIDs
UPX_SLC_MAINConfiguration of Lead Columns
UPC_VAR_HIE_SELAVariables - Selections using Hierarchies (Active Values)
BDSRE31BDS: Relationship Instances
UPC_PLEVELPlanning Levels
UPX_KFS_LKFKey Figure Schemes for Planning Layouts: Layout Key Figures
UPX_CHGROUP_GENGeneration of Characteristic Sequence
UPS_VERSION_TText Table for UPS_VERSION
BDSLOPR31BDS: Attribute Values of Logical Information Objects
UPP_ELEMPlanning: Column Elements
BDSPHRI31BDS: Incoming Relationships of Physical Information Objects
UPC_TRACE_LOG1Trace Log: Function Module Calls
UPF_PFLDSPlanning: Planning Functions - Fields
BDSLORE31BDS: Outgoing Relationships of Logical Information Objects
UPF_TPGRPTTypes of Planning Functions
UPS_SUBSTITUTETable for Substitute Concept
UPB_MAIN_PROFILEPlanning Profiles of Planning Applications
UPC_DATASLICETData Slices
BDSREPR31BDS: Relationship Attributes
UPB_SPFIEBalance Sheet Planning: Fields with Special Semantics
UPWB_DEBUG_USERUsers, that have debugging enabled
UPC_PROFILEPlanning Profiles
BDSLORE12BDS: Outgoing Relationships of Logical Information Objects
UPB_PS_DESIGN_TText Table of Planning Objects
UPX_HEADKey Figure Schemes for Planning Layouts: General Fields
UPC_NODESHierarchy Node
UPS_TEILPLAN_TText Table for UPS_TEILPLAN
BDSLOIO12BDS: Instances of Logical Information Objects
UPWB_TEMPLATES2Templates to Genererate BSP Applications
UPF_PLANFPlanning Functions
UPWB_PROPINFOAssignment of Info Texts to Properties
UPX_KFS_COMMONKey Figure Schemes for Planning Layouts: General Fields
UPS_TP_HIERARCHYConnection Subplan-Hierarchy
UPX_VARIABLEUPX: Variable Assignment to Sales Planning
UPX_RESP_SRC_VARUPX: Data Sources - Header
UPX_PLTASKSettings for Planning Task
UPP_CHARPlanning: Characteristics
UPC_PROFILE_ARPlanning Profiles - Areas
UPX_STATUSTUPX: Permitted Statuses - Text Table
UPX_VERSIONUPX: Settings Specific to Sales Planning for 0VERSION
UPS_CHANGELOGChange Log for Status
UPC_VAR_CHA_SELVariables - Selections
BDSPHRE12BDS: Outgoing Relationships of Physical Information Objects
UPC_CONVERSIONTechnical Table for Conversion
UPX_KFS_SHIFTKey Figure Schemes for Planning Layouts: Relative Addresses
UPF_BUNDLETBundle of Parameter Groups - Text Table
UPS_NAME_RES_TText Table for Name Resolve
BDSLOPR12BDS: Attribute Values of Logical Information Objects
UPWB_MDATAMaster Data Web Interface
UPWB_THEMES_MAPTemplates to Genererate BSP Applications
UPWB_PROFILEUser-Specific Settings / Not Transported
UPC_PROFILETPlanning Profiles - Text Table
UPWB_CLASSESTTable of Class Descriptors
UPC_AREA_GENSTATGeneration Status of a Planning Area
UPP_DOCPlanning: Layout Builder Info about Document
UPC_VARVariables
UPP_ATRPlanning: Attributes in Lead Columns
UPX_CLUSTERCluster Table for Sales Planning
UPC_PLEVELTPlanning Levels - Text Table
BDSPHNM31BDS: Use of Target Anchors in Physical Objects
UPF_PLNTPPlanning Functions: Types
UPS_ATTRIBUTAttributes for Planning Session
UPC_CHACMPProperties of a Characteristic
UPS_CUSTTEXTCustomer-Defined Mail Texts
UPC_DISPATCHERNDispatcher in SEM-BPS
UPX_SLC_TIMETime Characteristics
UPWB_DEBUG_LOGLog DB for Debugging at Runtime
UPWB_HIERARCHYTable of Class Hierarchy
UPC_PROFILE_PLPlanning Profiles - Planning Levels
UPB_PS_PROPAttributes of Planning Objects
UPC_PROFILE_PAPlanning Profiles - Packages
UPWB_CLASS_ICONSTable of Class Icons
UPS_STATUS_TText Table on UPS_STATUS
UPC_VARIABLETVariables - Text Table
UPC_VAR_ATTRVariables - Attributes
UPC_VAR_HIE_SELVariables - Selections using Hierarchies
UPWB_TRACE_USERUser with Activated Trace
UPX_HEAD_TEXTTexts for Key Figure Schemes
BDSPHHR31BDS: Outgoing Hyperlinks from Physical Objects
UPX_KFS_TEXTTexts for Key Figure Schemes
UPC_STATISTIC2SEM-BPS Statistics with Hierarchical Storage
UPWB_CLASSESTable of Class Descriptors
BDSPHPR31BDS: Attributes of Physical Information Objects
UPC_NEVALPlanning Functions: New Values
UPC_FIXED_METHODPlanning Functions
UPB_AREA_ATRBalance Sheet Planning: Attributes of Application on Area
UPF_BSTEPSBundle Steps: Parameter Groups
UPC_TRACE_USERUser with Activated Trace
UPB_PM_VARIABLEVariables of Planning Folders
UPC_FORMLPlanning Functions: Formulas
UPC_MULTIAREAMulti-Planning Areas
UPX_CUST_FCTRYCustomizing Framework: Factories
BDS_CONN22BDS: Link Table Default for Undefined Classes
UPWB_DATAData in XML Format of BSP Applications
UPF_PLANFTPlanning Functions: Significance
BDSLOIOT31BDS: Descriptions of Logical Information Objects
UPX_CUST_APPCustomizing Framework: Applications
UPS_REALIGNLogging of Hierarchy Conversions as of 3.5
UPWB_TRACE_LOGTrace log
UPC_AREATPlanning Areas - Text Table
UPB_PM_APPLCApplication-Specific Attributes in Planning Folders
UPB_PM_GRAPHGraphic Settings for POBs of a Planning Folder
UPC_VARIABLEVariables - Old Version of Database (New is UPC_VAR)
UPC_PROFILE_PSPlanning Profiles - Parameter Settings
UPB_PM_EXE_TYPETPlanning Folder Variants, Texts
UPWB_TRACE_LOG1Trace Log: Function Module Calls
UPB_PM_LEGENDETPlanning Folders: Legend
BDSCHKF12BDS: File Name at Last Checkout
UPC_TRACE_DATATrace Data
UPC_VAR_CHADEPVariables - Selections using Hierarchies
UPX_CHANMGROUPIUPX: Characteristic Groups - Items
UPX_DSRC_HEADUPX: Data Sources - Header
UPX_SLC_TEXTConfiguration of Lead Columns: Text Table
UPC_BW_TIMEREFAssignment Time Characteristic - Time Reference
UPS_TEILPLANSubplan for Status and Tracking System
BDSPHF31BDS: Files of Physical Information Objects
BDSLOIOT12BDS: Descriptions of Logical Information Objects
UPX_EVAL_BPSKPI Valuation for Alert
BDSPHNM12BDS: Use of Target Anchors in Physical Objects
UPB_PS_NAMEBalance Sheet Planning Interfaces
UPX_CUST_APP_TCustomizing Framework: Applications - Text Table
UPP_PARAMTPlanning: Parameter Group Texts
BDS_CONN31BDS: Link Table Default for Undefined Classes
BDSPHIO31BDS: Instances of Physical Information Objects
UPX_CHANMGROUPUPX: Characteristic Groups - Header
UPX_STATUS_DATAUPX: Status of the LaunchPad Item
BDSLORI31BDS: Incoming Relationships of Logical Information Objects
UPS_VERSIONVersions/Session for Status Tracking
UPB_PS_DESIGNStructure of Planning Interfaces
UPX_KPI_APPUPX_KPI_APP
UPX_STATUSUPX: Permitted Statuses
UPX_CUST_CONSTRCustomizing Components Constraints
UPS_LINKSLinks to Org. Values
UPB_PM_EXE_TYPESPlanning Folder Variants
UPX_GENERALUPX: Settings Specific to Sales Planning
UPX_EXEC_GWHOSTValuate GWHost Default
BDSCONT31BDS: Table for Document Contents (Import/Export)
UPS_TP_AREAConnection Subplan-Area
BDSRE12BDS: Relationship Instances
UPB_PM_GRAPH_TYTText Table for Graphical Display Types
UPC_VAR_NUM_SELVariables - Numeric Selections
UPX_UNITSUnit Assignment
UPB_PM_GRAPH_TYPDisplay Possibilities of Graphical Output