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

53 columns | Print definition?ERP 6.0  | CNTRY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CF002Human Resources11CNTRYCountry Keynvarchar30
2FIAPPTD_KUKEYID administration2CNTRYCountry Keynvarchar30
3FIITC_BL_CNTRYBlack List Countries2CNTRYCountry Keynvarchar30
4PA0556HR Master Record: Infotype 055625CNTRYTax treaty country codenvarchar20
5PA3217HR Master Record: Infotype 321726CNTRYSWF: Country of Originnvarchar30
6PAPBSGB_SWF_QUALSWF: Qualifications11CNTRYSWF: Country of Originnvarchar30
7PAPBSGB_SWF_QUL2SWF: Qualifications12CNTRYSWF: Country of Originnvarchar30
8T5CSWHR-CH: Work Center ELM 4.016CNTRYCountry for Mailing (6. Line)nvarchar400
9T5Q_SUPERSTREAMSuper Stream Master Table71CNTRYCountry Keynvarchar30
10T5UPBS101042-S Country Code3CNTRYTax treaty country codenvarchar20
11T5UPBS13Tax treaty table2CNTRYTax treaty country codenvarchar20
TOPAddress ManagementBusiness Address
12SADR8Address management: X.400 addresses7CNTRYAddresses: X.400 country keynvarchar30
TOPAerospace Defence Industry Solution
13ADFDR_COUNTRYCountry Table3CNTRYCountrynvarchar400
TOPBasic Functions
14T850KCompany correspondence data13CNTRYCountry of companynvarchar30
TOPConsolidation
15TF162Consolidation Unit Correspondence14CNTRYCountrynvarchar30
TOPCross-Application Components
16/OPT/VPR_ADDRVendor Address for Registered Vendor and Partner11CNTRYCountry Keynvarchar30
TOPData Collection
17CF500IDES Investment38CNTRYCountry Keynvarchar30
18CF650Profitability 17CNTRYCountry Keynvarchar30
19CF750MCRED8CNTRYCountry Keynvarchar30
20CF751MCBLUE7CNTRYCountry Keynvarchar30
21CF752MCBlack8CNTRYCountry Keynvarchar30
22CF760MC Black SAP Belgium8CNTRYCountry Keynvarchar30
23CF994archive example7CNTRYCountry Keynvarchar30
24CF995profitab: customers7CNTRYCountry Keynvarchar30
25CF996profitability (rep.)7CNTRYCountry Keynvarchar30
26KCK996comments for 99611CNTRYCountry Keynvarchar30
TOPElectronic Compliance Reporting
27/ECRS/TEREExclusion of Regions from Intrastat3CNTRYCountry (Internal SAP Code)nvarchar30
TOPGlobal Trade Services
28/SAPSLL/PRCTRProduct Master: Authority/Country Data4CNTRYCountry Keynvarchar30
29/SAPSLL/RXPCTYRe-Export: Log: Countries in Country Group4CNTRYCountry Keynvarchar30
TOPIndonesia
30PA0318HR Master Record: Infotype Family data for Indonesia (0318)29CNTRYCountry Keynvarchar30
TOPNon Profit Organizations
31T7UN_T52BOOperation Parameters5CNTRYCountry groupingnvarchar20
32T7UN_T52BPTexts for Operation Parameters6CNTRYCountry groupingnvarchar20
TOPPayroll General Parts
33T52BOOperation Parameters5CNTRYCountry groupingnvarchar20
34T52BO_ADDONHR-Add-on : Operation Parameter5CNTRYCountry groupingnvarchar20
35T52BPTexts For Operation Parameters6CNTRYCountry groupingnvarchar20
36T52BP_ADDONHR-Add-on : Texts for the Operation Parameters6CNTRYCountry groupingnvarchar20
TOPProduct Catalog
37TWIC8003IACs Retail: Selection of countries for customer address4CNTRYCountry Keynvarchar30
TOPProfitability Analysis Basic Functions
38K830001Summarization level KT: 400 KC 01 CF996 0000014CNTRYCountry Keynvarchar30
39K830003Summarization level KT: 400 KC 01 CF996 0000024CNTRYCountry Keynvarchar30
TOPPublic Sector
40PA0619HR-AU-PS : Equity and Diversity34CNTRYCountry of Birthnvarchar30
TOPReuse Services for Country Development
41T599ETime-Dependent Rounding for Operation RNDC13CNTRYSpecial rule for time-dependent roundingnvarchar10
TOPRussia
42T7RUG3Rules for Calculation of Garnishment Order Types3CNTRYCountry Keynvarchar30
43T7RUGVRules for Calculation of garnishment order type4CNTRYCountry Keynvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
44TNNL4IS-H NL: Country code LMR4CNTRY_nvarchar20
TOPSchedule Manager
45T880Global Company Data (for KONS Ledger)4CNTRYCountry of companynvarchar30
TOPSouth Africa
46PA0725Foreign income SARS codes (South Africa)24CNTRYCountry of Foreign Incomenvarchar30
TOPUSA
47T5UG4Rules for Calculation of the Non-Exempt Amount2CNTRYCountrynvarchar30
48T5UG6Government Service Charge2CNTRYCountrynvarchar30
49T5UG7Government Remittance Rule2CNTRYCountrynvarchar30
50T5UG8Company Remittance Rule2CNTRYCountrynvarchar30
51T5UGCService Charge2CNTRYCountrynvarchar30
52T5UGGCompany Service Charge2CNTRYCountrynvarchar30
53T5UGIGarnishment Letters2CNTRYCountrynvarchar30