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

67 columns | Print definition?ERP 6.0  | LINE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DIAN_A_1001_08Cached Data of DIAN Format 1001 version 083LINE_IDGlobally Unique Identifiervarbinary160
2DIAN_A_1003_07Cached Data of DIAN Format 1003 version 073LINE_IDGlobally Unique Identifiervarbinary160
3DIAN_A_1005_07Cached Data of DIAN Format 1005 version 073LINE_IDGlobally Unique Identifiervarbinary160
4DIAN_A_1006_07Cached Data of DIAN Format 1006 version 073LINE_IDGlobally Unique Identifiervarbinary160
5DIAN_A_1007_08Cached Data of DIAN Format 1007 version 083LINE_IDGlobally Unique Identifiervarbinary160
6DIAN_A_1008_07Cached Data of DIAN Format 1003 version 073LINE_IDGlobally Unique Identifiervarbinary160
7DIAN_A_1009_07Cached Data of DIAN Format 1009 version 073LINE_IDGlobally Unique Identifiervarbinary160
8DIAN_A_EXTRACTCached Extraction of DIAN Report5LINE_IDGlobally Unique Identifiervarbinary160
9DIAN_A_EXTR_INFODocuments information related to the extracted DIAN data2LINE_IDGlobally Unique Identifiervarbinary160
10DIAN_A_TFORMATTesting table for Cached Data of DIAN Formats3LINE_IDGlobally Unique Identifiervarbinary160
11DIAN_C_ACCOUNTSDIAN Accounts5LINE_IDGlobally Unique Identifiervarbinary160
12DIAN_C_VAT_1001Additional VAT Settings for Format 10015LINE_IDGlobally Unique Identifiervarbinary160
13DIAN_C_VAT_CONSTVAT Concept Settings5LINE_IDGlobally Unique Identifiervarbinary160
14DIAN_C_VAT_FORSTDIAN VAT Format Settings4LINE_IDGlobally Unique Identifiervarbinary160
15DIAN_C_WTHDIAN Withholding Tax5LINE_IDGlobally Unique Identifiervarbinary160
16DIAN_C_WTH_1001Additional Withholding Settings for Format 10015LINE_IDGlobally Unique Identifiervarbinary160
17DVM_BOF_STATSBusiness Objects Footprint statistics3LINE_IDGUID in 'RAW' formatvarbinary160
18J_3RFIMCD_MOVECross company transfer. Import Customs Declaration5LINE_IDCross-Company Movement ID for Import Customs Declarationnvarchar50
TOPAccounting Engine
19/EACC/CONFIGS_LIConfigurations6LINE_IDField Namenvarchar300
TOPBasic Functions
20EMMAC_CCAT_CNDConditions for Case Determination or Priority5LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
TOPBusiness Process Engine
21SWFBRULECOMBAM: Client-Specific Conditions7LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
22SWFBRULECOUBAM: Cross-Client Condition6LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
TOPClassification System New
23CHARACTERTEXTDML Text Object23LINE_IDRow Keynvarchar50
24CHARACTERTEXTHDML Text Object23LINE_IDRow Keynvarchar50
25CME_ST_R3_DEPCME Characteristic: Object Dependencies for R/3 Characterstc14LINE_IDRow Keynvarchar50
26CME_ST_R3_DEPHCME Characteristic: Object Dependencies for R/3 Characterstc14LINE_IDRow Keynvarchar50
27CME_ST_REFCharacteristic: Data Reference17LINE_IDRow Keynvarchar50
28CME_ST_REFHCharacteristic: Data Reference17LINE_IDRow Keynvarchar50
29CME_ST_VALUECME Data Type: Values3LINE_IDRow Keynvarchar50
30CME_ST_VALUEHCME Data Type: Values4LINE_IDRow Keynvarchar50
31CME_ST_VAL_TXTDML Text Object23LINE_IDRow Keynvarchar50
32CME_ST_VAL_TXTHDML Text Object23LINE_IDRow Keynvarchar50
33DEFSCOPETEXTDML Text Object23LINE_IDRow Keynvarchar50
34DEFSCOPETEXTHDML Text Object23LINE_IDRow Keynvarchar50
35DTYPETEXTDML Text Object23LINE_IDRow Keynvarchar50
36DTYPETEXTHDML Text Object23LINE_IDRow Keynvarchar50
TOPConfirmations
37AFFWGoods Movements with Errors from Confirmations75LINE_IDUnique identification of document linenvarchar60
TOPEvent Management
38/SAPTRX/CONDDATACondition data table5LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
TOPFunds Management
39FMFGF2EDPRFEdit 8- SF 133 Proof Edit (FACTS II)2LINE_IDSF 133 Line IDnvarchar40
TOPHydrocarbon Product Management
40MSEGO1Quantity Conversion Parameters for Material Documents5LINE_IDUnique identification of document linenvarchar60
41MSEGO2Material Document Quantities in Additional Units of Measure6LINE_IDUnique identification of document linenvarchar60
42OIB_MIGO_HQCIStore the QCI-GOITEM for MIGOs hold/restore feature2LINE_IDUnique identification of document linenvarchar60
43OIB_MIGO_HQCI_EStore the QCI-GOITEM-Bapiret for MIGOs hold/restore feature2LINE_IDUnique identification of document linenvarchar60
44OIB_MIGO_HQCI_PStore the QCI-GOITEM-Parameter for MIGOs hold/restore featur2LINE_IDUnique identification of document linenvarchar60
45OIB_MIGO_HQCI_QStore the QCI-GOITEM-Quantity for MIGOs hold/restore feature2LINE_IDUnique identification of document linenvarchar60
46OIB_MIGO_HTSTStore the TST-GOITEM for MIGOs hold/restore feature2LINE_IDUnique identification of document linenvarchar60
TOPInventory Management
47MSEGDocument Segment: Material5LINE_IDUnique identification of document linenvarchar60
48MWXMSEGZMSEG: Interface for Posting of Value5LINE_IDUnique identification of document linenvarchar60
49MWZMSEGZMSEG:Interface for Posting of Value5LINE_IDUnique identification of document linenvarchar60
TOPLocal Event Infrastructure
50SLEI_CONDITIONLEI conditions - Cross client3LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
51SLEI_CONDITION_CLEI conditions - Client specific4LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
TOPMaintenance Orders
52/MRSS/D_RSBUFDATResource Buffering Data3LINE_IDNumc3, internal usenvarchar30
TOPManufacturer Part Number
53ADPIC_HOLD_MIGOStore BADI goitem for MIGO hold / restore functionality2LINE_IDUnique identification of document linenvarchar60
54ADPIC_HOLD_MPNStore MPN subitems for MIGO hold / restore functionality2LINE_IDUnique identification of document linenvarchar60
TOPMaster Data Framework
55DML_DELIVERY_TXTMDF Text Object19LINE_IDRow Keynvarchar50
56DML_ST_TEXTDML Text Object23LINE_IDRow Keynvarchar50
57DML_ST_TEXTHDML Text Object23LINE_IDRow Keynvarchar50
TOPPurchasing
58EKBE_SCComponent Consumption History for Subcontracting7LINE_IDUnique identification of document linenvarchar60
TOPRepetitive Manufacturing
59COMPMOVEGoods Movement of Components4LINE_IDUnique identification of document linenvarchar60
TOPSAP Business Workflow
60SWBRULEBINWF: Runtime Representation of a Rule6LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
61SWBRULECOMWF: Client-specific start conditions8LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
62SWBRULECOUWF: Connecting Condition/Context to Event Linkage7LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
63SWDSCONDEFWF Definition: Conditions8LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
64SWD_CONDEFWF Definition/Runtime: Conditions9LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
65SWECDFIELDCombined field restrictions for change document4LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
66SWJPCONDParameter Condition (Parsed)4LINE_IDCondition Editor: Line Number in Internal Displaynvarchar30
TOPTariffs, Duties and Permits
67OIH_MIGO_HTDPStore the TDP-GOITEM for MIGOs hold/restore feature2LINE_IDUnique identification of document linenvarchar60