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

148 tablesERP 6.0 

Auto-ID Infrastructure
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/AIN/ACTTYPE21Action TypeAuto-ID Infrastructure
2ERP EHP76.0/AIN/ACTTYPEBP41Relation of Action Type to Business Process, Device RoleAuto-ID Infrastructure
3ERP EHP76.0/AIN/ACTTYPET41Action Type description text tableAuto-ID Infrastructure
4ERP EHP76.0/AIN/ACT_PACKLEV51Customized Pack LevelsAuto-ID Infrastructure
5ERP EHP76.0/AIN/ACT_PCKLEVS41Default Pack LevelsAuto-ID Infrastructure
6ERP EHP76.0/AIN/BW_SETUP_I61Setup table for initial data upload to BW for internal dataAuto-ID Infrastructure
7ERP EHP76.0/AIN/DM_ACTION103ActionAuto-ID Infrastructure
8ERP EHP76.0/AIN/DM_ACT_OBJ243Action objectAuto-ID Infrastructure
9ERP EHP76.0/AIN/DM_AOBJ_CTX72Action Object Context (tag data history)Auto-ID Infrastructure
10ERP EHP76.0/AIN/DM_ATBP51Relation of Action Type to Business ProcessAuto-ID Infrastructure
11ERP EHP76.0/AIN/DM_ATDGR51Relation of Action Type to Device Group RoleAuto-ID Infrastructure
12ERP EHP76.0/AIN/DM_DEV43Device tableAuto-ID Infrastructure
13ERP EHP76.0/AIN/DM_DEVCS42Device Common Susbcription tableAuto-ID Infrastructure
14ERP EHP76.0/AIN/DM_DEVCS_AT51Attribute List of Common Subscription tableAuto-ID Infrastructure
15ERP EHP76.0/AIN/DM_DEVCS_DG31Device Group List of Common Susbcription tableAuto-ID Infrastructure
16ERP EHP76.0/AIN/DM_DEVCS_EV31Event List of Common Subscription tableAuto-ID Infrastructure
17ERP EHP76.0/AIN/DM_DEVCS_FI41Filter List of Common SubscriptionAuto-ID Infrastructure
18ERP EHP76.0/AIN/DM_DEVCTR62Device-controller tableAuto-ID Infrastructure
19ERP EHP76.0/AIN/DM_DEVCTRT41Device-controller text tableAuto-ID Infrastructure
20ERP EHP76.0/AIN/DM_DEVGRP83Device group tableAuto-ID Infrastructure
21ERP EHP76.0/AIN/DM_DEVGRPT41Device-group text tableAuto-ID Infrastructure
22ERP EHP76.0/AIN/DM_DEVT41Device text tableAuto-ID Infrastructure
23ERP EHP76.0/AIN/DM_DOC132Table with Document information.Auto-ID Infrastructure
24ERP EHP76.0/AIN/DM_DOC_CTX92Document Context TableAuto-ID Infrastructure
25ERP EHP76.0/AIN/DM_DOC_ITM121Document-item tableAuto-ID Infrastructure
26ERP EHP76.0/AIN/DM_DOC_OBIT91Document-object itemsAuto-ID Infrastructure
27ERP EHP76.0/AIN/DM_DOC_OBJ162Document object informationAuto-ID Infrastructure
28ERP EHP76.0/AIN/DM_DOC_STA52Document statusAuto-ID Infrastructure
29ERP EHP76.0/AIN/DM_LOC122Location tableAuto-ID Infrastructure
30ERP EHP76.0/AIN/DM_LOCMAP62Auto-ID: Location MappingAuto-ID Infrastructure
31ERP EHP76.0/AIN/DM_LOCT41Locations descriptionAuto-ID Infrastructure
32ERP EHP76.0/AIN/DM_LOC_CODE41Company prefix and issue agency tableAuto-ID Infrastructure
33ERP EHP76.0/AIN/DM_OBJECT235ObjectAuto-ID Infrastructure
34ERP EHP76.0/AIN/DM_OBJ_CTX62Object Context (object user data)Auto-ID Infrastructure
35ERP EHP76.0/AIN/DM_UE_NOTE102Annotation for unexpected eventsAuto-ID Infrastructure
36ERP EHP76.0/AIN/IF_TEST_MSG61Test Message database tableAuto-ID Infrastructure
37ERP EHP76.0/AIN/PRN_DEV_PRT31Device group associations between devices and printersAuto-ID Infrastructure
38ERP EHP76.0/AIN/TACTIVITY41Activity tableAuto-ID Infrastructure
39ERP EHP76.0/AIN/TACTIVITYT41Activity text tableAuto-ID Infrastructure
40ERP EHP76.0/AIN/TACT_PARDEF41Activity parameter defintionAuto-ID Infrastructure
41ERP EHP76.0/AIN/TACT_PART51Activity parameter text tableAuto-ID Infrastructure
42ERP EHP76.0/AIN/TACT_PARVAL61Rule activity parameter valuesAuto-ID Infrastructure
43ERP EHP76.0/AIN/TACT_PAR_AV41Table for allowed values for activity parametersAuto-ID Infrastructure
44ERP EHP76.0/AIN/TAPPL_LOG31Message Type Application log enablingAuto-ID Infrastructure
45ERP EHP76.0/AIN/TBC_AIASSG41Barcode Customizing: Assignment of Applic. Identifier TypeAuto-ID Infrastructure
46ERP EHP76.0/AIN/TBC_AIDEF141Barcode Customizing: Definition of Application IdentifierAuto-ID Infrastructure
47ERP EHP76.0/AIN/TBC_AIDEFT61Descriptions of the AI DefinitionAuto-ID Infrastructure
48ERP EHP76.0/AIN/TBC_AITYDEF71Barcode Customizing: Definition of Applic. Identifier TypeAuto-ID Infrastructure
49ERP EHP76.0/AIN/TBW_URL31BI Query URL linksAuto-ID Infrastructure
50ERP EHP76.0/AIN/TCCMS_LOG21Message Type CCMS log enablingAuto-ID Infrastructure
51ERP EHP76.0/AIN/TCONDBM61Condition table for Backend MessagesAuto-ID Infrastructure
52ERP EHP76.0/AIN/TCONDBMS51Condition table for Backend MessagesAuto-ID Infrastructure
53ERP EHP76.0/AIN/TCONDBMT61Text table for /AIN/TCONDBMAuto-ID Infrastructure
54ERP EHP76.0/AIN/TCONDBMTS51Text table for /AIN/TCONDBMSAuto-ID Infrastructure
55ERP EHP76.0/AIN/TCONDFRM71Condition table for RFID Device MessagesAuto-ID Infrastructure
56ERP EHP76.0/AIN/TCONDFRMT71Text table /AIN/TCONDFRMAuto-ID Infrastructure
57ERP EHP76.0/AIN/TCONDMM71Condition table for Mobile MessagesAuto-ID Infrastructure
58ERP EHP76.0/AIN/TCONDMMS61Condition table for Mobile MessagesAuto-ID Infrastructure
59ERP EHP76.0/AIN/TCONDMMT71Text table for Mobile Message condition tableAuto-ID Infrastructure
60ERP EHP76.0/AIN/TCONDMMTS61Text table for Mobile Message condition tableAuto-ID Infrastructure
61ERP EHP76.0/AIN/TCONDTMP41Template for condition tablesAuto-ID Infrastructure
62ERP EHP76.0/AIN/TDCMSGMAP51Device Controller message mappingAuto-ID Infrastructure
63ERP EHP76.0/AIN/TDCMSGSER41Device Controller message serializingAuto-ID Infrastructure
64ERP EHP76.0/AIN/TDCTYPE21Device Controller TypeAuto-ID Infrastructure
65ERP EHP76.0/AIN/TDCTYPET31Device Controller typeAuto-ID Infrastructure
66ERP EHP76.0/AIN/TDEV_EVENT21Device Event for SubscriptionAuto-ID Infrastructure
67ERP EHP76.0/AIN/TDEV_EVENTT41Device Event TextAuto-ID Infrastructure
68ERP EHP76.0/AIN/TDGROLE21Values for Business Role of a Device GroupAuto-ID Infrastructure
69ERP EHP76.0/AIN/TDGROLET41Values for Business Role of a Device GroupAuto-ID Infrastructure
70ERP EHP76.0/AIN/TDGTYPE21Values for Device-group TypesAuto-ID Infrastructure
71ERP EHP76.0/AIN/TDGTYPET41Values for Device-group TypesAuto-ID Infrastructure
72ERP EHP76.0/AIN/TDOCASSIGN61Table for document <-> device group assignmentsAuto-ID Infrastructure
73ERP EHP76.0/AIN/TDOD1_NRRAN91DOD Tag Data Construct #1 Number RangeAuto-ID Infrastructure
74ERP EHP76.0/AIN/TEPC_ACTVER21EPC Tag Data Standards Active Version TableAuto-ID Infrastructure
75ERP EHP76.0/AIN/TEPC_PREFIX51Company PrefixAuto-ID Infrastructure
76ERP EHP76.0/AIN/TEPC_PRTTN81PartitionsAuto-ID Infrastructure
77ERP EHP76.0/AIN/TEPC_TYPE91Header and URI FormatAuto-ID Infrastructure
78ERP EHP76.0/AIN/TEPC_VER31EPC Tag Data Standards Version TableAuto-ID Infrastructure
79ERP EHP76.0/AIN/TEPC_VERT41Text: EPC Tag Data Standards Version TableAuto-ID Infrastructure
80ERP EHP76.0/AIN/TGIAI_NRRAN111GIAI Number RangeAuto-ID Infrastructure
81ERP EHP76.0/AIN/TGRAI_NRRAN91GRAI Number RangeAuto-ID Infrastructure
82ERP EHP76.0/AIN/TGTIN_NRRAN121GTIN Number RangeAuto-ID Infrastructure
83ERP EHP76.0/AIN/TID_AGENCY21Issuing AgencyAuto-ID Infrastructure
84ERP EHP76.0/AIN/TID_AGENCYT41Issuing AgencyAuto-ID Infrastructure
85ERP EHP76.0/AIN/TID_CONV21Conversion Table: ASCII <-> Binary for Cage CodeAuto-ID Infrastructure
86ERP EHP76.0/AIN/TID_FILVAL41Filter Value DescriptionAuto-ID Infrastructure
87ERP EHP76.0/AIN/TID_FILVALT61Filter ValueAuto-ID Infrastructure
88ERP EHP76.0/AIN/TID_ISSUE51Issueing AgencyAuto-ID Infrastructure
89ERP EHP76.0/AIN/TID_OBJGEN71Object GenerationAuto-ID Infrastructure
90ERP EHP76.0/AIN/TID_OBJREF81Object RefrenceAuto-ID Infrastructure
91ERP EHP76.0/AIN/TID_SCHEMA91ID SchemaAuto-ID Infrastructure
92ERP EHP76.0/AIN/TID_URN71URN Format of IDsAuto-ID Infrastructure
93ERP EHP76.0/AIN/TLOCEXTTYPE21Define External Location TypesAuto-ID Infrastructure
94ERP EHP76.0/AIN/TLOCEXTTYPT41External Location Types DescriptionsAuto-ID Infrastructure
95ERP EHP76.0/AIN/TMSG_COND51Condition Type tableAuto-ID Infrastructure
96ERP EHP76.0/AIN/TMSG_CONDS51Condition Type tableAuto-ID Infrastructure
97ERP EHP76.0/AIN/TMSG_CONDT51Text table for /AIN/TMSG_CONDAuto-ID Infrastructure
98ERP EHP76.0/AIN/TMSG_CONDTS51Text table for /AIN/TMSG_CONDSAuto-ID Infrastructure
99ERP EHP76.0/AIN/TMSG_TYPE21Message Type TableAuto-ID Infrastructure
100ERP EHP76.0/AIN/TMSG_TYPET41Message Type text tableAuto-ID Infrastructure
101ERP EHP76.0/AIN/TPRFATTRB21Attribute of ElementAuto-ID Infrastructure
102ERP EHP76.0/AIN/TPRFATTRBT41Attribute descriptionAuto-ID Infrastructure
103ERP EHP76.0/AIN/TPRFELEMATR61Attribute of element in an elementsetAuto-ID Infrastructure
104ERP EHP76.0/AIN/TPRFELEMENT52Elements of element setAuto-ID Infrastructure
105ERP EHP76.0/AIN/TPRFELEMSET42Element SetAuto-ID Infrastructure
106ERP EHP76.0/AIN/TPRFELESETT51Element Set TextAuto-ID Infrastructure
107ERP EHP76.0/AIN/TPRFELMENT31DOES NOT Contain any entry. Only used for namespace checkAuto-ID Infrastructure
108ERP EHP76.0/AIN/TPRFELMENTT51Description of elementAuto-ID Infrastructure
109ERP EHP76.0/AIN/TPRFETYPUSE31Element usage and type relationshipAuto-ID Infrastructure
110ERP EHP76.0/AIN/TPRFPRFESET61Element sets of a profile and their usageAuto-ID Infrastructure
111ERP EHP76.0/AIN/TPRFTYP_USE31Profile Type and element set usage relationshipAuto-ID Infrastructure
112ERP EHP76.0/AIN/TPRF_PROFIL31Profile DefinitionAuto-ID Infrastructure
113ERP EHP76.0/AIN/TPRF_PROFT51Description of profileAuto-ID Infrastructure
114ERP EHP76.0/AIN/TPRNFILTER61Condition Table for Tag Comm: Filter Value -> ProfileAuto-ID Infrastructure
115ERP EHP76.0/AIN/TPRNGRAIFLT71Condition Table for Tag Comm: GRAI, Filter Value -> ProfileAuto-ID Infrastructure
116ERP EHP76.0/AIN/TPRNGTINFLT71Condition Table for Tag Comm: GTIN, Filter Value -> ProfileAuto-ID Infrastructure
117ERP EHP76.0/AIN/TPRNGTNFLPR41Profile determination using GTIN and Filter valueAuto-ID Infrastructure
118ERP EHP76.0/AIN/TPRN_FORMAT41Label format determination based on Printer and profileAuto-ID Infrastructure
119ERP EHP76.0/AIN/TRULE_ACT61Rule activitiesAuto-ID Infrastructure
120ERP EHP76.0/AIN/TRULE_ID21Rule Id tableAuto-ID Infrastructure
121ERP EHP76.0/AIN/TRULE_IDT41Rule ID text tableAuto-ID Infrastructure
122ERP EHP76.0/AIN/TSSCC_NRRAN91SSCC Number RangeAuto-ID Infrastructure
123ERP EHP76.0/AIN/TUIBUSPGRAI51UI User Data: Business Process, GRAI -> ProfileAuto-ID Infrastructure
124ERP EHP76.0/AIN/TUIBUSPROC61UI User Data: Business Process -> ProfileAuto-ID Infrastructure
125ERP EHP76.0/AIN/TUI_URL21Desktop WebUI URL linksAuto-ID Infrastructure
126ERP EHP76.0/AIN/TU_ENS_ASGN31AutoID Error Namespace AssignmentAuto-ID Infrastructure
127ERP EHP76.0/AIN/TU_ERR_DESC31Auto-ID Tag Error Description DefinitionAuto-ID Infrastructure
128ERP EHP76.0/AIN/TU_ERR_DEST51Auto-ID Tag Error Description DefinitionAuto-ID Infrastructure
129ERP EHP76.0/AIN/TU_ERR_MAP61AutoID Mapping Vendor Specific Error to NamespaceAuto-ID Infrastructure
130ERP EHP76.0/AIN/TU_ERR_NS21AutoID Error Profile DefinitionAuto-ID Infrastructure
131ERP EHP76.0/AIN/TU_ERR_NST41AutoID ErrorProfile DefinitionAuto-ID Infrastructure
132ERP EHP76.0/AIN/TU_FLD_NAM31Tag field name definitionAuto-ID Infrastructure
133ERP EHP76.0/AIN/TU_FLD_NAMT51Tag field name text descriptionsAuto-ID Infrastructure
134ERP EHP76.0/AIN/TU_TAG_ASGN41AutoID Tag Format AssignmentAuto-ID Infrastructure
135ERP EHP76.0/AIN/TU_TAG_FLD91AutoID Tag Field DefinitionAuto-ID Infrastructure
136ERP EHP76.0/AIN/TU_TAG_FLDT61AutoID Tag Field DefinitionAuto-ID Infrastructure
137ERP EHP76.0/AIN/TU_TAG_FORM21AutoID Tag Format DefinitionAuto-ID Infrastructure
138ERP EHP76.0/AIN/TU_TAG_FORT41Text table for tag format descriptionAuto-ID Infrastructure
139ERP EHP76.0/AIN/TXIMSG41XI Messages and Mapping definitionAuto-ID Infrastructure
140ERP EHP76.0/AIN/T_BUS_PRO21Business ProcessAuto-ID Infrastructure
141ERP EHP76.0/AIN/T_BUS_PRO_T41Business Process DescriptionAuto-ID Infrastructure
142ERP EHP76.0/AIN/T_UE_RSN31Reason Code for Unexpected EventAuto-ID Infrastructure
143ERP EHP76.0/AIN/T_UE_RSN_T51Reason Code Text for Unexpected EventAuto-ID Infrastructure
144ERP EHP76.0/AIN/T_UPD_BW41BI update indicatorsAuto-ID Infrastructure
145ERP EHP76.0/AIN/T_UPD_CCMS41CCMS update indicatorsAuto-ID Infrastructure
146ERP EHP76.0/AIN/UI_PARAM51Default user settingsAuto-ID Infrastructure
147ERP EHP76.0AIN_PROD_TGRAI101GRAI-Global Returnable Asset IdentifierAuto-ID Infrastructure
148ERP EHP76.0AIN_PROD_TGRAIH101GRAI-Global Returnable Asset IdentifierAuto-ID Infrastructure