SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

1OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

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
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
31T5BT1Exceptional Tax Scales3BVTYPTax Scale Groupnvarchar30
32T5BT2Exemption for dependent children2BVTYPTax Scale Groupnvarchar30
33T5BT3Reduction for dependent children2BVTYPTax Scale Groupnvarchar30
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
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
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
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