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

25 columns | Print definition?ERP 6.0  | INTCA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1IDAR_TXCINCInternal Codes in country specific Taxation1INTCACountry ISO codenvarchar20
2IDAR_TXCINCTTexts of Internal Codes in country specific Taxation2INTCACountry ISO codenvarchar20
3PAOCFEC_ADR_IMPCCustomer specific address implementation class per country2INTCACountry ISO codenvarchar20
4PAOCFEC_ADR_IMPSSAP delivered address implementation class per country1INTCACountry ISO codenvarchar20
5PAOCFEC_COUNTRYReplication Countries2INTCACountry ISO codenvarchar20
6T005SEPASEPA Country Settings3INTCACountry ISO codenvarchar20
7T77SFEC_ADR_IMPCCustomer specific address implementation class per country2INTCACountry ISO codenvarchar20
8T77SFEC_ADR_IMPSSAP delivered address implementation class per country1INTCACountry ISO codenvarchar20
9T77SFEC_COUNTRYReplication Countries2INTCACountry ISO codenvarchar20
TOPAddress ManagementBusiness Address
10T005Countries15INTCACountry ISO codenvarchar20
TOPBank
11T005ZAlternative Reporting Country Codes4INTCACountry ISO codenvarchar20
12T005ZRAssignment Rules for Alternative Country Codes8INTCACountry ISO codenvarchar20
13T005ZTName of Reporting Country Codes5INTCACountry ISO codenvarchar20
TOPBank Accounting
14TFIBLSCREENControl of Output of Screen Fields1INTCACountry ISO codenvarchar20
TOPBases
15T52PGAssign Country and Table to a Group1INTCACountry ISO codenvarchar20
TOPBasic Functions
16QSTRVARReporting Variants RFWTINT105INTCACountry ISO codenvarchar20
17T609IIFT: Declara. to auth.: Special rules country/region9INTCACountry ISO codenvarchar20
TOPClinical System
18TN1MEPRSCFORMIS-H*MED: Prescription Print Forms3INTCACountry ISO codenvarchar20
TOPContract Accounts Receivable and Payable
19SFKKBRPAPPLBalance reporting: Main settings1INTCACountry ISO codenvarchar20
TOPLocalization
20IDSDTXNUMVISSD Document Screen Control for CPD Partner Tax Numbers1INTCACountry ISO codenvarchar20
TOPNon Profit Organizations
21T7UNPAD_CEBCNTEG CEB Country table5INTCACountry ISO codenvarchar20
TOPPersonnel Administration
22T500LPersonnel Country Grouping3INTCACountry ISO codenvarchar20
TOPTravel Expenses
23PTRV_VATDETAILSupplier Data for VAT Refund in Travel Management7INTCACountry ISO codenvarchar20
24T702OTrip country/Trip region/Trip country group5INTCACountry ISO codenvarchar20
TOPUSA
25HRCCE_T_MNWGVALMinimum Wage Amount for States4INTCACountry ISO codenvarchar20