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

53 columns | Print definition?ERP 6.0  | RUECK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_CWSTHCM Declustering B2 - PDC Time Tickets8RUECKCompletion confirmation number for the operationnvarchar100
2P2B2_WSTHCM Declustering B2 - PDC Time Tickets8RUECKCompletion confirmation number for the operationnvarchar100
TOPCapacity Leveling
3ISTBEDActual requirements records6RUECKCompletion confirmation number for the operationnvarchar100
TOPCompany Pension Scheme Germany
4P01CBEActive CPS Contributions13RUECK"Reimbursed" Indicatornvarchar10
5P01CKAFunded Pension Rights CPS13RUECK"Reimbursed" Indicatornvarchar10
6P01VA_BEActual Contributions CPS for Pension Equalization Payment14RUECK"Reimbursed" Indicatornvarchar10
7P01VA_CBEReduction Amounts for Actual Contributions CPS14RUECK"Reimbursed" Indicatornvarchar10
8P01VA_CKAReduction Amounts for Funded Pension Rights CPS16RUECK"Reimbursed" Indicatornvarchar10
9P01VA_KAFunded Pension Rights CPS for Pension Equalization Payment16RUECK"Reimbursed" Indicatornvarchar10
TOPConfirmations
10AFFWGoods Movements with Errors from Confirmations33RUECKCompletion confirmation number for the operationnvarchar100
11AFFWPROLog of deleted AFFW entries14RUECKCompletion confirmation number for the operationnvarchar100
12AFRCIncorrect cost calculations from confirmations3RUECKCompletion confirmation number for the operationnvarchar100
13AFRDDefault values for collective confirmation4RUECKCompletion confirmation number for the operationnvarchar100
14AFRP0Table of planned changes for confirmation (PDC)11RUECKCompletion confirmation number for the operationnvarchar100
15AFRP1Table of planned changes to conf.: Automatic goods receipt3RUECKCompletion confirmation number for the operationnvarchar100
16AFRP2Table of planned changes for confirmation: Backflushing3RUECKCompletion confirmation number for the operationnvarchar100
17AFRP3Table of planned changes for confirmation: Calc.actual costs3RUECKCompletion confirmation number for the operationnvarchar100
18AFRP4Table of planned changes to confirmatn: Data transfer to HR3RUECKCompletion confirmation number for the operationnvarchar100
19AFRUOrder Confirmations2RUECKCompletion confirmation number for the operationnvarchar100
20AFRVConfirmation pool70RUECKCompletion confirmation number for the operationnvarchar100
21AFRV_DELBackup Copy for Confirmation Pool70RUECKCompletion confirmation number for the operationnvarchar100
22AFWDDeliveries for Confirmation Goods Movements in EWM2RUECKCompletion confirmation number for the operationnvarchar100
23AFWISubsequently posted goods movements for confirmations2RUECKCompletion confirmation number for the operationnvarchar100
TOPConstruction Equipment Management
24J_3GBELPDocument Data - Item Data197RUECKCompletion confirmation number for the operationnvarchar100
TOPConstruction Industry
25PA0191HR Master Record Infotype 0191 (BuildingTradeReimbursExpens)24RUECKReturn to Residencenvarchar10
TOPConsumer Products for Food Beverage
26CFB_WEIGH_LISTDatabase of Weigh List26RUECKCompletion confirmation number for the operationnvarchar100
TOPCost Object
27FCO_DOC_HEADFailure Cost Document Header25RUECKCompletion confirmation number for the operationnvarchar100
TOPGermany
28P01Y15PAISY: Management Table Subrecord Type 1549RUECKPAISY: 1562 Arrears for Maintenance Garnishmentsdecimal72
TOPJust-In-Time Processing
29JITITComponents Group12RUECKCompletion message from production executednvarchar10
TOPMaintenance History
30HIVGPM order history - operations34RUECKCompletion confirmation number for the operationnvarchar100
TOPMaster Data
31BLPPDocument log item5RUECKCompletion confirmation number for the operationnvarchar100
TOPNetwork and Activity
32MLSTMilestone43RUECKCompletion confirmation number for the operationnvarchar100
TOPPersonnel Time Events
33TPTCOR_LOGISTICLogistics Orders (Correction Scenario)8RUECKCompletion confirmation number for the operationnvarchar100
TOPPersonnel Time Management
34AFRUHROrder Confirmations for HR2RUECKCompletion confirmation number for the operationnvarchar100
35CC1ERPIncorrect Time Events from CC1, Postings22RUECKCompletion confirmation number for the operationnvarchar100
36TEVENTime Events28RUECKCompletion confirmation number for the operationnvarchar100
37TEVEN_MOREAdditional Data for Time Events21RUECKCompletion confirmation number for the operationnvarchar100
TOPPlant Data Collection
38RUECKTemp. storage for subsystem confirmations65RUECKCompletion confirmation number for the operationnvarchar100
TOPPlant Maintenance
39Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge49RUECKKennzeichen: Zurückgestelltnvarchar10
40Z9MIANFStillstanndsplanung - Daten für Anfragen30RUECKKennzeichen: Zurückgestelltnvarchar10
TOPProduction Orders
41AFKOOrder Header Data PP Orders77RUECKCompletion confirmation number for the operationnvarchar100
42AFVCOperation within an order78RUECKCompletion confirmation number for the operationnvarchar100
43COCF_CONF_LINKDocuments Posted With Confirmation2RUECKCompletion confirmation number for the operationnvarchar100
44COCF_CONF_QTYConfirmation: Table for Subdivided Quantity Postings2RUECKCompletion confirmation number for the operationnvarchar100
45ORDCOMCommunication control Operation download13RUECKCompletion confirmation number for the operationnvarchar100
TOPPurchasing
46EINAPurchasing Info Record: General Data31RUECKReturn Agreementnvarchar20
TOPQuality Inspection
47QAPPInspection point38RUECKCompletion confirmation number for the operationnvarchar100
TOPRepetitive Manufacturing
48RMRPHR Data of Repetitive Manufacturing Backflush3RUECKCompletion confirmation number for the operationnvarchar100
TOPSimulation
49VSAFKO_CNVersion: Order header data for PP orders78RUECKCompletion confirmation number for the operationnvarchar100
50VSAFVC_CNVersion: Operation in order79RUECKCompletion confirmation number for the operationnvarchar100
51VSMLST_CNVersion: Milestone44RUECKCompletion confirmation number for the operationnvarchar100
TOPTime Tickets
52EVHRHR Order Confirmations (Times/Time Events)21RUECKCompletion confirmation number for the operationnvarchar100
53LSHRHR Order Confirmations (Durations/Time Tickets)21RUECKCompletion confirmation number for the operationnvarchar100