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

32 columns | Print definition?ERP 6.0  | PMNT_BLOCK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAccounts Receivable Accounting Process Integration
1FDM_DOC_MIRRORDocument Information (Raw Data in Substitute System)37PMNT_BLOCKLine Item Blocked for Payment?nvarchar10
2TEBPPEXTSTATUSExternal description of the invoice3PMNT_BLOCKBlock Key for Paymentnvarchar10
3TEBPPEXTSTATUSTText table for TEBPPEXTSTATUS4PMNT_BLOCKBlock Key for Paymentnvarchar10
TOPBasis Components
4/XFT/INV_QInvoice receipt queue: Header56PMNT_BLOCKPayment Block Keynvarchar10
5/XFT/INV_Q_SInvoice receipt queue: Header56PMNT_BLOCKPayment Block Keynvarchar10
TOPFunds Management-Specific Postings
6IFMPDCUSTPayment Directive Settings9PMNT_BLOCKPayment Block Key for Payment Directivesnvarchar10
TOPGrantor Management
7GTRFIAPARGrantor: FI AP/AR related data3PMNT_BLOCKPayment Block Keynvarchar10
TOPIncentive and Commission Management ICM
8CACS00_DOCFI_PData Transfer: FI Documents (Items)13PMNT_BLOCKPayment Block Keynvarchar10
9CACS00_DOCSECommission Document, Settlement27PMNT_BLOCKPayment Block Keynvarchar10
10CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items6PMNT_BLOCKPayment Block Keynvarchar10
11CACSFI_DOCFI_PDSettlement to FI: Reference Line Item8PMNT_BLOCKPayment Block Keynvarchar10
12CACSHR_DOCHR_PDSettlement to PY: Reference Line Item22PMNT_BLOCKPayment Block Keynvarchar10
13TCACS_STMTYSettlement Type12PMNT_BLOCKPayment Block Keynvarchar10
14YCRM01_ACCSTAccount Assignment Type/Cost Info for Settlement Types11PMNT_BLOCKPayment Block Keynvarchar10
15YCRM01_DOCFI_PData Transfer: FI Documents Item15PMNT_BLOCKPayment Block Keynvarchar10
16YCRM01_DOCSECommission Document: Due Dates27PMNT_BLOCKPayment Block Keynvarchar10
17YHITEC_DOCFI_PData Transfer: FI Documents Item13PMNT_BLOCKPayment Block Keynvarchar10
18YHITEC_DOCSECommission Document: Due Dates27PMNT_BLOCKPayment Block Keynvarchar10
19YSVMA_ACCASAccount Assignment Type/Cost Information for Remuneration5PMNT_BLOCKPayment Block Keynvarchar10
20YSVMA_ACCSTAccount Assignment Type/Cost Info for Settlement Types12PMNT_BLOCKPayment Block Keynvarchar10
21YSVMA_DOCFI_PData Transfer: FI Documents (Items)13PMNT_BLOCKPayment Block Keynvarchar10
22YSVMA_DOCSECommission Document: Due Dates27PMNT_BLOCKPayment Block Keynvarchar10
23YTEL01_ACCASAccount Assignment Type/Cost Information for Remuneration19PMNT_BLOCKPayment Block Keynvarchar10
24YTEL01_ACCSTAccount Assignment Type/Cost Info for Settlement Types11PMNT_BLOCKPayment Block Keynvarchar10
25YTEL01_DOCFI_PData Transfer: FI Documents Item13PMNT_BLOCKPayment Block Keynvarchar10
26YTEL01_DOCSECommission Document: Due Dates44PMNT_BLOCKPayment Block Keynvarchar10
27YTEL05_ACCASAccount Assignment Type/Cost Information for Remuneration6PMNT_BLOCKPayment Block Keynvarchar10
28YTEL05_ACCSTAccount Assignment Type/Cost Info for Settlement Types6PMNT_BLOCKPayment Block Keynvarchar10
29YTEL05_DOCFI_PData Transfer: FI Documents (Items)13PMNT_BLOCKPayment Block Keynvarchar10
30YTEL05_DOCSECommission Document: Due Dates33PMNT_BLOCKPayment Block Keynvarchar10
31ZICMAG_DOCFI_PData Transfer: FI Documents (Items)13PMNT_BLOCKPayment Block Keynvarchar10
32ZICMAG_DOCSECommission Document: Due Dates27PMNT_BLOCKPayment Block Keynvarchar10