Wednesday, July 15, 2015

ECC Tables

ECC Operational Tables

Tables

Description

Tables

Description

CDHDRChange document header ( Any changes to the document will be documented over here )RODELTAMGives Delta properties for different deltas
CDPOSChange document itemsROIDOCPRMSControl parameters for data transfer from the source system - IDOC Configuration
BDCPChange pointer TableROOSSHORTNDataSource Short Name
BDCP2Aggregated Change Pointers (BDCP, BDCPS) - Master data delta changesROOSPRMSCControl Parameter Per DataSource Channel - Delta Initialisations
SEOCOMPOGives the list of all BADI implementations(Classes) and corresponding methodsTRFCQOUTtRFC Queue Description (Outbound Queue) - SMQ1
ROOSGENDLMGeneric Delta Management for DataSources ( Gives details of when the last delta was run)ARFCSSTATEDescription of ARFC Call Status (Send) - SAP Note 378903
TMCEXACTLO Data Extraction: Activate Data Sources/Update ( When activating new LIS datasource check for inconsistencies.)CLBW_SOURCESData Sources for Classification Data
TCDOB/TObjects for change document creation
TRFCQOUT tRFC Queue Description (Outbound Queue)
BWOM_SETTINGSBW CO-OM: Control Data : This table has all FI related control parameters https://blogs.sap.com/2013/04/02/bwomsettings-for-fi-loads-in-sap-bi/
BWOM2_TIMESTBW CO-OM: Timestamp Table for Delta Extraction
BWFIAA_AEDAT_ASFIAA-BW: New and Modified Master Records for Delta Upload
.
.
.
.
.
.
.
.
.


Functional Tables

Tables

Description

Tables

Description

BKPF
BSEG

FAGLFLEXAGeneral Ledger: Actual Line Items
KNA1Customer General DataKNB1Customer Master u2013 Co. Code Data (payment method, reconciliation acct)
KNB4Customer Payment HistoryKNB5Customer Master u2013 Dunning info
KNBKCustomer Master Bank DataKNKACustomer Master Credit Mgmt.
KNKKCustomer Master Credit Control Area Data (credit limits)KNVVSales Area Data (terms, order probability)
KNVICustomer Master Tax IndicatorKNVPCustomer Partner Function key
KNVDOutput typeKNVSCustomer Master Ship Data
KLPACustomer/Vendor LinkMARAMaterial Master: General
MAKTMaterial Master: Short descriptionMARMMM Conversion factors
MVKESales <Sales Org, Distr Ch>MLANMM Sales <Country>
MAEXMM Export LicensesMARCMaterial Plant
MBEWMM ValuationMLGNMM WM Inventory
MLGTWM Inventory typeMVERMM Consumption Plant
DVERMM Consumption MRP AreaMAPRMM Forecast
MARDMM Storage LocationMCH1MM X Plant Batches
MCHAMM BatchesMCHBMM Batch Stock
MARCHMM C Segment : HistoryMARDHMM Storage Location Segment History
MBEWHMaterial Valuation HistoryMCHBHBatch Stocks : History
MKOLHSpecial Stocks from Vendor : HistoryMSCAHSales Order Stock at Vendor: History
MSKAHSales Order Stock: HistoryMSKUHSpecial Stocks at Customer: History
MSLBHSpecial Stocks at Vendor: HistoryMSPRHProject Stock: History
MSSAHTotal Sales Order Stocks: HistoryMSSQHTotal Project Stocks: History
AUFKOrder master dataVBPASales Partner Functions
ADR6E-Mail Addresses (Business Address Services) EmailVBPA2Sales document: Partner (used several times) 
FPLTCPayment cards: Transaction data - SD SalesAEOI    ECH: Object Management Records for Change Master - Change Records - Revisions
AENR    Change MasterNACH    Detailed output data / output Conditions TCode : VV31/32/33
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

No comments:

Post a Comment