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

35 columns | Print definition?ERP 6.0  | STGRD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FIEUD_FIDOC_HSAFT: FI Transaction Document Header48STGRDReason for Reversalnvarchar20
2FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice38STGRDReason for Reversalnvarchar20
3FUDT_VDOCBKPFVerification Document Header62STGRDReason for Reversalnvarchar20
4FUDT_VDOCBKPFHVerification Document Header(History)62STGRDReason for Reversalnvarchar20
5FUDT_VERIFDOCFI verification document - index table14STGRDReason for Reversalnvarchar20
6GLPOS_C_CTFI Document: Entry View238STGRDReason for Reversalnvarchar20
7GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items238STGRDReason for Reversalnvarchar20
8GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items238STGRDReason for Reversalnvarchar20
9GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items238STGRDReason for Reversalnvarchar20
10GLPOS_N_CTNew General Ledger: Line Item with Currency Type246STGRDReason for Reversalnvarchar20
11GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type246STGRDReason for Reversalnvarchar20
12J_3RF_REGCUS_REVCustomizing for Reversals for Invoice Registration Journal3STGRDReason for Reversalnvarchar20
13T033FAccount Determination: Posting Rules17STGRDReason for Reversalnvarchar20
TOPAccounting Interface
14GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)292STGRDReason for Reversalnvarchar20
15GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)292STGRDReason for Reversalnvarchar20
TOPAutomatic Payments
16PAYRQPayment Requests117STGRDReason for Reversalnvarchar20
TOPBank Accounting
17TCCFIPayment cards: Central FI settings8STGRDReason for Reversalnvarchar20
TOPBasis Components
18ZDS400_BKPFBelegkopf für Buchhaltung62STGRDGrund für Storno oder Umkehrbuchungnvarchar20
TOPBilling
19VBRKBilling Document: Header Data102STGRDReason for Reversalnvarchar20
TOPBudgeting
20FMREV_STGRD_DEFAllowed Reversal Reasons for Budget Documents4STGRDReason for Reversal of Budget Documentnvarchar20
TOPCross-Application Components
21BKKPFAccounting document header62STGRDReason for Reversalnvarchar20
TOPDown Payment Chains
22/SAPPCE/TDPC20Down Payment Chain: Document Header16STGRDReason for Reversalnvarchar20
TOPFinancial Accounting
23BKPFAccounting Document Header62STGRDReason for Reversalnvarchar20
24DOCCHG_EWBUCHCustomizing of Posting Transaction6STGRDReason for Reversalnvarchar20
25T041CReasons for Reverse Posting2STGRDReason for Reversalnvarchar20
26T041CTReasons for Reverse Posting (Name)3STGRDReason for Reversalnvarchar20
27VBKPFDocument Header for Document Parking85STGRDReason for Reversalnvarchar20
TOPFlexible Real Estate Management
28TIVXCFCSCKEYPROPService Charge Key: Properties for Fuel Management14STGRDReason for Reversalnvarchar20
TOPGeneral Ledger Accounting
29BKPF_ADDAccounting Document Header62STGRDReason for Reversalnvarchar20
TOPLocalization
30ISJPTAXADJUSTTax Adjustment Postings11STGRDReason for Reversalnvarchar20
TOPLogistics Invoice Verification
31WRFT_PREPAYMENTPrepayment Control at Company Code Level4STGRDReason for Reversalnvarchar20
TOPPatient Accounting
32TN22SIS-H: Control Parameters FI Posting Down Payment Request27STGRDIS-H: Reversal Reason for Autom. Reversal DownPayt Requestnvarchar20
TOPRemaining Beverage - Obsolete Objects
33/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103064STGRDReason for Reversalnvarchar20
TOPSupply Chain Management
34TCM_C_PUR_MAPMapping TM Organizational Unit to Purchasing Organisation11STGRDReason for Reversalnvarchar20
35TCM_ORG_PUR_MAPMapping TCM Organizational unit to purchasing organisation9STGRDReason for Reversalnvarchar20