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

48 columns | Print definition?ERP 6.0  | GROUPNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSOS/PERSOSETPersonas Settings3GROUPNAMEPersonas Global Groupnvarchar1280
2/TDAG/GFWWIM_CGPGenifix: Komponentengruppen3GROUPNAMEKomponentengruppennamenvarchar320
3LAW2D_GROUP3GROUPNAMEnvarchar200
4N1CORDFGTCORD: Order Filler Group Texts5GROUPNAMECORD: Name of Order Filler Groupnvarchar1280
5TN1MCI_HL7MSSMessage Structure7GROUPNAMEGroupnvarchar500
6ZCONV_LOGConversion Log5GROUPNAMELandscape namenvarchar200
7ZCONV_LOG_IMPORTImportprotokoll2GROUPNAMELandschaftsnamenvarchar200
8ZSYSTEM_PARTNERLandscape data: Items1GROUPNAMELandscape namenvarchar200
9ZSYSTEM_PARTNERGLandscape Data: Header1GROUPNAMELandscape namenvarchar200
10ZTARGET_PARTNERSystem Landscapes: Components1GROUPNAMELandscape namenvarchar200
11ZTARGET_PARTNERGSystem Landscapes: Header Data1GROUPNAMELandscape namenvarchar200
TOPBSI
12BTXEGRPBSI: Employee Group3GROUPNAMEBSI: Name of employee groupnvarchar500
13BTXEGRP_OBSI: Employee Group2GROUPNAMEBSI: Name of employee groupnvarchar500
TOPClaims Management
14ICLC_MTASKINGClaims Parallel Processing Control7GROUPNAMELogon/Server Group Namenvarchar200
TOPClient-System Adapter
15MDMEXTRFLDMDM Field Table for Extraktor Metadata4GROUPNAMEMDM Extraction Object: Field Groupnvarchar300
16MDMEXTRGRPMDM Field Group Extraktor Metadata4GROUPNAMEMDM Extraction Object: Field Groupnvarchar300
17MDMEXVARISELMDM Extractor: Selection Criteria4GROUPNAMELogical Name of a Group of Fieldsnvarchar300
18MDM_SELECT_TRANSMDM: Storage Location of Selections and Transfer Segments6GROUPNAMELogical Name of a Group of Fieldsnvarchar300
TOPCondition Technique
19/SAPCND/CNTXT_GRTable of Condition Maintenance Groups for Maintenance Contxt3GROUPNAMECondition Maintenance Groupnvarchar100
20/SAPCND/GROUPCondition Maintenance Group2GROUPNAMECondition Maintenance Groupnvarchar100
21/SAPCND/GROUPTTexts for Groups of Condition Tables and Types2GROUPNAMECondition Maintenance Groupnvarchar100
22/SAPCND/GROUP_ICondtion Maintenance Definition2GROUPNAMECondition Maintenance Groupnvarchar100
23/SAPCND/GROUP_ITTexts for Permitted Cond. Tables and Types for Cond. Group2GROUPNAMECondition Maintenance Groupnvarchar100
TOPElectronic Data Interchange
24PRICAT_K010Price Catalog: Additional Catalog Fields6GROUPNAMEPrice Catalog: Group Name of Enhancement Structurenvarchar300
TOPEnd User Technology
25RSZWMDITEMBW Web Metadata: Template Item ( Dataprovider, Item, ... ).10GROUPNAMEBW Web Metadata: Template Item Namenvarchar300
26RSZWMDPARAMWeb Item, Dataprovider and command parameters16GROUPNAMEBW Web Metadata: Template Item Namenvarchar300
TOPInformation System
27FTIC_MTASKINGTreasury Position Mgmt Parallel Processing Control7GROUPNAMELogon/Server Group Namenvarchar200
TOPMonitoring
28ALPFREP_CATPerfDB Reporting Catalog7GROUPNAMEName of a Group (Part of a CPH Report Definition)nvarchar400
29ALSYSGRPSAlerts: Definition of R/3 System Groups1GROUPNAMEAlerts: Name of a System groupnvarchar300
TOPSAP Business Partner
30MDMEXTRFLD_PREFMDM Field Table Extractor Metadata (Copy)4GROUPNAMEMDM Field Group Extractor Metadata (Copy)nvarchar300
31MDMEXTRGRP_PREFMDM Field Group Extractor Metadata (Copy)4GROUPNAMEMDM Field Group Extractor Metadata (Copy)nvarchar300
32MDM_SEL_TRANS_PRMDM: Storage of Selections and Transfer Segments (Copy)6GROUPNAMELogical Name of a Group of Fieldsnvarchar300
TOPService Data Download
33/BDL/BDLGROUPSService Definition, Table of group descriptions4GROUPNAMEGroup namenvarchar200
34BDLGROUPSTable of group descriptions (reference table)3GROUPNAMEGroup namenvarchar200
TOPTraders and Schedulers Workbench
35OIGCCTD Compartment8GROUPNAMETD product/compartment groupnvarchar80
36TOIGBVTTD Vehicle Group Text3GROUPNAMETD vehicle groupnvarchar80
TOPTransportation and Distribution
37OIGSVCCTD Compartment in Shipment10GROUPNAMETD product/compartment groupnvarchar80
38TOIGACTD Product/Compartment Group2GROUPNAMETD product/compartment groupnvarchar80
39TOIGACITD Product/Compartment Group Indicators2GROUPNAMETD product/compartment groupnvarchar80
40TOIGACTTD Product/Compartment Group Text3GROUPNAMETD product/compartment groupnvarchar80
41TOIGAPTD Product Group2GROUPNAMETD product groupnvarchar80
42TOIGAPITD Product Group Indicators2GROUPNAMETD product groupnvarchar80
43TOIGAPTTD Product Group Text3GROUPNAMETD product groupnvarchar80
44TOIGBCTD Customer Group2GROUPNAMETD:customer compatibility groupnvarchar80
45TOIGBCITD Customer Group Indicators2GROUPNAMETD:customer compatibility groupnvarchar80
46TOIGBCTTD Customer Group Text3GROUPNAMETD:customer compatibility groupnvarchar80
47TOIGBVTD Vehicle Group2GROUPNAMETD vehicle groupnvarchar80
48TOIGBVITD Vehicle Group Indicators2GROUPNAMETD vehicle groupnvarchar80