SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OBOT10Bill Of Exchang Transaction
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

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