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

94 columns | Print definition?ERP 6.0  | BVTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CEERE/FUKDCTax office: master data - time dependent6BVTYPPartner Bank Typenvarchar40
2/OPT/VIM_1CLEAR/OPT/VIM_1HEAD Extension with Clearing Documents (BSAK)18BVTYPPartner Bank Typenvarchar40
3/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC31BVTYPPartner Bank Typenvarchar40
4/OPT/WT_3S_PYMNTSupplier Self Service Payment Information17BVTYPPartner Bank Typenvarchar40
5BBP_RBKPDocument Header: Invoice Receipt63BVTYPPartner Bank Typenvarchar40
6BSAD_BAKAccounting: Secondary index for customers (cleared items)53BVTYPPartner Bank Typenvarchar40
7BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)55BVTYPPartner Bank Typenvarchar40
8BSEGAccounting Document Segment120BVTYPPartner Bank Typenvarchar40
9BSID_BAKAccounting: Secondary Index for Customers53BVTYPPartner Bank Typenvarchar40
10BSIK_BAKAccounting: Secondary index for vendors55BVTYPPartner Bank Typenvarchar40
11BSSEGAccounting Document Segment109BVTYPPartner Bank Typenvarchar40
12FUDT_VDOCBSEGVerification Document Item with Additional Info109BVTYPPartner Bank Typenvarchar40
13FUDT_VDOCBSEGEVVerification Document Item in the Entry View109BVTYPPartner Bank Typenvarchar40
14FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)109BVTYPPartner Bank Typenvarchar40
15GLPOS_C_CTFI Document: Entry View73BVTYPPartner Bank Typenvarchar40
16GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items73BVTYPPartner Bank Typenvarchar40
17GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items73BVTYPPartner Bank Typenvarchar40
18GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items73BVTYPPartner Bank Typenvarchar40
19GLPOS_N_CTNew General Ledger: Line Item with Currency Type73BVTYPPartner Bank Typenvarchar40
20GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type73BVTYPPartner Bank Typenvarchar40
21LFBK_EMC_JP_DElectronic Monetary Claims Japan3BVTYPPartner Bank Typenvarchar40
22REGUPProcessed items from payment program18BVTYPPartner Bank Typenvarchar40
TOPAccounting
23VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation21BVTYPPartner Bank Typenvarchar40
TOPAccounting Interface
24GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)334BVTYPPartner Bank Typenvarchar40
25GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)334BVTYPPartner Bank Typenvarchar40
TOPAdvertising Management
26JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order51BVTYPPartner Bank Typenvarchar40
27JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header15BVTYPPartner Bank Typenvarchar40
28JHTFXIS-M/AM: Billing Index - Order Billing25BVTYPPartner Bank Typenvarchar40
TOPAutomatic Payments
29PAYRQPayment Requests101BVTYPPartner Bank Typenvarchar40
TOPBasic Functions
30T028RTRANSRepetitive Transfer Transactions22BVTYPPartner Bank Typenvarchar40
TOPBelgium
31T5BT1Exceptional Tax Scales3BVTYPTax Scale Groupnvarchar30
32T5BT2Exemption for dependent children2BVTYPTax Scale Groupnvarchar30
33T5BT3Reduction for dependent children2BVTYPTax Scale Groupnvarchar30
TOPBilling
34VBRKBilling Document: Header Data92BVTYPPartner Bank Typenvarchar40
TOPBusiness Partner
35VTBSTC1Components of Payment Details for Standing Instruction6BVTYPPartner bank detailsnvarchar40
TOPCross-Application Components
36BBSIDAccounting: Secondary index for customers53BVTYPPartner Bank Typenvarchar40
TOPFinancial Accounting
37/OPT/VIM_1HEADDocument Header150BVTYPPartner Bank Typenvarchar40
38BSADAccounting: Secondary Index for Customers (Cleared Items)53BVTYPPartner Bank Typenvarchar40
39BSAKAccounting: Secondary Index for Vendors (Cleared Items)55BVTYPPartner Bank Typenvarchar40
40BSIDAccounting: Secondary Index for Customers53BVTYPPartner Bank Typenvarchar40
41BSIKAccounting: Secondary Index for Vendors55BVTYPPartner Bank Typenvarchar40
42EBSEGDoc.Segment of Fin.Accntng External Documents49BVTYPPartner Bank Typenvarchar40
43KMZEIFI: Account Assignment Model Item Information33BVTYPPartner Bank Typenvarchar40
44KNBKCustomer Master (Bank Details)7BVTYPPartner Bank Typenvarchar40
45KOMUAccount Assignment Templates for G/L Account Items33BVTYPPartner Bank Typenvarchar40
46LFBKVendor Master (Bank Details)7BVTYPPartner Bank Typenvarchar40
47VBSEGDDocument Segment for Customer Document Parking64BVTYPPartner Bank Typenvarchar40
48VBSEGKDocument Segment for Vendor Document Parking70BVTYPPartner Bank Typenvarchar40
TOPFunds Management-Specific Postings
49PSOSEGDDocument Segment: Recurring Request, Customer65BVTYPPartner Bank Typenvarchar40
50PSOSEGKRecurring Request Document Segment, Vendors71BVTYPPartner Bank Typenvarchar40
TOPInvoice Verification
51RBKPDocument Header: Invoice Receipt63BVTYPPartner Bank Typenvarchar40
TOPJoint Venture und Production Sharing Accounting
52T8J4BJV Cash Call Batch table17BVTYPPartner Bank Typenvarchar40
TOPLoans Management
53TTONFTVVZZKOPOTest neue Fima: VVZZKOPO29BVTYPPartnerbanktypnvarchar40
54TTONFTVZZBEPPTest neue FIMA: VZZBEPP129BVTYPPartnerbanktypnvarchar40
55VDAUSZDrawings on Disbursement50BVTYPPartner Bank Typenvarchar40
56VDBEPIPosted line items for document header48BVTYPPartner Bank Typenvarchar40
57VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)48BVTYPPartner Bank Typenvarchar40
58VDBEPPFlow Data - Planned Item82BVTYPPartner Bank Typenvarchar40
59VDBOBEPPBusiness Operation: Entered and Activated Flow Data82BVTYPPartner Bank Typenvarchar40
60VDCFWAREHOUSECash Flow Management70BVTYPPartner Bank Typenvarchar40
61VDGPOLoan: Relationship Partner/Role Object17BVTYPPartner Bank Typenvarchar40
62VDORDERBorrower's note loan order data60BVTYPPartner Bank Typenvarchar40
63VDREPAYMENTPayoff Master Data68BVTYPBank Details IDnvarchar40
64VZFZE_VDAUSZCentral Entry Table for Release Procedure52BVTYPPartner Bank Typenvarchar40
65VZFZE_VDBEPPCentral Entry Table for Release Procedure85BVTYPPartner Bank Typenvarchar40
TOPMaster Data
66JGTKNBKFSYIS-M: Index for Synchronization of Cust.Bank with Th.-Pty FI4BVTYPPartner Bank Typenvarchar40
67JGTLFBKFSYIS-M: Index for Synchronization of Vendor Bank w/Th.-Pty FI4BVTYPPartner Bank Typenvarchar40
68VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items28BVTYPPartner Bank Typenvarchar40
TOPPayment Transactions
69FPCR_CESSGarnishment Register Attributes22BVTYPPartner Bank Typenvarchar40
70REGUHSettlement data from payment program52BVTYPPartner Bank Typenvarchar40
71REGUHOREGUH version before the 'n'th change25BVTYPPartner Bank Typenvarchar40
TOPPayroll
72T5T1LBank accounts of authorities (tax,insurance)25BVTYPPartner Bank Typenvarchar40
73T5TPS1LBank accounts of authorities (tax,insurance)27BVTYPPartner Bank Typenvarchar40
74T7SK1LBank accounts of authorities (tax,insurance)28BVTYPPartner Bank Typenvarchar40
TOPPeriodical Sales and Distribution
75JFDFSIS-M/SD: Billing/Settlement Index26BVTYPPartner Bank Typenvarchar40
76JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS34BVTYPPartner Bank Typenvarchar40
77JKPASales Order: Partner22BVTYPPartner Bank Typenvarchar40
78JNTRECHIS-M/SD: Research40BVTYPPartner Bank Typenvarchar40
TOPPortfolio
79VDCNCLRescission of Business Operation18BVTYPPartner Bank Typenvarchar40
TOPReal Estate Localization Czech Republic
80/CEERE/FUKDTax office: master data4BVTYPPartner Bank Typenvarchar40
TOPReal Estate Management
81BPOBIMMOBusiness Partner - Object Relationship: Real Estate15BVTYPPartner Bank Typenvarchar40
82VIAKBSEGDocument Line Item from SCS for Interface37BVTYPPartner Bank Typenvarchar40
83VIBEPPFlow data - Planned items for real estate management32BVTYPPartner Bank Typenvarchar40
84VIMIIHInvoice Header10BVTYPPartner Bank Typenvarchar40
TOPReal Estate Slovakia
85TIVXCSKVZNLocal regulations: rates, prices, increments15BVTYPPartner Bank Typenvarchar40
TOPReceivablesPayment Management
86VDAD_CONTROLTable with Dates for Auto Debit Run11BVTYPPartner Bank Typenvarchar40
TOPRemaining Beverage - Obsolete Objects
87/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1111BVTYPPartner Bank Typenvarchar40
TOPService Station Retailing
88OIRC_FUELS_PRSSR - Processing profile72BVTYPPartner bank type for invoicing itemsnvarchar40
TOPSocial Insurance
89P01BV_STATStatus Table for PPO Contribution Collect. Notif. Procedure4BVTYPNotification Category for PPO Collection of Contributionsnvarchar10
TOPTreasury
90SPBB1Partner-Bank relationship7BVTYPPartner Bank Typenvarchar40
91VZGPOPartner/role object relationship17BVTYPPartner Bank Typenvarchar40
92VZZKOPOTable condition items31BVTYPPartner Bank Typenvarchar40
93VZZPAROPartner / Role / Object relationship12BVTYPPartner Bank Typenvarchar40
94VZZUSPPayment splitting15BVTYPPartner Bank Typenvarchar40