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

42 columns | Print definition?ERP 6.0  | CREDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/FISC_REQFiscalization Croatia: Communication Log Request9CREDATDate status record was creatednvarchar80
2/CCEE/FISC_RESFiscalization Croatia: Communication Log Response9CREDATDate status record was creatednvarchar80
3/SDF/IVISALEPNDGALE messages stuck in tRFC10CREDATIDoc Created Onnvarchar80
4CNVC_SCNG_HEADComparison run header5CREDATCreation datenvarchar80
5IDXLOGDC40IDoc Adapter RFC Logging EDI_DC4032CREDATCreated onnvarchar80
6ZFSCM_IDARCAbbildung: TrxREf -> PDF3CREDATFeld vom Typ DATSnvarchar80
7ZFSCM_IDIDOAbbildung:TrxRef -> IDoc4CREDATFeld vom Typ DATSnvarchar80
8ZFSCM_IDOBELVerknüpfung: IDoc <-> Eingangsbeleg7CREDATFeld vom Typ DATSnvarchar80
TOPALE Integration Technology
9CATT_ALETable for ALE - CATT Session7CREDATIDoc Created Onnvarchar80
10EDIDCControl record (IDoc)38CREDATIDoc Created Onnvarchar80
11EDIDOCINDXControl record (IDoc)38CREDATIDoc Created Onnvarchar80
12EDIDSStatus Record (IDoc)6CREDATDate status record was creatednvarchar80
13EDIQIIDoc Inbound Queue Table8CREDATIDoc Created Onnvarchar80
14EDIQOIDoc: Outbound Queue for qRFC8CREDATIDoc Created Onnvarchar80
TOPCapacity Leveling
15PIBAProcess planning interface: Production requirements4CREDATDate record created onnvarchar80
16PIBZProcess planning interface: Production commitments5CREDATDate record created onnvarchar80
TOPDistribution Unit Distribution Packet
17UPSHDRALE Distribution Unit: Header Data18CREDATDatenvarchar80
TOPEasy Enhancement Workbench
18AXT_EXTENSIONExtension6CREDATCreation Datenvarchar80
TOPEEW Services
19OXT_CUS_EXTVERCustomer Extension Versions10CREDATCreation Datenvarchar80
20OXT_CUS_PPROCPostprocessing Activities16CREDATCreation Datenvarchar80
21OXT_CUS_PRJObject Extension Projects7CREDATCreation Datenvarchar80
22OXT_PARAMHDROXT Parameter Set4CREDATCreation Datenvarchar80
TOPFinancials Basis
23UBC_TB_GUIDGUID for USER, ORG. WI_ID6CREDATField of type DATSnvarchar80
24UBC_TB_NOTESTable for Notes5CREDATField of type DATSnvarchar80
TOPGlobal Trade Services
25/SAPSLL/LEGMESSLL: Customs Document: Messages for Each Activity24CREDATIDoc Created Onnvarchar80
26/SAPSLL/MDMESMessages per Master Data Item11CREDATIDoc Created Onnvarchar80
TOPIncentive and Commission Management ICM
27CACS_OAPIFOA: Instance of an Assignment Process3CREDATFOA: Date on which Object was Creatednvarchar80
28CACS_OAWLFOA: Worklist, Header33CREDATFOA: Date on which Object was Creatednvarchar80
TOPLocalization
29J_1BNFDOCNota Fiscal Header8CREDATCreate datenvarchar80
30J_1BNFENUMGAPNF-e Numbering Gaps4CREDATCreate datenvarchar80
31J_1BNFEPARKDOCNota fiscal electronica: Invoice create failed21CREDATCreate datenvarchar80
32J_1BNFE_ACTIVEElectronic Nota Fiscal: Actual Status18CREDATCreate datenvarchar80
TOPMaterial Master
33WRF_DISCONT_HDRWorklist for Discontinuation for Seasonal Procurement4CREDATCreated Onnvarchar80
TOPMerchandise and Assortment Planning
34TWISPS_NOALLOC1Parameters for Allocation Tables Generated in MAP11CREDATCreation Date of MAP Allocation Tablenvarchar80
35TWISPS_NOLISTG1Parameters for Allocation Tables Generated in MAP11CREDATCreation Date of MAP Allocation Tablenvarchar80
36TWISPS_NOPROMO1Parameters for Promotions Created in MAP19CREDATCreation Data of MAP Promotionnvarchar80
TOPSAP NetWeaver Mobile - Use subcomponents
37MEREP_401SyncBO ID3CREDATCreated onnvarchar80
38MEREP_NOTIFYNotification Message3CREDATCreated onnvarchar80
39MEREP_PERSONPerson (Sample Application)12CREDATCreated onnvarchar80
TOPSAP Retail Store
40WSTI_PDC_EVENTRetail Store Physical Inventory: PDC Transactions4CREDATIDoc Created Onnvarchar80
TOPSpecification 2
41ADSPCM_MM_SACSAC for MM8CREDATIDoc Created Onnvarchar80
TOPVehicle Management System
42VLCIDGUVELO : Vehicle to IDoc Number Assignment Table4CREDATDate status record was creatednvarchar80