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  | LFNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZDG10MM data generation table6LFNRIdentification number for applicant activitynvarchar40
2ZDG20SD data generation table6LFNRIdentification number for applicant activitynvarchar40
3ZDG30SD data generation table6LFNRIdentification number for applicant activitynvarchar40
4ZDG40Table for Data Generation (Repetitive Manufacturing)6LFNRIdentification number for applicant activitynvarchar40
5ZDG50Table ZDG50 for Data Gen. in RT Area (Monthly via ZARTJ)6LFNRIdentification number for applicant activitynvarchar40
6ZDG60Table ZDG60 for Data Gen. in RT Area (Monthly via ZARTJ)6LFNRIdentification number for applicant activitynvarchar40
7ZID_APOCATTBasis Data for CATT zid_apowe1LFNRIdentification number for applicant activitynvarchar40
8ZID_CRNOTECATTBasis Data for CATT zid_apowe1LFNRIdentification number for applicant activitynvarchar40
9ZID_KREDICATTBasis Data for CATT zid_apowe1LFNRIdentification number for applicant activitynvarchar40
TOPAllocation
10T624Control Table, Allocation Rule Determination4LFNRSerial numbernvarchar30
TOPBusiness Partner
11DFKKBPCL_ACTBusiness Partner Duplicates: Status of Activities4LFNROrder of Activitiesnvarchar30
TOPClinical System
12N1CYDEFISHMED: Cycle Definition41LFNRSequence Numbernvarchar40
TOPOrganizational Management
13T77SCCustomizing: Grouping Entries in T77S03LFNRSequence Numbernvarchar30
TOPPortfolio
14TDPAYM_PLANPPM: Condition Types for Payment Plans4LFNRCounternvarchar20
TOPRadiology
15N1MPPSEXPOSUREIS-H*MED RAD: RIS Modality Performed Procedure Step Exposure3LFNRRadiology: Sequence No.int100
16N1MPPSMATERIALIS-H*MED RAD: RIS Modality Performed Procedure Step Material3LFNRRadiology: Sequence No.int100
17N1MPPSSERVICEIS-H*MED RAD: RIS Modality Performed Procedure Step Service3LFNRRadiology: Sequence No.int100
TOPReal Estate Management
18VIMI24Percentage for Sales for Sales-Based Lease-Out6LFNRSequence number for sales amount and percentagenvarchar30
19VIMI35Percent for sales for sales-based rental agrmnt (offer)6LFNRSequence number for sales amount and percentagenvarchar30
20VIMIK1RA Periods of notice: Period regulation3LFNRPeriods of notice sequence numbernvarchar30
21VIMIK2RA periods of notice: Deadline regulation3LFNRPeriods of notice sequence numbernvarchar30
22VIMIUISales-Based Grading Lease-Out Items5LFNRSequence number for sales amount and percentagenvarchar30
23VIWIV3Simplified CEA: Finance Plan Outside Funds5LFNRSimplif.CEA: Financ.plan outside fundsnvarchar30
TOPTransportation Planning
24/DSD/RP_DRVLOCKDriver's Lock Times3LFNRSequence Numbernvarchar50
25/DSD/RP_FLTLOCKLock Times of a Vehicle3LFNRSequence Numbernvarchar50