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

27 columns | Print definition?ERP 6.0  | DEPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1PA3321HR Master Record: Infotype 332132DEPIDDependent IDnvarchar500
TOPBenefit Integration
2T7USBENH1For saving records of issued HIPAA certificates4DEPIDBenefit dependent object IDnvarchar20
3T7USBENH2For savings records of on-demand printing of HIPAA certs.4DEPIDBenefit dependent object IDnvarchar20
TOPFinland
4T7FI12Time-dependent information for personnel area/subarea5DEPIDDepartment IDnvarchar40
TOPProduct Configurator
5COMM_CFGCHADEPDependencies that are attached to Characteristics of Classes5DEPIDInternal identifier of a model elementint100
6COMM_CFGCLACOMCompiled Code for Classic Dependencies3DEPIDInternal identifier of a model elementint100
7COMM_CFGDEPBasic Data for Dependencies (including Nets)3DEPIDInternal identifier of a model elementint100
8COMM_CFGDEPPATPattern5DEPIDInternal identifier of a model elementint100
9COMM_CFGDEPSRCSource Text for Dependencies3DEPIDInternal identifier of a model elementint100
10COMM_CFGDEPTXLanguage Dependent Description of Dependencies3DEPIDInternal identifier of a model elementint100
11COMM_CFGDEPVARPattern5DEPIDInternal identifier of a model elementint100
12COMM_CFGKMTDEPDependencies that are attached to KMATS4DEPIDInternal identifier of a model elementint100
13COMM_CFGOBJDEPRelationship between Classes and Dependencies4DEPIDInternal identifier of a model elementint100
14COMM_CFGPRTDEPDependencies that are attached to BOM positions5DEPIDInternal identifier of a model elementint100
15COMM_CFGVALDEPDependencies that are attached to Values of Characteristics6DEPIDInternal identifier of a model elementint100
16COMM_CFGXREFCross Reference3DEPIDInternal identifier of a model elementint100
TOPSales and Distribution
17SCECHADEPAssignment: Classic Dependencies to Chars of Classes5DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
18SCECLACOMCompilation for Classic Dependencies3DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
19SCEDEPDependencies (Basic Data)3DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
20SCEDEPDOCDocumentation for Dependencies3DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
21SCEDEPPATPattern of Dependency4DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
22SCEDEPSRCSource Code of Dependency3DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
23SCEDEPTXLanguage-Dependent Descriptions for Dependencies3DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
24SCEDEPVARVariables of Dependencies4DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
25SCEKMTDEPAssignment: Dependencies for Configurable Materials4DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
26SCEPRTDEPAssignment of Dependencies to Components (of BOM)5DEPIDInternal counter for objects in an SCE knowledge basenvarchar60
27SCEVALDEPAssignment of Dependencies to Char. Values of Classes6DEPIDInternal counter for objects in an SCE knowledge basenvarchar60