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

55 columns | Print definition?ERP 6.0  | DEPTH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/TZNFAdditional Data Table For Relationship ZNF3DEPTHTechnical Depth of Structurenvarchar50
2/SAPPSSRM/LINRULLink of the Item Level to the Rule5DEPTHHierarchy Depth (in Line Numbers)tinyint30
3/SAPPSSRM/LIN_TLanguage table for Item Level to the Rule6DEPTHHierarchy Depth (in Line Numbers)tinyint30
4/SDF/CC_OBJECTSTable of customer objects4DEPTHNatural Numberint100
5/SDF/CC_PARAMSCustomer object analysis parameters3DEPTHNatural Numberint100
6ARBFND_I_DCXML_DDDIC objects generated for the DTD elements and attributes13DEPTHint100
7BBPD_PCH_IDXDatabase Table with Hierarchy Index5DEPTHDummy for B20 int1 (Local Everywhere)tinyint30
8CLS_TRANSL_GRAPHTranslation Graph Mapping2DEPTHTranslation depthnvarchar400
9CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information27DEPTHDD: Depth for structured typesnvarchar20
10DD03NDDD: Attributes of a Node of a Structured Object22DEPTHDD: Depth for structured typesnvarchar20
11DD03NTDD: Texts for fields (Language-Dependent) (Struct.Object)6DEPTHDD: Depth for structured typesnvarchar20
12DDREPLINTABFDDD: Nametab Field Structure16DEPTHDepth in nested structuresvarbinary10
13DDXTF_CONV_UCNametab Feldstruktur für verzögertes Schreiben15DEPTHTiefe bei geschachtelten Strukturenvarbinary10
14DDYTF_CONV_UCUsed during UCMIG within DMO of SUM15DEPTHDepth in nested structuresvarbinary10
15IUUC_DD_SYNC_NTFSystem synchronization: Nametab field data19DEPTHDepth in nested structuresvarbinary10
16T7AE30Organization Path Depth Level2DEPTHDisplay Depth of Structurenvarchar20
17T7AE30TOrganization Path Depth Level Text3DEPTHDisplay Depth of Structurenvarchar20
18T7INPEW3P2E: Agent Code8DEPTHTechnical Depth of Structuredecimal50
19T7INPEW6P2E: Agent Determination For Team Groups13DEPTHTechnical Depth of Structuredecimal50
20TMAS_OLA_D_LOGCSLogging callstack2DEPTHnvarchar30
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
21DD03LTable Fields24DEPTHDD: Depth for structured typesnvarchar20
22DDXTFNametab Field Structure for Delayed Writing15DEPTHDepth in nested structuresvarbinary10
TOPBasic Functions
23TCREPCATT-Test Reporting - Check of logical databases7DEPTHGeneral Flagnvarchar10
TOPBusiness Object Builder
24SWOTIPIndex Parent Object Types3DEPTHDepth in object treenvarchar20
TOPBusiness Package for Manager Self-Service HR
25TWPC_NAVDefine Navigation Types5DEPTHStructure Depth for Navigation Displaydecimal50
26TWPC_VView Definition9DEPTHStructure Depth for Tree Displaydecimal50
27TWPC_V_CView Definition - Customer9DEPTHStructure Depth for Tree Displaydecimal50
TOPClaims Management
28ICLITEMWADamaged Watercraft18DEPTHDepth of watercraftdecimal60
29ICLPOLOWAInsured Watercraft19DEPTHDepth of watercraftdecimal60
30ICSITEMWADamaged Watercraft18DEPTHDepth of watercraftdecimal60
31ICSPOLOWAInsured Watercraft19DEPTHDepth of watercraftdecimal60
TOPContract Accounts Receivable and Payable
32DFKKPTSAFTDEFObsolete! DO NOT USE5DEPTHPortugal: SAF-T Element level (depth)nvarchar40
TOPECM ABAP Stack
33NWECMD_LOCKTable for persistent Lock objects5DEPTHNW ECM: Length limited string for table queriesnvarchar2500
34NWECMD_LOCKSNW ECM: Locks9DEPTHNW ECM: Enumeration Code from Storenvarchar10
TOPGraphic
35TGSUOSAP Structural Graphics: User-Specific Settings3DEPTHDisplay depthnvarchar20
36TGSUVSAP Structural Graphics: User-Specific Settings4DEPTHDisplay depthnvarchar20
TOPIncentive and Commission Management ICM
37TCACS_DETCFGProcess Configuration of Calculating Object Type6DEPTHRecursion Depthint100
TOPNetWeaver Demonstration
38SNWD_PDEPM: Product Data Table21DEPTHEPM: Dimensiondecimal133
TOPOrganization and Planning
39T77GMSGeneric Role Manager: Definition of a Structure4DEPTHGeneric Role Manager: Structural Depthdecimal50
40T77GMSCGeneric Role Manager: Definition of a Structure5DEPTHGeneric Role Manager: Structural Depthdecimal50
TOPOrganizational Management
41T77PRDefinition of Authorization Profiles9DEPTHDisplay Depth of Structuredecimal50
TOPPlant Maintenance
42PLMN_FL_EXTGHO Object characteristics19DEPTHDepthdecimal133
TOPSAP Business Workflow
43SWFDEXPVERTest and Verification of Expression Package SWF_EXP8DEPTHnvarchar30
TOPService Data Download
44/BDL/BDLSADATAService Definition, Definition of global variables8DEPTHDepth of structureint100
45BDLSADATADefinition of global variables in the Service Assistant7DEPTHDepth of structureint100
TOPShip
46CMS_SHPDescription of a Ship - Master Table35DEPTHShip Draughtdecimal133
TOPTalent Management
47HRPAD741Additional Data for Relationship 'Is Responsible For'3DEPTHTechnical Depth of Structurenvarchar50
TOPUpgrade - General
48DDMTFNametab Field Structure for Delayed Writing15DEPTHDepth in nested structuresvarbinary10
49DDMTF_ISUNametab Field Structure for Delayed Writing15DEPTHDepth in nested structuresvarbinary10
50DDMTF_SAVNametab Feldstruktur für verzögertes Schreiben15DEPTHTiefe bei geschachtelten Strukturenvarbinary10
51DDXTF_SAVNametab Feldstruktur für verzögertes Schreiben15DEPTHTiefe bei geschachtelten Strukturenvarbinary10
52DDXTF_SHDNametab Feldstruktur für verzögertes Schreiben15DEPTHTiefe bei geschachtelten Strukturenvarbinary10
53DDXTF_STDNametab Feldstruktur für verzögertes Schreiben15DEPTHTiefe bei geschachtelten Strukturenvarbinary10
54DDYTFSubstitution Nametab (shadow-shadow-nametab for DDXTF)16DEPTHDepth in nested structuresvarbinary10
TOPUpgrade Tools
55ICNV31LNametab for Incremental Conversion17DEPTHvarbinary10