How to extract data from sap ecc Table in SAP

• FMFG_REPOST_CNTL
  Table for Document batching/control for SL Repost for ECC 600 migratio
  Table Type : TRANSP
  Package : FMFG_E
  Module : PSM-FM
• FMFG_REPOST_ERR
  Table for Errors issued during SL repost for ECC 600 migration
  Table Type : TRANSP
  Package : FMFG_E
  Module : PSM-FM
• FMFG_REPOST_RCLR
  Table for Reversed clearing documents for ECC 600 migration
  Table Type : TRANSP
  Package : FMFG_E
  Module : PSM-FM

• COAT_E_TY_T
  Table for COAT: Extract Text Table to Extract Types
  Table Type : TRANSP
  Package : BBTE
  Module : CA-GTF-TS-BRHF
• DFKKGP_SHORT
  Table for Data Extract: BP Data
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• FKK_GPSHAD
  Table for Data Extract: Business Partner Data (Faster Access)
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• AMATR
  Table for Global Performance Analysis: Extract Data (Attribute View)
  Table Type : TRANSP
  Package : S_PERF_TRA
  Module : BC-TWB-TST-P-GPA
• AMATRT
  Table for Global Performance Analysis: Extract Data Attribut Texts
  Table Type : TRANSP
  Package : S_PERF_TRA
  Module : BC-TWB-TST-P-GPA
• CNVMBTDEXACTIONS
  Table for DMIS PCL Data Extract Action history
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXCVERS
  Table for DMIS PCL Data Extract - source system information from CVE
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXDEFAULT
  Table for DMIS PCL Data Extract - Default values for system
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXFILES
  Table for DMIS PCL Data Extract Files
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR

• CNVMBTDEXFILSTAT
  Table for DMIS PCL Status of Data Extract Files
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXHEAD
  Table for DMIS PCL Data Extract Header information
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXHEADA
  Table for DMIS PCL Data Extract Header Attributes
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXNUM
  Table for DMIS PCL Data Extract number level
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXTYPE
  Table for DMIS PCL Data Extract Types
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXTYPEDEF
  Table for DMIS PCL Data Extract Types - Definition of elements
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• CNVMBTDEXTYPET
  Table for DMIS PCL Data Extract Types - Texts
  Table Type : TRANSP
  Package : CNV_MBT_MAIN
  Module : CA-EUR
• COAT_E_DATA
  Table for COAT: Extract Data
  Table Type : TRANSP
  Package : BBTE
  Module : CA-GTF-TS-BRHF
• DFKKCUST_SHORT
  Table for Data Extract: Customizing
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• ERCHC_SHORT
  Table for Invoicing / Reversal History ERCH - Extract Data -
  Table Type : TRANSP
  Package : EE20
  Module : IS-U-BI
• ERCH_RIVA
  Table for Header Data for Billing Document Extract (RIVA)
  Table Type : TRANSP
  Package : EE20
  Module : IS-U-BI
• ERCH_SHORT
  Table for Header Data for Billing Document - Extract
  Table Type : TRANSP
  Package : EE20
  Module : IS-U-BI

• ERDK_SHORT
  Table for Header Data for Print Document - Extract
  Table Type : TRANSP
  Package : EE22
  Module : IS-U-IN
• ERDZ_SHORT
  Table for Internal Table for Individual Print Doc.Lines -Extract Data
  Table Type : TRANSP
  Package : EE22
  Module : IS-U-IN
• J_2IEXTRCT
  Table for Data Extract table for Excise Registers
  Table Type : TRANSP
  Package : J2IN
  Module : FI-LOC
• OIO_MX_FLOW
  Table for RLM tracking extract flow data
  Table Type : TRANSP
  Package : OIO
  Module : IS-OIL-OLM
• OIO_MX_OBJECT
  Table for RLM tracking extract object data
  Table Type : TRANSP
  Package : OIO
  Module : IS-OIL-OLM
• OIUREP_XTRCT_ROY
  Table for Extract Royaty Data for the current reporting period
  Table Type : TRANSP
  Package : OIU_REP
  Module : IS-OIL-PRA-REP-ROY
• PTDW_ACTR_DB
  Table for Time Data Extract (Receiver Objects/Activity Allocation)
  Table Type : TRANSP
  Package : PTDW
  Module : PT
• PTDW_ACTS_DB
  Table for Time Data Extract (Sender Objects/Activity Allocation)
  Table Type : TRANSP
  Package : PTDW
  Module : PT
