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

22 columns | Print definition?ERP 6.0  | ACCNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FIWTIN_ACC_EXEMCumulative values for accounts payable/ account receivable3ACCNOVendor/customer account numbernvarchar100
2FIWTIN_TAN_EXEMTable for mapping TAN and Exemption Number4ACCNOVendor/customer account numbernvarchar100
3GRACREQUSERUser Associated with Request9ACCNOAccounting Numbernvarchar120
4P2RU_BALPayroll Results: Tax Retro Differences -(USA)7ACCNOHR payroll: Numberdecimal152
5P2RU_UNBPayroll Results: Tax Retro Differences -(USA)7ACCNOHR payroll: Numberdecimal152
6P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)7ACCNOHR payroll: Numberdecimal152
7VIXCITCADAOTemporary architectural object data102ACCNOAccount numbernvarchar100
TOPBasic Functions
8GLACCREFIG/L Account Master Record: Create with Reference5ACCNOG/L Account Numbernvarchar100
TOPFlexible Real Estate Management
9TIVXCITICIPARAMICI/IMU City parameter3ACCNOAccount numbernvarchar100
10VIXCITICIDATAICI master data12ACCNOAccount numbernvarchar100
TOPKorea
11PA0881HR Master Record: Infotype 0881108ACCNOAccount Numbernvarchar200
TOPLocalization
12J_1AR_DTYPEARG - Gross Income Perception Customer Data4ACCNOVendor/customer account numbernvarchar100
13J_1AR_TPLISTInformation to Update Taxpayer List3ACCNOVendor/customer account numbernvarchar100
TOPMalaysia
14T5LEPEmployee Provident fund for Malaysia11ACCNOCompany account numbernvarchar170
15T5LSPEmployer reference for SOCSO (Malaysia)8ACCNOCompany account numbernvarchar170
16T5LTKReference Number output attributes13ACCNOCompany account numbernvarchar170
17T5LTPEmployer reference for tax9ACCNOCompany account numbernvarchar170
TOPRadiology
18N1MPPSIS-H*MED RAD: RIS Modality Performed Procedure Step9ACCNORAD: Accession Numbernvarchar640
19N1QUERYIS-H*MED: Radiology: QUERY4ACCNORAD: Accession Numbernvarchar640
TOPReporting
20P05T_WCR_ER_INFOWCR Info on Employer Level10ACCNOGeneral Ledger Account Numbernvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
21NVVNIS-H: Guarantors16ACCNOIS-H: Account Numbernvarchar170
TOPThailand
22T7THSBSocial Security Branches5ACCNOCompany account number for social securitynvarchar100