How to extract customer master data Table in SAP

• COAT_E_TY_T
  Table for COAT: Extract Text Table to Extract Types
  Table Type : TRANSP
  Package : BBTE
  Module : CA-GTF-TS-BRHF
• UGR31022
  Table for FIN Master Data: Buffer Table f.Fields of Extract Structures
  Table Type : TRANSP
  Package : UGMD7
  Module : FIN-FB
• 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
• PSO48
  Table for Customer Assignment of BUSAB to Customer Master Record
  Table Type : TRANSP
  Package : FMKW
  Module : PSM-FM-PO
• TVKGG
  Table for Customer Condition Groups (Customer Master)
  Table Type : TRANSP
  Package : VS
  Module : CRM-BF
• TVKGGT
  Table for Texts for Customer Condition Groups (Customer Master)
  Table Type : TRANSP
  Package : VS
  Module : CRM-BF
• 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
• OIO_MT_MTXUS
  Table Data element for Tracking extract user (blank for system extract)
• FCML_NWG_CTYPE
  Table Data element for Master data type for NWG customizing master data item
• MDG_MDF_USAGE
  Table Data element for Master Data: How Master Data/Hierarchies Are Used
• CREQ_APPLICATION
  Table Data element for Request to Change Master Data: Linked Master Data Objects
• UG_ACCESS_MODE
  Table Data element for FIN Master Data: Mode for Accessing Master Data
• UG_MD_USAGE
  Table Data element for FIN Master Data: How Master Data/Hierarchies Are Used
• /BEV1/CLKUNNRK
  Table Data element for Customer's Customer Number at Customer's End
• EXTRACT3
  Table Data element for Data Extract Available After Int. CRS_SEND_TO_SERVER Exit
• FILTEREXTR
  Table Data element for Indicator: Data Extract Available After Filtering
• EXTRACT4
  Table Data element for Data Extract Available After Ext. CRS_SEND_TO_SERVER Exit
• CNV_MBT_DEXID
  Table Data element for DMIS PCL Data Extract ID
• CNV_MBT_DEXACTION
  Table Data element for DMIS PCL Data Extract Action

How to extract customer master data 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.