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

52 columns | Print definition?ERP 6.0  | LOG_SYSTEM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BDS_BAR_IN_REFReference Structure for BDS_BAR_IN2LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
2BDS_CON019BDS: Link Table5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
3TEXT_CTY_EXPOSCommodity Price Exposure9LOG_SYSTEMLogical systemnvarchar100
TOPActual Update and Commitment Update
4GTR_TRANSLATORGrantor: Translator of CRM and ERP Integration Attributes5LOG_SYSTEMLogical systemnvarchar100
TOPBasic Functions
5UDM_SPS_ADMINFSCM-DM Integration: Determination of Element Type3LOG_SYSTEMLogical systemnvarchar100
TOPBatches
6TOBJ_D_INDEXIndex Table - Batch-Related Object Types7LOG_SYSTEMLogical systemnvarchar100
TOPBusiness Document Service
7BDS_BAR_INBusiness Document Service: Internal Bar Codes3LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
8BDS_CONN00BDS: Client-Specific Link Tables5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
9BDS_CONN01BDS: Client-Independent Link Tables4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
10BDS_CONN02BDS: Link Table Default for Undefined Classes4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
11BDS_CONN03BDS: Link Table Default for Undefined Classes4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
12BDS_CONN04BDS: Client-Specific Link Tables5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
13BDS_CONN05BDS: Link Table Default for Undefined Classes4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
14BDS_CONN06BDS: Link Table Default for Undefined Classes5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
15BDS_CONN07BDS: Link Table Default for Undefined Classes5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
16BDS_CONN08BDS: Link Table Default for Undefined Classes5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
17BDS_CONN09BDS: Link Table Default for Undefined Classes4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
18BDS_LOGBDS: Protocol Table for Accesses to BDS Documents3LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPBusiness Information Collection
19BDS_CONN23BDS: Link Table Default for Undefined Classes5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPBusiness Planning and Simulation
20BDS_CONN22BDS: Link Table Default for Undefined Classes5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
21BDS_CONN31BDS: Link Table Default for Undefined Classes5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPControlling
22BDS_CONN24BDS: Link Table Default for Undefined Class5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPCorporate Performance Monitor
23BDS_CONN15BDS: Link Table Default for Undefined Class5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
24BDS_CONN17BDS: Link Table Default for Undefined Class4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPCross-Application Components
25BDOC_TRACKInformation on BDOCs During Load from CRM System/Back End7LOG_SYSTEMLogical systemnvarchar100
TOPEnd User Technology
26BDS_CONN111BDS: Link Table Default for Undefined Classes4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPExternal personnel administration
27HRSM_HEADExternal employee data: Header data3LOG_SYSTEMLogical systemnvarchar100
28HRSM_PROTOCOLAssignment of external ID to SAP R/3 personnel number4LOG_SYSTEMLogical systemnvarchar100
TOPGeneric Contract Accounts Receivable and Payable
29BCA_DIM_CALCDETCalculation details for billing items3LOG_SYSTEMLogical systemnvarchar100
TOPIntegration with Manufacturing Execution Systems
30AFDISTDistribution Information on Production Order3LOG_SYSTEMLogical systemnvarchar100
31TCOPODISTControl of Distribution of Production Orders to an MES5LOG_SYSTEMLogical systemnvarchar100
TOPInvoicing in Contract Accounts Receivable and Payable
32DFKKINVBILL_HBilling Document Header4LOG_SYSTEMLogical systemnvarchar100
33DFKKINVDOC_SSource Document for Invoicing/Reversal History6LOG_SYSTEMLogical systemnvarchar100
34DFKKINV_TRIGInvoicing Order5LOG_SYSTEMLogical systemnvarchar100
TOPLaunchpad
35BDS_CONN24ABDS: Linkage Default for non-defined Classes5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPProcess Management
36BDS_CONN25BDS: Link Table Default for Undefined Class5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPQuality Inspection
37QALSInspection lot record229LOG_SYSTEMLogical systemnvarchar100
TOPReal Estate Management
38BDS_CONN26BDS: Link Table Default for Undefined Class5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPSAP Business Workflow
39BDS_CON020BDS: Link Table Default for Undefined Class5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPSAP GUI for Windows Controls
40BDS_CONN14BDS: Client-Specific Link Tables5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPSAP List Viewer
41BDS_CONN16BDS: Link Table Default for Undefined Class5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPSAPscript
42BDSX_CON04BDS link4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPService Data Download
43/BDL/LOCKEDtable for log entries - when sdcc is locked for transport4LOG_SYSTEMnvarchar80
44BDLLOCKEDtable for log entries - when sdcc is locked for transport4LOG_SYSTEMnvarchar80
TOPStakeholder Relationship Management
45BDS_CON028BDS: Link Table Default for Undefined Class5LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPTransaction Manager
46TEMT_RAWEXPOSRaw Exposure4LOG_SYSTEMLogical systemnvarchar100
47TEMT_VERSEXPOSVersioned Exposure6LOG_SYSTEMLogical systemnvarchar100
48TEXT_RAWEXPOSRaw Exposure5LOG_SYSTEMLogical systemnvarchar100
49TEXT_TRANSACTIONUnmatched Exposure Business Transactions48LOG_SYSTEMLogical systemnvarchar100
TOPTransaction Variant and Table Control Settings
50BDS_CONN21BDS: Link Table Default for Undefined Class4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
TOPWithout Description
51BDS_CONN18BDS: Link Table Default for Undefined Classes4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100
52BDS_CONN20BDS: Link Table Default for Undefined Classes4LOG_SYSTEMBusiness Document Service: ID of logical systemID of logicalnvarchar100