SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

40 columns | Print definition?ERP 6.0  | BUTXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VT_BUKRSReporting table: Company codes4BUTXTName of Company Code or Companynvarchar250
2/SAPSRM/SH_COMPCTable for ERP Search Help Company Codes4BUTXTName of Company Code or Companynvarchar250
3CNV_20100_T001CNV backup copy for T0014BUTXTName of Company Code or Companynvarchar250
4CNV_20305_T001backup table of T001 (certain fields only)4BUTXTName of Company Code or Companynvarchar250
5EHPRCC_LGENTLegal Entity3BUTXTLegal Entity Namenvarchar600
TOPActual CostingMaterial Ledger
6CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 91298414BUTXTName of Company Code or Companynvarchar250
TOPBank Customer Accounts
7BKKCORRITEMAuxiliary Table: Payment Items for Adjustments43BUTXTPosting Textnvarchar500
TOPBasic Functions
8FEBEPElectronic Bank Statement Line Items32BUTXTBank posting textnvarchar500
TOPBasis Components
9ZDS400_T001Buchungskreise3BUTXTBuchungskreis- oder Firmen-Bezeichnungnvarchar250
TOPContract Accounts Receivable and Payable
10FKKBEPElectronic Bank Statement Line Items32BUTXTBank posting textnvarchar500
TOPCorrespondence Tool
11TFK070CORRBUKRSCorrespondence - Structure for Company Code Search Help2BUTXTName of Company Code or Companynvarchar250
TOPData Retention Tool
12TXX_ADMI_EXTRDART-Administration --- Extract_Data---17BUTXTName of Company Code or Companynvarchar250
13TXX_EXTR_TEMPLDART-Administration --- Extract_Data---13BUTXTName of Company Code or Companynvarchar250
TOPEnvironment, Health and Safety
14/TDAG/RCSA_LGENTLegal Entity3BUTXTLegal Entity Namenvarchar600
TOPFinancial Accounting
15T001Company Codes3BUTXTName of Company Code or Companynvarchar250
16T001NCompany Code - EC Tax Numbers / Notifications5BUTXTName of Company Code or Companynvarchar250
TOPLoans Management
17VDZNB_PAYINFOPayment Postprocessing: Payment Inform. for a PPP Activity30BUTXTBank posting textnvarchar500
18VZFZE_VDNBZECentral Entry Table for Release Procedure15BUTXTName of Company Code or Companynvarchar250
TOPLocalization
19J_3RBUE_BK_HTABLTable head for EXTRACT14BUTXTName 1nvarchar350
20J_3RSL_BK_HTABLTable head for EXTRACT13BUTXTName of Company Code or Companynvarchar250
TOPPayment Item
21BKKITPayment Item43BUTXTPosting Textnvarchar500
22BKKITAIInfo Items for Interest Penalty at Balancing16BUTXTPosting Textnvarchar500
23BKKITENQBlocked Payment Items43BUTXTPosting Textnvarchar500
24BKKITRELPayment Item43BUTXTPosting Textnvarchar500
25BKKITTMPPlanned Payment Items44BUTXTPosting Textnvarchar500
26BKKITTMP_DELPlanned Payment Items - Completed44BUTXTPosting Textnvarchar500
TOPPayment Order
27BKKPOITItem in Payment Order19BUTXTPosting Textnvarchar500
28BKKPOIT_TMPItems in Planned Payment Order20BUTXTPosting Textnvarchar500
29BKKPOIT_TMP_DELItems in Planned Payment Order18BUTXTPosting Textnvarchar500
TOPPayroll
30T7BGA1Bank transfer - interface table7BUTXTName of Company Code or Companynvarchar250
TOPPersonnel Administration
31T7CO01Additional data of the company5BUTXTCompany code namenvarchar500
TOPProcess Controls -Automated Controls
32GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)5BUTXTName of Company Code or Companynvarchar250
33GRPCRTA_HRDA0045PC HR control data for infotype 0045 - Loan5BUTXTName of Company Code or Companynvarchar250
34GRPCRTA_HRDA0078PC HR control data for infotype 0078 - Loan Payments5BUTXTName of Company Code or Companynvarchar250
35GRPCRTA_HRDA0267PC HR control data for infotype 02675BUTXTName of Company Code or Companynvarchar250
36GRPCRTA_HRDAT1PC HR control data for infotype 0014 and 00155BUTXTName of Company Code or Companynvarchar250
37GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 00155BUTXTName of Company Code or Companynvarchar250
TOPReal Estate Localization Czech Republic
38/CEERE/TBUKRSMain Company Code3BUTXTName of Company Code or Companynvarchar250
TOPReal Estate Management
39RFVIUMSATZTest Data for RE Multicash Sales Data12BUTXTPosting textnvarchar270
40S402Business entities87BUTXTName of Company Code or Companynvarchar250