Extraction from sap system by operational data provisioning Table in SAP

• USREXTID_IDM
  Table for Table for Provisioning USREXTID Data from IDM
  Table Type : TRANSP
  Package : SECN
  Module : BC-SEC-SNC
• WCACE
  Table for WCM: Operational Condition <-> Operational Class
  Table Type : TRANSP
  Package : WCM
  Module : PM-WCM
• WCCI
  Table for WCM: Tag <-> (Operational Group, Operational Type; Test Tag)
  Table Type : TRANSP
  Package : WCM
  Module : PM-WCM

• ODQDATA_F
  Table for Operational Delta Queue: Data Storage for One-Off Extraction
  Table Type : TRANSP
  Package : SODQS
  Module : BC-BW-SRV
• GRACBUSROLEPROV
  Table for Table to store busniess role provisioning information
  Table Type : TRANSP
  Package : GRAC_ROLE_MANAGEMENT
  Module : GRC-AC
• GRACENVIRONMENT
  Table for Provisioning Environment
  Table Type : TRANSP
  Package : GRAC_ACCESS_REQUEST
  Module : GRC-AC
• GRACNUMRANGE
  Table for Number Range for Compliant User Provisioning requests
  Table Type : TRANSP
  Package : GRAC_ACCESS_REQUEST
  Module : GRC-AC
• GRACPROVCONFIG
  Table for Provisioning configuration
  Table Type : TRANSP
  Package : GRAC_ACCESS_REQUEST
  Module : GRC-AC
• IWP_DP_AP_LS
  Table for Audit Package Level Load Status in provisioning layer
  Table Type : TRANSP
  Package : IWP_DATA_PROVISIONING
  Module : CA-GTF
• ESH_EX_EXTP
  Table for Extraction Profiles for Application Data Extraction
  Table Type : TRANSP
  Package : S_ESH_ENG_EXTRACTION
  Module : BC-EIM-ESH
• ESH_EX_ZEXTP
  Table for Customer Extraction Profiles for ESH Data Extraction
  Table Type : TRANSP
  Package : S_ESH_ENG_EXTRACTION
  Module : BC-EIM-ESH
• TFKBWD01
  Table for FICA to BW Extraction - Extraction Type Definition
  Table Type : TRANSP
  Package : FKKBW
  Module : FI-CA

• TCACS_BUSOBJ
  Table for Valid Business Objects of Operational System (incl.BOR Assg)
  Table Type : TRANSP
  Package : CACSDD
  Module : ICM
• TCACS_BUSOBJ_T
  Table for Allowed Business Objects Operational System (incl.BOR Assg)
  Table Type : TRANSP
  Package : CACSDD
  Module : ICM
• WRFT_APC_MSG
  Table for Operational APC: Settings for System Messages
  Table Type : TRANSP
  Package : WRF_APC
  Module : LO-MD-RA
• FIP_C_BI_SYSTEM
  Table for Logical System for BI Data Extraction
  Table Type : TRANSP
  Package : FIP_DDIC
  Module : MM-PUR-FIP
• BUT_HIER_BW
  Table for SAP BP: Hierarchy Extraction
  Table Type : TRANSP
  Package : BUPA_HIERARCHY_BW
  Module : AP-MD-BP
• CRMC_BUT_HIER_BW
  Table for SAP BP: Hierarchy Extraction
  Table Type : TRANSP
  Package : CRM_BUPA_EXT
  Module : CRM-MD-BP
• FDM_ESYS_MIRROR
  Table for Original Systems (SAP or Non-SAP System)
  Table Type : TRANSP
  Package : FDM_AR_COLL_MIRROR
  Module : FIN-FSCM-COL-AR
• ESH_OM_AOTYPNA
  Table for Object Types: Nodes: Operational Data Providers
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH
• ESH_OM_AOTYPNAF
  Table for Object Types: Nodes: Operational Data Providers: Fields
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH
• ESH_OM_AOTYPNAT
  Table for Object Types: Nodes: Operational Data Providers: Description
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH
• ESH_OM_COTYPNA
  Table for Object Types: Nodes: Operational Data Providers
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH
• ESH_OM_COTYPNAF
  Table for Object Types: Nodes: Operational Data Providers: Fields
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH

• ESH_OM_COTYPNAT
  Table for Object Types: Nodes: Operational Data Providers: Description
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP_LANG
  Module : BC-EIM-ESH
• ESH_OM_IOTYPNA
  Table for Object Types: Nodes: Operational Data Providers
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH
• ESH_OM_IOTYPNAF
  Table for Object Types: Nodes: Operational Data Providers: Fields
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH
• ESH_OM_IOTYPNAT
  Table for Object Types: Nodes: Operational Data Providers: Description
  Table Type : TRANSP
  Package : S_ESH_ENG_OBJ_MOD_REP
  Module : BC-EIM-ESH
