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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

85 columns | Print definition?ERP 6.0  | TABKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BTP_TPL_DELKEYBTP: Deleted table keys that have to be transported5TABKEYObject Name in Object Listnvarchar1200
2CDPOSChange document items6TABKEYChanged table record keynvarchar700
3CNVMBTSPEZTABKEYKeys for specific rules for copy-/load-scenario7TABKEYnvarchar1200
4DMC_IU_E071KMWB Upgrade: Table E071K11TABKEYObject Name in Object Listnvarchar1200
5DMC_MDS_SOBJKIUUC: dyn maint event saving of e071k for logical w/o aim10TABKEYObject Name in Object Listnvarchar1200
6EXP_USASCIException handling non US ASCII keys5TABKEYObject Name in Object Listnvarchar1200
7GTABKEYEXC20Exception List: Global Key Check7TABKEYObject Name in Object Listnvarchar1200
8GTABKEYEXC_ARCHException List: Global Key Check7TABKEYObject Name in Object Listnvarchar1200
9GTABKEY_ARCHIVEGlobal Key Entries from Requests/Tasks3TABKEYObject Name in Object Listnvarchar1200
10MDS_E071KMDS: E071K to a specific simulation version11TABKEYObject Name in Object Listnvarchar1200
11OCS_CP_E071KTLOGO E071K für CP TR: Schlüsseleinträge10TABKEYObjektname in der Objektlistenvarchar1200
12OCS_CP_E071K_STRTLOGO E071K_STR für CP TR: Schlüsseleinträge mit Strngfelder10TABKEYOCS / Transportsystem: Stringntext10737418230
13PCDPOSChange document items6TABKEYChanged table record keynvarchar700
14SCTS_TRACK_KEYcCTS: Helper for key persistence for object level tracking6TABKEYObject Name in Object Listnvarchar1200
TOPAdvertising Management
15JHCPCONVIS-M/AM: Contact Person - Conversion Information4TABKEYIS-M/AM: Table Key (Length 64)nvarchar640
TOPALE Integration Technology
16BDCPChange pointer4TABKEYTable Key for CDPOS in Character 254nvarchar2540
17BDCP2Aggregated Change Pointers (BDCP, BDCPS)6TABKEYTable Key for CDPOS in Character 254nvarchar2540
TOPApplication Framework
18MDG_TR_E071KObject List for Client Copy (Key)11TABKEYObject Name in Object Listnvarchar1200
TOPAssortment
19WRF_APC_PADAPlanned Article Dynamic Attributes4TABKEYConcatenated Key Fields for Dynamic Attributesnvarchar400
TOPAudit trail enhancements ILM
20AUT_D_ILM_CDPOSAudit Trail (ILM): Storage Change Document Items (ILM)7TABKEYChanged table record keynvarchar700
21AUT_D_ILM_CD_STRAudit Trail (ILM): Storage for Change Docs (STRING Values)8TABKEYTable Key for CDPOS in Character 254nvarchar2540
22AUT_D_ILM_CD_UIDAudit Trail (ILM): Storage of Addl Data (TABKEY > 70 Chars)8TABKEYTable Key for CDPOS in Character 254nvarchar2540
TOPBank
23TIBANIBAN11TABKEYIBAN origin: Key to table of bank detailsnvarchar240
TOPBasic Functions
24WTMIG_TABKEYWithholding Tax Changeover: Keys of Table Entries Added4TABKEYTable Keynvarchar200
TOPBRFplus - ABAP-Based Business Rules
25FDT_E071KFDT Transport Request: Persistent Requests - Key Entries8TABKEYObject Name in Object Listnvarchar1200
TOPBusiness Configuration Sets
26SCPRACTRBC Set: Active records in Local System4TABKEYBC Sets: BC Set activation error table keynvarchar2550
TOPChange Documents
27CDPOS_STRAdditional Change Document - Table for STRINGs7TABKEYTable Key for CDPOS in Character 254nvarchar2540
28CDPOS_UIDAdditional Table for Inclusion of TABKEY>70 Characters7TABKEYTable Key for CDPOS in Character 254nvarchar2540
29PCDPOS_STRAdditional Planned Change Document: Table for STRINGs7TABKEYTable Key for CDPOS in Character 254nvarchar2540
30PCDPOS_UIDAdditional Table for Inclusion of TABKEY>70 Chars-Plnnd Chg.7TABKEYTable Key for CDPOS in Character 254nvarchar2540
TOPContract Accounts Receivable and Payable
31DFKKBICObsolete12TABKEYKey of Changed Objectnvarchar350
32DFKKBICLFI-CA Batch Input - Error Change Logs12TABKEYKey of Changed Objectnvarchar350
33DFKKCOLI_LOGCollection Agency Information File: Communication Log18TABKEYChanged table record keynvarchar700
34DFKKCOLLP_IM_WBuffer: Coll. Agency Info File (Item Master Data Change)8TABKEYChanged table record keynvarchar700
35DFKKCOLL_CHCollection: Changes to Business Partner Master Data8TABKEYChanged table record keynvarchar700
36DFKKDOCFI-CA DMS: Administrative Data of Documents26TABKEYTable Keynvarchar1200
37FKKMAKTDunning activities10TABKEYTable Keynvarchar1200
TOPCross-Application Components
38/IXOS/AX_TDELTAtable for update and delta management3TABKEYshort key of database tablenvarchar1320
39/IXOS/AX_TDELTALtable for update and delta management4TABKEYcomplete key of database tablenvarchar2550
40/IXOS/AX_TOUTBOXOutbox6TABKEYcomplete key of database tablenvarchar2550
TOPCross-System Tools
41SCDT_E071K_TRIGGDistribution Polling Trigger Buffer10TABKEYObject Name in Object Listnvarchar1200
TOPCustomer Enhancements
42ENHTABEnhancements for Tables4TABKEYTable Keynvarchar1200
TOPData Replication Framework
43MDGD_CP_TABFIELDTable and fieldnames which lead to creation of ch.point5TABKEYTable Key for CDPOS in Character 254nvarchar2540
TOPFinancials Basis
44FINB_TR_E071KObject List for Client Copy (Key)11TABKEYObject Name in Object Listnvarchar1200
TOPFunctions for U.S. Federal Government
45FMFG_MM_PEND_CHGPurchasing document changes requiring Notification approvl7TABKEYTable key valuenvarchar400
TOPGRC Process Control Plug-in
46/GRCPI/GRIADBLOGAM - Table of GRC log records for table changes6TABKEYTable Keynvarchar1200
47/GRCPI/GRIASNAPAM - Capture snapshot of change log3TABKEYTable Keynvarchar1200
TOPIntegration Engine
48SXMSTESTCHECKCheck-Table1TABKEYGUID for Integration Engine Objectsvarbinary160
TOPLanguage Transport
49TLANTESTLanguage Transport: Test Table1TABKEYLanguage Transport IDnvarchar100
50TLANTESTCLLanguage Transport: Test Table2TABKEYLanguage Transport IDnvarchar100
TOPMaterial Master
51WRF_DISCONT_ERRError Log and Valuation Levels - Seas. Proc. Discontinuation18TABKEYInternal ABAP/4 textnvarchar700
TOPNon Profit Organizations
52T7UNCMT_RETROTriggers for Retrocalculation3TABKEYObject Name in Object Listnvarchar1200
TOPOnline Correction Support Support Package and Add-On Tools
53PAD71KKeys of Table Entries Contained in a Patch10TABKEYObject Name in Object Listnvarchar1200
TOPPayment Cards
54CCSEC_LOGLogging of Access to Payment Card Numbers3TABKEYTable Keynvarchar1200
TOPProcess Controls -Automated Controls
55GRPCRTA_DBTABLOGGRC Table of log records for table changes6TABKEYTable Keynvarchar1200
56GRPCRTA_GRPCSNAPGRC Change Log: Capture snapshot of change log3TABKEYTable Keynvarchar1200
57GRPCRTA_TCHLOGChange log : Changed data10TABKEYTable Keynvarchar1200
58GRPCRTA_TSNAPChange log : Capture snapshot of change log3TABKEYTable Keynvarchar1200
TOPRecipe Development
59/PLMB/RCP_T_LOGDCreated Testdata Directory3TABKEYTable Keynvarchar1200
TOPRecycling Administration Core Functions
60J_7LC47REA Customizing: Customer Enhancement2TABKEYREA Customizing: Key for Customer-Specific Enhancementnvarchar100
61J_7LC47TREA Customizing: Customer Enhancement Text Table3TABKEYREA Customizing: Key for Customer-Specific Enhancementnvarchar100
62J_7LC47WREA Customizing: Customer Enhancement (Internal Table)2TABKEYREA Customizing: Key for Customer-Specific Enhancementnvarchar100
TOPRegulatory reporting for insurance companies
63TISSR_GP_CHANGEISSR: Tabelle zur Aufnahme der Informationen zur GP-Änderung9TABKEYKey der geaenderten Tabellenzeilenvarchar700
TOPSAP Business Partner
64BUT_TDMISSBP Non-Distributable Time-Dependent Data (from BUT_TDTRANS)6TABKEYChanged table record keynvarchar700
65BUT_TDTRANSBP: Index Table for Distributing Time-Dependent Data5TABKEYChanged table record keynvarchar700
TOPSAP Note Assistant
66STABULOGLog of Customer Modifications of Table Entries5TABKEYObject Name in Object Listnvarchar1200
TOPTechnical Objects
67EAML_D_LFE_CDOCLinear Data3TABKEYTable Key of Reference Objectnvarchar300
68EAML_D_LFE_DATALinear Asset Management - Database3TABKEYTable Key of Reference Objectnvarchar300
TOPTranslation Tools
69LWRKKEYKey for Worklists8TABKEYObject Name in Object Listnvarchar1200
70LXE_LOGSE63 - Recording of Processed Objects5TABKEYObject Name in Object Listnvarchar1200
71LXE_WRKKEYKey for Worklists8TABKEYObject Name in Object Listnvarchar1200
72SKTYREMKRemarks Relating to Translation Objects4TABKEYKey field for remarksnvarchar1000
TOPTransport Organizer
73E071KChange & Transport System: Key Entries of Requests/Tasks10TABKEYObject Name in Object Listnvarchar1200
74E071KS_PREVIEWTransport Request Preview: Key Entries with Strings10TABKEYCTS: Stringntext10737418230
75E071K_STRKey Entries with String Fields of Requests/Tasks10TABKEYCTS: Stringntext10737418230
76E071K_STR_SHADOWCopy of E071K_STR_SHADOW, String Replaced By Long Char10TABKEYchar 1300nvarchar13000
77E071K__PREVIEWTransport Request Preview: Key Entries of a Request10TABKEYObject Name in Object Listnvarchar1200
78GTABKEYGlobal Key Entries from Requests/Tasks3TABKEYObject Name in Object Listnvarchar1200
79GTABKEY_LOCALGlobal Key Entries from Requests/Tasks3TABKEYObject Name in Object Listnvarchar1200
TOPUpgrade Tools
80CRR_MDS_SOBJKCRR IUU: dyn maint event saving of e071k for logical w/o aim10TABKEYObject Name in Object Listnvarchar1200
TOPUser and Authorization Management
81USARC_CDREDReloaded Archived Change Documents for User Data9TABKEYChanged table record keynvarchar700
TOPWaste Management
82EWA_ORDER_HD_COHeader Table for Waste Disposal Order (CO Data)76TABKEYKey for Sender Cost Center Categorynvarchar1200
83EWA_ORDER_OBJ_COItem Table in Waste Disposal Order (CO Data)77TABKEYKey for Sender Cost Center Categorynvarchar1200
84EWA_ORDER_WGH_COWeighing Data Table for Waste Disposal Order (CO Data)77TABKEYKey for Sender Cost Center Categorynvarchar1200
85EWA_WA_WPROC_COWeighing Transaction (CO Data)76TABKEYKey for Sender Cost Center Categorynvarchar1200