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

130 columns | Print definition?ERP 6.0  | UUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/FISC_REQFiscalization Croatia: Communication Log Request2UUIDUUID of the Messagenvarchar360
2/CCEE/FISC_RESFiscalization Croatia: Communication Log Response2UUIDUUID of the Messagenvarchar360
3/XLSO/NEW_COURSENew Course Requirement2UUIDNew Course IDnvarchar220
4ACMTST_DB_ADACMTST: Address (DB-Table)2UUIDACMTST: Globally unique-ID - PrimaryKey of all ACMTST-Tablesvarbinary160
5ACMTST_DB_BPAACMTST: Business Partner (DB-Table)2UUIDACMTST: Globally unique-ID - PrimaryKey of all ACMTST-Tablesvarbinary160
6ACMTST_DB_EMPLACMTST: Employee (DB-Table)2UUIDACMTST: Globally unique-ID - PrimaryKey of all ACMTST-Tablesvarbinary160
7ACMTST_DB_SOACMTST: Sales Order Header (DB-Table)2UUIDACMTST: Globally unique-ID - PrimaryKey of all ACMTST-Tablesvarbinary160
8AMC_LOAD_TESTAMC load test table1UUID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
9CFDI_RESP_MXMX: CFDI Response Details11UUIDUUID: Unique Identifiernvarchar360
10CNVCMIS_A_1_CLASStores repository information about 'CLAS' object for CMIS7UUIDUUID in X form (binary)varbinary160
11DDNTT3UUIDvarbinary160
12DDNTT_CONV_UC3UUIDvarbinary160
13DDNTT_HIST4UUIDvarbinary160
14DDREPLINTABHDDD: Nametab Header Structure (for Temporary Storage)5UUIDGlobal Unique ID for tablevarbinary160
15DDXTT_CONV_UCNametab Headerstruktur für verzögertes Schreiben4UUIDGlobale eindeutige Id für Dictionary-Objektvarbinary160
16DDYTT_CONV_UCUsed during UCMIG within DMO of SUM4UUIDGlobal Unique ID for tablevarbinary160
17EINV_GENDATA_TRTurkey e-Invoice Generation(Request/Rsponse) Data6UUIDTurkey e-Invoice UUIDnvarchar360
18FMBASOBJNR_TRACETrace for table FMBASOBJNR2UUID16 Byte UUID in 22 Characters (Usually Base 64 Encoded)nvarchar220
19IUUC_DD_SYNC_NTHSystem synchronization: Nametab header fields8UUIDGlobal Unique ID for tablevarbinary160
20IWP_LR_SEL_FIELDLocal Reporting Selection Criteria fields2UUIDUUID in character formnvarchar320
21N1SE_DOMAINISHMED: Table for Search Domain3UUIDCharacter field, length 32nvarchar320
22N1SE_INDEXISHMED: Table for Search Indexes4UUIDCharacter field, length 32nvarchar320
23N1SE_INDEX_ATTRISHMED: Search Index Attributes7UUIDCharacter field, length 32nvarchar320
24P32_CFDI_TIMB_CECFDi CE Digital Tax Stamp7UUIDUnique ID number of the stampnvarchar360
25PPHMRPLOGMRP Live Log Header2UUIDGlobal Unique ID for tablevarbinary160
26PPHMRPLOGITEMMRP Live Log Item2UUIDGlobal Unique ID for tablevarbinary160
27PPHMRPPPLOGMRP Live Postprocessing Log Header2UUIDGlobal Unique ID for tablevarbinary160
28PPHMRPPPLOGITEMMRP Live Postprocessing Log Item2UUIDGlobal Unique ID for tablevarbinary160
29RCCL_BUF_STRUCTRCCF: Function Structure Buffer6UUIDGlobal Unique ID for tablevarbinary160
30RS2HANA_AUTH_IPRAuth: InfoProviders to be processed1UUIDUUID in compressed formnvarchar250
31RS2HANA_AUTH_USRAuth: Users to be processed1UUIDUUID in compressed formnvarchar250
32RSOSRUNTIMEBW Search: View Runtime Information2UUID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
33RSOSRUNTIMEEXECBW Search: Execution Information of Individual Identifiers1UUID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
34SADL_DO_NOT_USDO NOT USE!1UUIDnvarchar320
35SADL_ENTITY_LOADSADL entity load1UUIDnvarchar320
36SADL_PREVIEWDO NOT USE!1UUIDnvarchar320
37SUPGERRORUprade Tools Error Messages2UUIDUpgrade Tools UUIDnvarchar320
38SWLT_STATIC_C_DCache for static check data1UUID16 Byte UUID in 16 Bytes (Raw Format)varbinary160
39SWLT_STATIC_C_HCache for static check data5UUID16 Byte UUID in 16 Bytes (Raw Format)varbinary160
40T5FDSN_GEN_SECTNDSN: Generated sections2UUIDvarbinary160
41T7MXCFDI_TIMBRECFDi Digital Tax Stamp5UUIDUnique ID number of the stampnvarchar360
42UCON_LOAD_TESTAMC load test table4UUIDText string 22 charactersnvarchar220
43WBBGRFCTMPLog for Where Used Index Update in Backgound Tasks1UUID16 Byte UUID in 16 Bytes (Raw Format)varbinary160
44PIQDBLMSLPIDLearning Product UUID - LMS6UUIDUUID in character formnvarchar320
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
45DDXTTNametab header structure for delayed writing4UUIDGlobal Unique ID for tablevarbinary160
TOPAgency Business Global Trade
46WZRE_CONFIRMstore UUID of confirmation to test asynchronous services1UUIDCopy of Universally Unique Identifiernvarchar360
TOPBasic Functions
47LFSSTNSustainability details for Vendor3UUIDSSTN UUIDnvarchar320
48LFSSTN_CERTVendor sustainability certificates2UUIDSSTN UUIDnvarchar320
TOPBelgium
49T5BDI0HR-BE: Dimona Central Table29UUIDDimona Universal Unique Identifiernvarchar200
TOPBusiness Process Engine
50SWFXILOGHistory of Processing a Message in BPE4UUIDUnique Identifier for BPE Log Entriesdecimal240
TOPClass Builder
51SEOCLASSClass/Interface3UUIDUUID in X form (binary)varbinary160
TOPClinical System
52N2F4_CAT_HEADERIS-H*MED: Header Data for Dynamic Input Help (F4)3UUIDGlobal Unique ID for tablevarbinary160
53N2F4_CAT_VALUESIS-H*MED: Values of Hit Lists for Dynamic F4 Help3UUIDGlobal Unique ID for tablevarbinary160
54N2F4_HIT_HEADERIS-H*MED: Hdr Data of Hit Lists for Dynamic Input Help (F4)3UUIDGlobal Unique ID for tablevarbinary160
55N2F4_HIT_VALUESIS-H*MED: Values of Hit Lists for Dynamic F4 Help3UUIDGlobal Unique ID for tablevarbinary160
TOPCollaborative Cross Applications
56/POA/APP_CONFIGTable to store FCP application specific configuration1UUIDFCP UUIDnvarchar320
57/POA/BNDL_APINFOTable to store app info for a bundle in flex client platform1UUIDFCP UUIDnvarchar320
58/POA/BNDL_EXTNTable to store extension for a point in flex client platform1UUIDFCP UUIDnvarchar320
59/POA/BNDL_EXTNPTTable to store extension point info in flex client platform1UUIDFCP UUIDnvarchar320
60/POA/BNDL_INFOTable to store bundle information in flex client platform1UUIDFCP UUIDnvarchar320
61/POA/D_ALIAS_IDXAlias Index Table of the BUI Persistence Service5UUIDResource IDnvarchar320
62/POA/D_BUI_ACCBUI PST Access Control2UUIDInternal Instance ID for Access Control Domainnvarchar320
63/POA/D_BUI_PROPBUI PS Properties2UUIDProperty IDnvarchar320
64/POA/D_BUI_RESBUI PS Resources2UUIDResource IDnvarchar320
65/POA/D_CRES_LOGBUI PS Resource Change Log Table2UUIDResource IDnvarchar320
66/POA/D_NPROP_DCBUI PS Non-Translatable Property Table - Default Content2UUIDResource IDnvarchar320
67/POA/D_NPROP_IMPBUI PS Non-Translatable Properties - Partition Import2UUIDResource IDnvarchar320
68/POA/D_NPROP_SCBUI PS Non-Translatable Property Table - System Content2UUIDResource IDnvarchar320
69/POA/D_NTRN_PROPNon-Translatable Property Values2UUIDProperty IDnvarchar320
70/POA/D_PROP_IMPBUI PS Property Table - Partition Import2UUIDResource IDnvarchar320
71/POA/D_PROP_SCBUI PS Property Table - System Content2UUIDResource IDnvarchar320
72/POA/D_PRPT_DCBUI PS Translatable Property Text Table - Default Content2UUIDResource IDnvarchar320
73/POA/D_PRPT_SCBUI PS Translatable Property Text Table - System Content2UUIDResource IDnvarchar320
74/POA/D_PRP_DCBUI PS Translatable Property Table - Default Content2UUIDResource IDnvarchar320
75/POA/D_PRP_SCBUI PS Translatable Property Table - System Content2UUIDResource IDnvarchar320
76/POA/D_RES_DCBUI PS Resource Table - Default Content2UUIDResource IDnvarchar320
77/POA/D_RES_IMPBUI PS Resource Table - Partition Import2UUIDResource IDnvarchar320
78/POA/D_RES_SCBUI PS Resource Table - System Content2UUIDResource IDnvarchar320
79/POA/D_TRNPL_DCBUI PS Multi-Language Payload Parts - Default Content3UUIDResource IDnvarchar320
80/POA/D_TRNPL_IMPBUI PS Text Fragments - Partition Import3UUIDResource IDnvarchar320
81/POA/D_TRNPL_SCBUI PS Multi-Language Payload Parts - System Content3UUIDResource IDnvarchar320
82/POA/D_TRN_PAYLBUI PS Resource Value: Texts Referenced from Value3UUIDResource IDnvarchar320
83/POA/D_TRN_PROPTranslatable Property Values2UUIDProperty IDnvarchar320
84/POA/D_XML_VALSBUI PS Resource Value (XML)2UUIDResource IDnvarchar320
85/POA/FEATR_INFOTable to store feature scope information for a bundle on FCP1UUIDFCP UUIDnvarchar320
86/POA/SCOPE_INFOTable to store scope information in flex client platform1UUIDFCP UUIDnvarchar320
TOPContract Accounts Receivable and Payable
87DFKKCFCSLOCKSFI-CA Locks14UUIDUUID in compressed form (22 character UUENCODEd)nvarchar220
TOPCustomer Enhancements
88SXS_STATExit: Definition side: UUID assignment for statistics3UUIDUUID in compressed form (22 character UUENCODEd)nvarchar220
TOPGlobal Trade
89EAGLT_CONFIRMstore UUID of confirmation to test asynchronous services1UUIDCopy of Universally Unique Identifiernvarchar360
TOPIncentive and Commission Management ICM
90CACS_HRLOGLogging of HR Master Data Changes2UUIDGUID in 'RAW' formatvarbinary160
91CRDT_ESOATable for Test of Enterprise Services in CRD1UUIDnvarchar360
92ICMT_ESOATable for Test of Enterprise Services in ICM1UUIDnvarchar360
93TCRD_APVCredentialing: Values for Requirement Assignment Parameters3UUIDUUID in character formnvarchar320
94TCRD_COMBREQCredentialing: Combined Requirements8UUIDUUID in character formnvarchar320
95TCRD_SRDCredentialing: Simple Requirements6UUIDUUID in character formnvarchar320
96TCRD_SRDESCredentialing: Simple Requirements Description3UUIDUUID in character formnvarchar320
97TCRD_SRDESACredentialing: Simple Requirements Description (Attributes)3UUIDUUID in character formnvarchar320
TOPMaterial Master
98MGIR_SSTNMaterial / Info Record Sustainability table2UUIDSSTN UUIDnvarchar320
99MGIR_SSTN_ECOLBLMaterial / Vendor Sustainability Eco-Label table2UUIDSSTN UUIDnvarchar320
TOPOffice Suite Program
100/OSP/T_CJS_GJGeneric Journal2UUIDUUID RAW16varbinary160
101/OSP/T_CJS_SJScenario-Specific Journal2UUIDUUID RAW16varbinary160
TOPProxy Generation
102SPROXXSLQQueue with objects needing generation of stylesheets4UUID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
103SPROX_TEST_DATAStorage for test data5UUID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
TOPRetention Warehouse
104IWP_DATA_DELIVERMetadata from Archive Object SN_META2UUID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
105IWP_SNMETAMetadata from Archive Object SN_META2UUID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
TOPSAP Records Management
106SRMUSERQUERYStored Search Query v. Users According to Element Type2UUIDUUID in character formnvarchar320
TOPSAP Retail Store
107WSAO_WORK_CTRLRetail Store Store Order: Worklist Control2UUIDUUID in compressed form (22 character UUENCODEd)nvarchar220
TOPService Implementation Workbench
108TSIW_CONTEXTContext of SIW project2UUIDGlobal Unique ID for SIW contextvarbinary160
109TSIW_CONTEXT_VARproject variables2UUIDGlobal Unique ID for SIW contextvarbinary160
110TSIW_IMPLSIW Implementation Project Head Table2UUIDGlobal Unique ID for SIW Implementationvarbinary160
111TSIW_IMPL_PIECEStück einer Projektimplementation2UUIDGlobal Unique ID for SIW Implementationvarbinary160
112TSIW_LINKSIW Signature Field/Type Mapping2UUIDGlobal Unique ID for SIW Signature Field/Type Mappingvarbinary160
113TSIW_MAPPINGSIW Mapping Header2UUIDMapping Project IDvarbinary160
114TSIW_SXF_APISignature Exchange Format - API Component2UUIDSIW: Global Unique ID for Signature of Exchange Formatvarbinary160
115TSIW_SXF_FIELDSignature Exchange Format - Field2UUIDUnique Field IDvarbinary160
116TSIW_SXF_FIELDRLField relations2UUIDUUID for Signature Exchange Format - Field Relationsvarbinary160
117TSIW_SXF_TYPESignature Exchange Format - Type2UUIDUUID for Signature Exchange Format - Typevarbinary160
TOPTreasury and Risk Management
118REGT_DATA_POINTSData Points of Regression Calculation2UUIDGUID in 'RAW' formatvarbinary160
119REGT_REGR_DATAParameters & Output Data of Regression Calculation2UUIDGUID in 'RAW' formatvarbinary160
TOPUpgrade - General
120DDMTTNametab header structure for delayed writing4UUIDGlobal Unique ID for tablevarbinary160
121DDMTT_ISUNametab header structure for delayed writing4UUIDGlobal Unique ID for tablevarbinary160
122DDMTT_SAVNametab Headerstruktur für verzögertes Schreiben4UUIDGlobale eindeutige Id für Dictionary-Objektvarbinary160
123DDXTT_SAVNametab Headerstruktur für verzögertes Schreiben4UUIDGlobale eindeutige Id für Dictionary-Objektvarbinary160
124DDXTT_SHDNametab Headerstruktur für verzögertes Schreiben4UUIDGlobale eindeutige Id für Dictionary-Objektvarbinary160
125DDXTT_STDNametab Headerstruktur für verzögertes Schreiben4UUIDGlobale eindeutige Id für Dictionary-Objektvarbinary160
126DDYTTSubstitution Nametab (shadow-shadow-nametab for DDXTT)6UUIDGlobal Unique ID for tablevarbinary160
TOPUpgrade Tools
127CRRERRORCRR Error Messages2UUIDCRR UUIDnvarchar320
128ICNV30LNametabs for Incremental Conversion5UUIDvarbinary160
TOPWeb Services Tool
129CRMC_WSC_OBJTREEWSC Object Tree Table2UUIDUniversal Unique Identifier for CRM Web Svc Consumption Toolnvarchar320
130CRMC_WSC_TREEMAPWSC Mapping Table Sourc/Target-Tree1UUIDUniversal Unique Identifier for CRM Web Svc Consumption Toolnvarchar320