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

64 columns | Print definition?ERP 6.0  | PROFILE_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/ADT_CATTtransport table for /SLOAS/ADT_CAT2PROFILE_GUIDCharacter field, length 32nvarchar320
2/SLOAP/BIN_PROFsloap profile3PROFILE_GUIDSLOAS: Guidvarbinary160
3/SLOAP/CATTOPICTTransport table for /SLOAS/CATTOPIC2PROFILE_GUIDCharacter field, length 32nvarchar320
4/SLOAP/CAT_HEADTtrasport table for /SLOAS/CAT_HEAD2PROFILE_GUIDCharacter field, length 32nvarchar320
5/SLOAP/CHARTYPTtransport tab for /SLOAS/CHARTYPS2PROFILE_GUIDCharacter field, length 32nvarchar320
6/SLOAP/CLU_SRCTTransport table for /SLOAS/CLU_SRC2PROFILE_GUIDCharacter field, length 32nvarchar320
7/SLOAP/CLU_STORTTransport table for /SLOAS/CLU_STORE2PROFILE_GUIDCharacter field, length 32nvarchar320
8/SLOAP/CLU_TXTTtransport table for /SLOAS/CLU_TXT2PROFILE_GUIDCharacter field, length 32nvarchar320
9/SLOAP/DESC_ALITTransport table for /SLOAS/DESC_ALIA2PROFILE_GUIDCharacter field, length 32nvarchar320
10/SLOAP/DEVC_FITTtransport table for /SLOAS/DEVC_FILT2PROFILE_GUIDCharacter field, length 32nvarchar320
11/SLOAP/FIELDTTransport table for /SLOAS/FIELD2PROFILE_GUIDCharacter field, length 32nvarchar320
12/SLOAP/GEN_STATEState of output generation2PROFILE_GUIDSLOAS Output Profile GUIDvarbinary160
13/SLOAP/MD_FIELDTtransport table for /SLOAS/MD_FIELD2PROFILE_GUIDCharacter field, length 32nvarchar320
14/SLOAP/MD_SYSTtransport table for /SLOAS/MD_SYS2PROFILE_GUIDCharacter field, length 32nvarchar320
15/SLOAP/MODULETtransport table for /SLOAP/MODULE2PROFILE_GUIDCharacter field, length 32nvarchar320
16/SLOAP/OUTP_CATTtransport table for /SLOAS/OUTP_CAT2PROFILE_GUIDCharacter field, length 32nvarchar320
17/SLOAP/OUTP_XMLTtransport table for /SLOAS/OUTP_XML2PROFILE_GUIDCharacter field, length 32nvarchar320
18/SLOAP/OUT_COMMTTransport Tables for /SLOAS/OUT_COMM2PROFILE_GUIDCharacter field, length 32nvarchar320
19/SLOAP/OUT_GRTtransport tables for /SLOAS/OUT_GR2PROFILE_GUIDCharacter field, length 32nvarchar320
20/SLOAP/OUT_GR_GTtransport table for /SLOAS/OUT_GR_GR2PROFILE_GUIDCharacter field, length 32nvarchar320
21/SLOAP/OUT_GR_MTtransport table for /SLOAS/OUT_GR_MD2PROFILE_GUIDCharacter field, length 32nvarchar320
22/SLOAP/OUT_MD5_Ttransport table for /SLOAS/OUT_MD5_P2PROFILE_GUIDCharacter field, length 32nvarchar320
23/SLOAP/OUT_MDTtransport table for /SLOAS/OUT_MD2PROFILE_GUIDCharacter field, length 32nvarchar320
24/SLOAP/OUT_MD_MTtransport table for /SLOAS/OUT_MD_MD2PROFILE_GUIDCharacter field, length 32nvarchar320
25/SLOAP/OUT_PRTtransport tables for /SLOAS/OUT_PR2PROFILE_GUIDCharacter field, length 32nvarchar320
26/SLOAP/OUT_PR_GTtransport tables for /SLOAS/OUT_PR_GR2PROFILE_GUIDCharacter field, length 32nvarchar320
27/SLOAP/OUT_REFTtransport table for /SLOAS/OUT_REF2PROFILE_GUIDCharacter field, length 32nvarchar320
28/SLOAP/PICCATTtransport table for /SLOAS/PICCATT2PROFILE_GUIDCharacter field, length 32nvarchar320
29/SLOAP/PR_XMLTtransport table for /SLOAS/PR_XML2PROFILE_GUIDCharacter field, length 32nvarchar320
30/SLOAP/QUA_MAPPTtransport table for /SLOAS/QUA_MAPPI2PROFILE_GUIDCharacter field, length 32nvarchar320
31/SLOAP/RELEASETtransport table for /SLOAS/RELEASE2PROFILE_GUIDCharacter field, length 32nvarchar320
32/SLOAP/SELOPTTTransfer table for /SLOAS/SELOPT2PROFILE_GUIDCharacter field, length 32nvarchar320
33/SLOAP/SELOPT_GTtransport table for /SLOAS/SELOPT_G2PROFILE_GUIDCharacter field, length 32nvarchar320
34/SLOAP/SM_MAPPTTransport table for /SLOAS/SM_MAPPI2PROFILE_GUIDCharacter field, length 32nvarchar320
35/SLOAP/STORAGETtransport table for /SLOAS/STORAGE2PROFILE_GUIDCharacter field, length 32nvarchar320
36/SLOAP/SYS_TYPETTranspoert tables for SLOAP system types2PROFILE_GUIDCharacter field, length 32nvarchar320
37/SLOAP/SYS_TYPT2Transport tables for SLOAP system types2PROFILE_GUIDCharacter field, length 32nvarchar320
38/SLOAP/TEMPLBGTtransport tables for /SLOAS/TEMPLBG2PROFILE_GUIDCharacter field, length 32nvarchar320
39/SLOAP/TEMPLHTMTtransport tables for /SLOAS/TEMPLHTML2PROFILE_GUIDCharacter field, length 32nvarchar320
40/SLOAP/TEMPLPDFTtransport table for /SLOAS/TEMPLPDF2PROFILE_GUIDCharacter field, length 32nvarchar320
41/SLOAP/TEXTTtransport tables for /SLOAS/TEXT2PROFILE_GUIDCharacter field, length 32nvarchar320
42/SLOAP/TEXT_2TTransport tbl -SLOAS text mappings - using SAP documentation2PROFILE_GUIDCharacter field, length 32nvarchar320
43/SLOAP/TITLETtransport tables for /SLOAS/TITLE2PROFILE_GUIDCharacter field, length 32nvarchar320
44/SLOAP/TITLET2Transport table for SAP LT titles2PROFILE_GUIDCharacter field, length 32nvarchar320
45/SLOAP/TRANSSAP LT AP: transport admin tables2PROFILE_GUIDCharacter field, length 32nvarchar320
46/SLOAP/TXT_TYPETtransport table for /SLOAS/TXT_TYPE2PROFILE_GUIDCharacter field, length 32nvarchar320
47/SLOAP/XMLTtransport table for /SLOAS/XML2PROFILE_GUIDCharacter field, length 32nvarchar320
48/XLSO/COMD_WECCPCheckout Profile3PROFILE_GUIDCheckout Profile GUIDvarbinary160
49/XLSO/WEC_BP_CPDDefault Checkout Profile4PROFILE_GUIDCheckout Profile GUIDvarbinary160
TOPMaintenance Orders
50/MRSS/D_SQP_EAPPEmployee Profile : Approval details2PROFILE_GUIDProfile GUIDvarbinary160
51/MRSS/D_SQP_EHDREmployee Profile : Header Attributes2PROFILE_GUIDProfile guidnvarchar320
52/MRSS/D_SQP_EHISEmployee Profile : History of changes2PROFILE_GUIDProfile GUIDvarbinary160
53/MRSS/D_SQP_ESTREmployee Profile - Structured Qualifications2PROFILE_GUIDProfile GUIDvarbinary160
54/MRSS/D_SQP_EUSTEmployee Profile : Unstructured Qualifications2PROFILE_GUIDProfile GUIDvarbinary160
55/MRSS/D_SQP_PROFProfile Master Table : Contains all Profile Guids2PROFILE_GUIDProfile GUIDvarbinary160
56/MRSS/D_SQP_RADTRequirements Profile: Information of Additional attributes2PROFILE_GUIDProfile GUIDvarbinary160
57/MRSS/D_SQP_RHDRRequirements Profile: Header Attributes2PROFILE_GUIDProfile GUIDvarbinary160
58/MRSS/D_SQP_ROCSRequirement Profie on call types with search types2PROFILE_GUIDProfile GUIDvarbinary160
59/MRSS/D_SQP_ROCTRequirement Profie on call types2PROFILE_GUIDProfile GUIDvarbinary160
60/MRSS/D_SQP_RSTRRequirements Profile : Structured Qualifications2PROFILE_GUIDProfile GUIDvarbinary160
61/MRSS/D_SQP_RUSRRequirements Profile: Unstructured Qualifications2PROFILE_GUIDProfile GUIDvarbinary160
62/MRSS/D_SQP_RUSTRequirements Profile: Unstruct Qualif. - Language depend.2PROFILE_GUIDProfile GUIDvarbinary160
TOPWeb Channel Applications
63COMD_WEC_BP_CPCheckout Profile3PROFILE_GUIDCheckout Profile GUIDvarbinary160
64COMD_WEC_BP_CPDDefault Checkout Profile4PROFILE_GUIDCheckout Profile GUIDvarbinary160