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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

22 columns | Print definition?ERP 6.0  | PKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS16_PARAMSParameter List For System Analysis3PKEYData Element for Parameter Keynvarchar400
TOPClinical System
2N1IPBAIS-H*MED: Asnmt. of Indiv. Nurs. Plan to Basic HospCat.Entry4PKEYCode of Basic Nursing Catalognvarchar200
3N1PLBAIS-H*MED: Assignment basic hosp.cat.entry to hour.nurs.plans6PKEYCode of Basic Nursing Catalognvarchar200
4N2BKIS-H*MED: Basic Nursing Catalog4PKEYCode of Basic Nursing Catalognvarchar200
5N2BKGZIS-H*MED: Nursing basic catalog - classif. areas assignment5PKEYCode of Basic Nursing Catalognvarchar200
6N2SPGZIS-H*MED: Standard nursing plan - classif. areas asgmt5PKEYCode of Basic Nursing Catalognvarchar200
TOPCollectionsDisbursements
7DIMAIOBPARIO: Insurance Object-Partner Relationship in FS-CD58PKEYPayment Plan Keynvarchar20
8DIMAPARPPLANIO: Payment Plan Changes in Insurance Object6PKEYPayment Plan Keynvarchar20
9DIMAPARSCPOSIO: Change to Scheduling Items20PKEYPayment Plan Keynvarchar20
10TVS010BIS-IS Scheduling: Paymt Plan2PKEYPayment Plan Keynvarchar20
11TVS010BTIS-IS Scheduling: Paymt Plan Texts3PKEYPayment Plan Keynvarchar20
12TVS010HIS-IS Scheduling: Percentage Distribution in Paymt Plan2PKEYPayment Plan Keynvarchar20
13TVS010IIS-IS Scheduling: Assignment of Activities to Posting Event2PKEYPayment Plan Keynvarchar20
14TVS010JIS-IS Scheduling: Assignment of Activities to Change Event2PKEYPayment Plan Keynvarchar20
15TVS020AIS-IS Scheduling: Assigning Payment Plan to Payment Option3PKEYPayment Plan Keynvarchar20
16VVSCITEMBill Scheduling: Scheduling Document28PKEYPayment Plan Keynvarchar20
17VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change28PKEYPayment Plan Keynvarchar20
18VVSCPOSPayment Plan Item52PKEYPayment Plan Keynvarchar20
TOPIncentive and Commission Management ICM
19TCACS_LOS_ST_ODLogical Service: Parameters for Std Tool (Object-Dependent)11PKEYPayment Plan Key (Copy VVSC)nvarchar20
TOPTranslation Tools
20LXE_KEY_VALUEProperties1PKEYnvarchar320
21LXE_XT_OBJ_ATTRObject Attributes3PKEYParameter Keynvarchar320
22LXE_XT_TXT_ATTRText Attributes4PKEYParameter Keynvarchar320