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

39 columns | Print definition?ERP 6.0  | DATA_ORIGIN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZCOMPCHECKParameter table for Compliance check5DATA_ORIGINSource of Datanvarchar100
TOPAccounting Engine
2UAINVT2000Characteristics of Inventory and WIP Views13DATA_ORIGINOrigin of the Master Datanvarchar10
TOPCondition Technique
3/SAPCND/CTLISTDet. Procedure6DATA_ORIGINData Source Systemnvarchar100
4/SAPCND/CTLISTIElements in Determ. Procedure11DATA_ORIGINData Source Systemnvarchar100
5/SAPCND/CTLISTTTexts for Condition Type Lists8DATA_ORIGINData Source Systemnvarchar100
6/SAPCND/GROUPCondition Maintenance Group3DATA_ORIGINData Source Systemnvarchar100
7/SAPCND/GROUPTTexts for Groups of Condition Tables and Types5DATA_ORIGINData Source Systemnvarchar100
8/SAPCND/GROUP_ICondtion Maintenance Definition8DATA_ORIGINData Source Systemnvarchar100
9/SAPCND/T681Condition Table Structure24DATA_ORIGINData Source Systemnvarchar100
10/SAPCND/T681ECondition Table Structure Field10DATA_ORIGINData Source Systemnvarchar100
11/SAPCND/T681MCondition Type - Cond. Change System7DATA_ORIGINData Source Systemnvarchar100
12/SAPCND/T681TGeneratable Condition Tables - Texts7DATA_ORIGINData Source Systemnvarchar100
13/SAPCND/T682Condition access sequence6DATA_ORIGINData Source Systemnvarchar100
14/SAPCND/T682ICondition access12DATA_ORIGINData Source Systemnvarchar100
15/SAPCND/T682TAccess Sequences - Texts6DATA_ORIGINData Source Systemnvarchar100
16/SAPCND/T682VPermitted Combinations of Condition Types and Access Seq.6DATA_ORIGINData Source Systemnvarchar100
17/SAPCND/T682ZCondition Access Characteristic15DATA_ORIGINData Source Systemnvarchar100
18/SAPCND/T685Condition Types12DATA_ORIGINData Source Systemnvarchar100
19/SAPCND/T685TCondition Types - Texts7DATA_ORIGINData Source Systemnvarchar100
20/SAPCND/T686ECondition Processing Status4DATA_ORIGINData Source Systemnvarchar100
21/SAPCND/T686FText Processing Status5DATA_ORIGINData Source Systemnvarchar100
TOPFinancials Basis
22/EACC/TLI4000Context of Field Name, Info Object, D Elment, D Srce per D B4DATA_ORIGINOrigin of the Master Datanvarchar10
TOPFree goods
23FGDC_COND_PFree Goods Procedures10DATA_ORIGINData Source Systemnvarchar100
24FGDC_COND_PDFree Goods Procedures (Header)4DATA_ORIGINData Source Systemnvarchar100
25FGDC_COND_PDTTexts for Natural Free Goods Procedures6DATA_ORIGINData Source Systemnvarchar100
TOPGeneral Ledger
26/EACA/TGLTEMPLATCustomizing Templates in the G/L8DATA_ORIGINOrigin of the Master Datanvarchar10
TOPPeriodical Sales and Distribution
27JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet131DATA_ORIGINIS-M: Origin of Data in Order Postprocessingnvarchar10
TOPPricing
28PRCC_COND_CTCondition Types (T685A)48DATA_ORIGINData source systemnvarchar100
29PRCC_COND_LIMITSCondition Types: Lower/Higher Limits for Pricing Elements10DATA_ORIGINData source systemnvarchar100
30PRCC_COND_PPPricing Procedure Data (T683S)26DATA_ORIGINData source systemnvarchar100
31PRCC_COND_PPDPricing Procedure Attributes (T683)6DATA_ORIGINData source systemnvarchar100
32PRCC_COND_PPDTTexts for Pricing Procedures (T683U)6DATA_ORIGINData source systemnvarchar100
33PRCC_COND_PPTTexts for Line in Pricing Procedure (T683T)9DATA_ORIGINData source systemnvarchar100
34PRCC_EXCL_CONDCondition Types (T684G) Conntained in the Exclusion Groups5DATA_ORIGINData source systemnvarchar100
35PRCC_EXCL_GROUPSCondition Exclusion Groups (T684)4DATA_ORIGINData source systemnvarchar100
36PRCC_EXCL_GRP_TCondition Exclusion Groups (T684)6DATA_ORIGINData source systemnvarchar100
37PRCC_EXCL_PROCAssignment of Exclusion Groups to Procedure (T684S)8DATA_ORIGINData source systemnvarchar100
38REBC_COND_CTRebate Condition Types48DATA_ORIGINData source systemnvarchar100
TOPRecipe Development
39/PLMB/CCK_HDRCompliance Check5DATA_ORIGINData Originnvarchar90