• PTDW_COST_DB
  Table for Time Data Extract (Account Assgnmnt Objects/Cost Assignment)
  Table Type : TRANSP
  Package : PTDW
  Module : PT
• PTDW_PWS_DB
  Table for Time Data Extract (Hours from Personal Work Schedule)
  Table Type : TRANSP
  Package : PTDW
  Module : PT
• PTDW_QUOT_DB
  Table for Time Data Extract (Quota Transaction)
  Table Type : TRANSP
  Package : PTDW
  Module : PT
• PTDW_TIMES_DB
  Table for Time Data Extract (Working Times)
  Table Type : TRANSP
  Package : PTDW
  Module : PT
• PTDW_WPBP_DB
  Table for Time Data Extract (Reference Table for IT 0001 and 0007)
  Table Type : TRANSP
  Package : PTDW
  Module : PT
• T811ED
  Table for Allocations: Extract Generation Data
  Table Type : TRANSP
  Package : KALC
  Module : CRM
• TINV_EXTR_HDR
  Table for Extract of Bill Receipt Document: Admin. Data (Eval. System)
  Table Type : TRANSP
  Package : EE_DEREG_INV
  Module : IS-U-IDE
• TINV_TRNSF_SHORT
  Table for Extract of Bill Receipt (Eval. System): FI-CA Transfer Data
  Table Type : TRANSP
  Package : EE_DEREG_INV
  Module : IS-U-IDE
• TMCEXEVE
  Table for LO Data Extraction: Events/Extract Structures
  Table Type : TRANSP
  Package : MCEX
  Module : LO-LIS
• UGR31022
  Table for FIN Master Data: Buffer Table f.Fields of Extract Structures
  Table Type : TRANSP
  Package : UGMD7
  Module : FIN-FB
• BEACT_ETY
  Table for Customizing of Extract Types: Texts
  Table Type : TRANSP
  Package : BEA_BASICS_S
  Module : CRM-RB
• BEAC_ETY
  Table for Customizing of Extract Types
  Table Type : TRANSP
  Package : BEA_BASICS_S
  Module : CRM-RB
• BEAC_ETY_DET
  Table for Extract Type Determination
  Table Type : TRANSP
  Package : BEA_ETY_DET
  Module : CRM-RB
• BEAC_ETY_PRC
  Table for Customizing of Extract Type - Pricing
  Table Type : TRANSP
  Package : BEA_PRC
  Module : CRM-BE
• BEAC_ETY_R1
  Table for Customizing of Extract Types
  Table Type : TRANSP
  Package : BEA_CLASS_R1
  Module : CRM-RB
• CMSD_CNT_BP_XT
  Table for Contract Partner(s) Extract
  Table Type : TRANSP
  Package : CMS_EXTRACTS
  Module : CRM-CHM-POS
• CMSD_CNT_HDR_XT
  Table for Contract Header Extract
  Table Type : TRANSP
  Package : CMS_EXTRACTS
  Module : CRM-CHM-POS
• CMSD_CNT_PPRC_XT
  Table for Contract Prices extract
  Table Type : TRANSP
  Package : CMS_EXTRACTS
  Module : CRM-CHM-POS
• CMSD_CNT_PRD_XT
  Table for Contract Product Extract
  Table Type : TRANSP
  Package : CMS_EXTRACTS
  Module : CRM-CHM-POS
• COMT_ORGMAN_REPLACE_DIVISION
  Table Data element for SAP ECC Dummy Division
• CRMT_BUAG_NO_REPLICATION
  Table Data element for No Replication to SAP ECC (ERP Central Component)
• CRMT_R3_SALES_ORG
  Table Data element for SAP ECC Sales Organization
• CRMT_R3_SALES_OFFICE
  Table Data element for SAP ECC Sales Office
• CRMT_R3_SALES_GROUP
  Table Data element for SAP ECC Sales Group
• OIO_MT_MTXUS
  Table Data element for Tracking extract user (blank for system extract)
• FMFG_REPOST_CHAIN_ID
  Table Data element for Chain ID for ECC 600 migration repost control
• FMFG_REPOST_PROC_FLAG
  Table Data element for Indicator: Repost this doc for ECC 600 migration?
• J_1IEXCD
  Table Data element for ECC Number
• LVS_VORGK
  Table Data element for WMS Activity Key for ECC - R/2 Linkage
• T323PPROFH
  Table Data element for Logging Error During R/2 - ECC Link
• LVS_LVSDZ
  Table Data element for Indicator: Warehouse Number as Decentralized ECC LVS

How to extract data from sap ecc 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.