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

91 columns | Print definition?ERP 6.0  | ITEMID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals4ITEMIDDocument Item Idnvarchar50
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals4ITEMIDDocument Item Idnvarchar50
3/OPT/VIM_1ITEM_SDocument Item3ITEMIDDocument Item Idnvarchar50
4/OPT/VIM_1PROCWorkflow Information for VIM Processes5ITEMIDDocument Item in Invoice Documentnvarchar60
5/OPT/VIM_CUSTOMSCustoms data for imported goods3ITEMIDDocument Item Idnvarchar50
6/OPT/VIM_TITEMDocument Item3ITEMIDDocument Item Idnvarchar50
7/ORS/PS_ITEMProfitability Segment Fields and Values3ITEMIDDocument Item Idnvarchar50
8PPHMRPLOGITEMMRP Live Log Item3ITEMIDNatural Numberint100
9PPHMRPPPLOGITEMMRP Live Postprocessing Log Item3ITEMIDNatural Numberint100
10YVIM_1ITEMDocument Item3ITEMIDDocument Item Idnvarchar50
TOPCollectionsDisbursements
11VVSCPOSICDRPayment Plan Item: Data for ICDR Service7ITEMIDItem ID of an InsuranceCollectionDisbursementRequestnvarchar150
TOPEnd User Technology
12RSZW30ITEMSREUSEConversion of Chart Settings from BW 3.0 to BW 3.51ITEMIDTechnical Name of an Itemnvarchar300
13RSZWITEMHeader Table for BW Web Items1ITEMIDTechnical Name of an Itemnvarchar300
14RSZWITEMATTRAttribute Table of the Items (Contains Search Attributes)1ITEMIDTechnical Name of an Itemnvarchar300
15RSZWITEMDATABW Web Item Data (7.0)+1ITEMIDTechnical Name of an Itemnvarchar300
16RSZW_WBITEMSTable of Deleted BDS Items and Views4ITEMIDShort descriptionnvarchar200
TOPFinancial Accounting
17/OPT/VIM_1ITEMDocument Item3ITEMIDDocument Item Idnvarchar50
TOPLease Accounting
18/LSIERP/TRIG_NALeases Not Set to Non-Accrual2ITEMIDGUID of Item of CRM Contractvarbinary160
19FILA_MIG_SYNCSynchronization of CRM and LAE Legacy Data6ITEMIDGUID of Item of CRM Contractvarbinary160
20LAE_BILLING_DATPayment Schedule4ITEMIDObject Numbervarbinary160
21LAE_CRM_LNKLink between LAE and CRM Contract Items3ITEMIDGUID of Item of CRM Contractvarbinary160
TOPNetwork Operations
22GHO_NETVER_ITMItems of a Production Network Version4ITEMIDGHO Production Network Version Item Identificationnvarchar80
TOPPerformance Assessment Workbench
23SLS_CRITEMPAW - Comments for an item from a participant3ITEMIDPAW identifiernvarchar80
24SLS_IESS1PAW - Item Essay 12ITEMIDPAW identifiernvarchar80
25SLS_IESS2PAW - Item Essay 22ITEMIDPAW identifiernvarchar80
26SLS_IEVALPAW - Item Evaluation2ITEMIDPAW identifiernvarchar80
27SLS_IFILLPAW - Item Fillin2ITEMIDPAW identifiernvarchar80
28SLS_ILC1PAW - Item LC12ITEMIDPAW identifiernvarchar80
29SLS_ILC2PAW - Item LC22ITEMIDPAW identifiernvarchar80
30SLS_IMCPAW - Item Multiple Choice2ITEMIDPAW identifiernvarchar80
31SLS_IRATEPAW - Item Rate2ITEMIDPAW identifiernvarchar80
32SLS_ITEMPAW - Item Description2ITEMIDPAW identifiernvarchar80
33SLS_RESS1PAW - Result for Item Essay 13ITEMIDPAW identifiernvarchar80
34SLS_RESS2PAW - Result for Item Essay 23ITEMIDPAW identifiernvarchar80
35SLS_RFILLPAW - Result Item Fillin3ITEMIDPAW identifiernvarchar80
36SLS_RITEMPAW - Result on Item3ITEMIDPAW identifiernvarchar80
37SLS_RLCPAW - Result for Item Listchoice3ITEMIDPAW identifiernvarchar80
38SLS_RMCPAW - Result for Item Multiple Choice3ITEMIDPAW identifiernvarchar80
39SLS_RRATEPAW - Result for Item RATE3ITEMIDPAW identifiernvarchar80
40SLS_TSTRUPAW - Test Structure6ITEMIDPAW identifiernvarchar80
41SLS_YESS1PAW - Result for Item Essay 13ITEMIDPAW identifiernvarchar80
42SLS_YESS2PAW - Result for Item Essay 23ITEMIDPAW identifiernvarchar80
43SLS_YFILLPAW - Result Item Fillin3ITEMIDPAW identifiernvarchar80
44SLS_YITEMPAW - Result on Item3ITEMIDPAW identifiernvarchar80
45SLS_YLCPAW - Result for Item Listchoice3ITEMIDPAW identifiernvarchar80
46SLS_YMCPAW - Result for Item Multiple Choice3ITEMIDPAW identifiernvarchar80
47SLS_YRATEPAW - Result for Item RATE3ITEMIDPAW identifiernvarchar80
TOPProcess Management
48TCOOPC_ITEMOPC: Plant-Specific Custom. Table for OPC Item Definition5ITEMIDOPC: Fully Qualified OPC Item IDnvarchar2550
TOPSocial Services and Social Security
49PSSCD_GEDITEMGross Entitlement Determination Item Data3ITEMIDSocial Services Business Object Item IDnvarchar320
50PSSCD_GPDITEMGross Payment Docment Item Data3ITEMIDSocial Services Business Object Item IDnvarchar320
51PSSCD_NCDITEMNet Calculation Document Item3ITEMIDSocial Services Business Object Item IDnvarchar320
52PSSCD_SXPITEMSXP Item Data3ITEMIDSocial Services Business Object Item IDvarbinary160
53PSSCD_SXP_APPTSXP Appointment3ITEMIDSocial Services Business Object Item IDvarbinary160
54PSSCD_SXP_CUST_ISXP Customer Include (Item)3ITEMIDSocial Services Business Object Item IDvarbinary160
55PSSCD_SXP_PARTNRSXP Partner3ITEMIDSocial Services Business Object Item IDvarbinary160
56PSSCD_SXP_PAYM_RSXP Additional Payment Recipients3ITEMIDSocial Services Business Object Item IDvarbinary160
57PSSCD_SXP_STATUSSXP Status3ITEMIDSocial Services Business Object Item IDvarbinary160
TOPTransaction Tax Engine
58TTED_ANALYS_COMOutput Trace4ITEMIDItem Identifiernvarchar320
59TTED_INITEM_COMInput item5ITEMIDItem Identifiernvarchar320
60TTED_OUTITEM_COMOutput Item5ITEMIDItem Identifiernvarchar320
61TTEPD3_ITEMItem5ITEMIDItem Identifiernvarchar320
62TTEPD3_USITEMPersistency TTE Document UsItem3ITEMIDItem Identifiernvarchar320
63TTEPDT_ITEMPersistency TTE Document Item3ITEMIDItem Identifiernvarchar320
64TTEPDT_ITEMPARTPersistency TTE Document item partner3ITEMIDItem Identifiernvarchar320
65TTEPDT_ORGUNITPersistency TTE Document org unit3ITEMIDItem Identifiernvarchar320
66TTEPDT_PRICELPersistency TTE Document / Item pricing element3ITEMIDItem Identifiernvarchar320
67TTEPDT_TAXCODVADocument / Item TaxCode Value4ITEMIDItem Identifiernvarchar320
68TTEPDT_TAXDATEPersistemcy TTE Document tax date3ITEMIDItem Identifiernvarchar320
69TTEPDT_TAXELPersistency TTE Document / Item tax element4ITEMIDItem Identifiernvarchar320
70TTEPDT_TAXEVENTPersistency TTE Document / Item tax event4ITEMIDItem Identifiernvarchar320
71TTEPDT_TAXVALUEPersistency TTE Document / Item tax value4ITEMIDItem Identifiernvarchar320
72TTEPDT_TRANPROPPersistency TTE Document transaction property3ITEMIDItem Identifiernvarchar320
73TTEPDT_USITEMPersistency TTE Document UsItem3ITEMIDItem Identifiernvarchar320
74TTESDT_ANALYSYSPricing Trace from Tax Calculation3ITEMIDItem Identifiernvarchar320
75TTESDT_ITEMItem3ITEMIDItem Identifiervarbinary160
76TTESDT_ITEMPARTDocument item partner3ITEMIDItem Identifiervarbinary160
77TTESDT_ORGUNITDocument org unit3ITEMIDItem Identifiervarbinary160
78TTESDT_PRICELDocument / Item pricing element3ITEMIDItem Identifiervarbinary160
79TTESDT_TAXCODVADocument / Item pricing element4ITEMIDItem Identifiervarbinary160
80TTESDT_TAXDATEDocument tax date3ITEMIDItem Identifiervarbinary160
81TTESDT_TAXELDocument / Item tax element4ITEMIDItem Identifiervarbinary160
82TTESDT_TAXEVENTDocument / Item tax event4ITEMIDItem Identifiervarbinary160
83TTESDT_TAXVALUEDocument / Item tax value4ITEMIDItem Identifiervarbinary160
84TTESDT_TRANPROPDocument transaction property3ITEMIDItem Identifiervarbinary160
85TTESDT_USITEMOutput Exemptions3ITEMIDItem Identifiernvarchar320
TOPWorkplace Server
86TCBRCUSTOMCustomer Branding Parameter Table2ITEMIDParameterIDnvarchar400
87TWPCUSTMCTText Table for Customer System Settings for Workplace4ITEMIDEntry ID for System Settingsnvarchar100
88TWPCUSTOMSystem Setting for the Workplace2ITEMIDEntry ID for System Settingsnvarchar100
89TWPCUSTOMCCustomer-Defined System Setting for the Workplace3ITEMIDEntry ID for System Settingsnvarchar100
90TWPCUSTOMTText Table for System Settings for the Workplace3ITEMIDEntry ID for System Settingsnvarchar100
91USRGENPRSTable for General Workplace Personalization Data4ITEMIDEntry ID for System Settingsnvarchar100