• ODQDATA
  Table for Operational Delta Queue: Data Store for Delta
  Table Type : TRANSP
  Package : SODQS
  Module : BC-BW-SRV
• ODQDATA_C
  Table for Operational Delta Queue: Data Storage for Delta Init.
  Table Type : TRANSP
  Package : SODQS
  Module : BC-BW-SRV
• RSODP
  Table for Operational Data Provider: Header
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSODPACTIVEVERS
  Table for Operational Data Provider: Active Versions of Indexes
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSODPLOAD
  Table for Operational Data Provider: Loading
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSODPLOADSEL
  Table for Operational Data Provider: Load Selections
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSODPQUERYSEL
  Table for Operational Data Provider: Query Selections
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSODPSEL
  Table for Operational Data Provider: Query and Load Selections
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSODPSELHASH
  Table for Operational Data Provider: Hashed Query Selections
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSODPSTAT
  Table for Operational Data Provider: Status
  Table Type : TRANSP
  Package : RSODP
  Module : BW-WHM-DST
• RSTSIDOC
  Table for IDoc Operational Data Store for the transfer structure
  Table Type : TRANSP
  Package : RSAR
  Module : BW-WHM-DST
• RSTSIDOCFIELD
  Table for Fields for the IDoc Operational Data Store
  Table Type : TRANSP
  Package : RSAR
  Module : BW-WHM-DST
• RSTSODS
  Table for Operational Data Store for the transfer structure
  Table Type : TRANSP
  Package : RSAR
  Module : BW-WHM-DST
• RSTSODSFIELD
  Table for Fields for the Operational Data Store
  Table Type : TRANSP
  Package : RSAR
  Module : BW-WHM-DST
• WCAMC
  Table for WCM: Log of Operational Lists (Header Data)
  Table Type : TRANSP
  Package : WCM
  Module : PM-WCM
• /RPM/BUCKET_D
  Table for Operational bucket persisted data
  Table Type : TRANSP
  Package : /RPM/OBJECTS
  Module : PPM-PFM
• /RPM/BUCKET_D_DR
  Table for Operational derrived bucket persisted data
  Table Type : TRANSP
  Package : /RPM/OBJECTS
  Module : PPM-PFM
• /RPM/ITEM_D
  Table for Operational item persisted data
  Table Type : TRANSP
  Package : /RPM/OBJECTS
  Module : PPM-PFM
• /RPM/ITEM_H
  Table for Operational item persisted data
  Table Type : TRANSP
  Package : /RPM/OBJECTS
  Module : PPM-PFM
• /RPM/PORTFOLIO_D
  Table for Portfolio Operational persisted data
  Table Type : TRANSP
  Package : /RPM/OBJECTS
  Module : PPM-PFM
• BIW_PS_DELTA
  Table for Admin. Data for Delta Extraction of Master Data
  Table Type : TRANSP
  Package : KAP8
  Module : PS-IS
• HRFPM_BPREP_DATA
  Table for Preprocesses Data for BPREP Data Extraction
  Table Type : TRANSP
  Package : PAOC_FPM_COM_ENGINE
  Module : PA-PM-PB
• RSBPGMGEN
  Table for Generated routines for data extraction for data marts.
  Table Type : TRANSP
  Package : RSB
  Module : BW-WHM-DBA
• BWTRIG_EXSTAT_KK
  Table Data element for Status of Extraction for BI Extraction Order
• /SAPTRX/EXTRACTION_INDEX
  Table Data element for Extraction Index for Extraction Field
• DNOT_SYSID
  Table Data element for SAP System, Name of SAP System
• FDM_EXT_SYSTEM
  Table Data element for ID of an Original System (SAP or Non-SAP System)
• GRAC_PROV_ALLOW
  Table Data element for Provisioning Allowed
• GRAC_PROV_ITEM_NAME
  Table Data element for Provisioning Item Name
• GRAC_ROLE_PROVISIONING
  Table Data element for Provisioning Action Type for Technical role in a Business Ro
• GRAC_MANUAL_PROV
  Table Data element for Grac flag for manual provisioning
• GRAC_MANUAL_PROV_OPTION
  Table Data element for Allow Manual Provisioning
• GRAC_AUTO_PROV_TYPE
  Table Data element for Auto Provisioning Type
• GRAC_INDRCT_PROV_TYPE
  Table Data element for Indirect Provisioning Type
• GRAC_ROLE_PROV_TYPE
  Table Data element for Role Provisioning Type

Extraction from sap system by operational data provisioning related terms

Definitions

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.