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

148 columns | Print definition?ERP 6.0  | ZUONR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPKP01Chasier connection to sales document2ZUONRAllocation numbernvarchar100
2/ATL/KPKP01KPChasier connection to sales document - Temporary2ZUONRAllocation numbernvarchar100
3/ATL/KPRCPTDetail of receipt10ZUONRAllocation numbernvarchar100
4/ATL/KPRCPTKPDetail of temporary receipt10ZUONRAllocation numbernvarchar100
5/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta69ZUONRnvarchar180
6/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta69ZUONRnvarchar180
7/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items75ZUONRnvarchar180
8/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact75ZUONRnvarchar180
9/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta61ZUONRnvarchar180
10/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items88ZUONRnvarchar180
11/OPT/VIM_1CLEAR/OPT/VIM_1HEAD Extension with Clearing Documents (BSAK)13ZUONRAssignment Numbernvarchar180
12/OPT/VIM_1ITEM_SDocument Item24ZUONRAssignment Numbernvarchar180
13/OPT/VIM_TITEMDocument Item24ZUONRAssignment Numbernvarchar180
14BBP_RBKPDocument Header: Invoice Receipt65ZUONRAssignment Numbernvarchar180
15BSAD_BAKAccounting: Secondary index for customers (cleared items)8ZUONRAssignment Numbernvarchar180
16BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)8ZUONRAssignment Numbernvarchar180
17BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)6ZUONRAssignment Numbernvarchar180
18BSEGAccounting Document Segment55ZUONRAssignment Numbernvarchar180
19BSID_BAKAccounting: Secondary Index for Customers8ZUONRAssignment Numbernvarchar180
20BSIK_BAKAccounting: Secondary index for vendors8ZUONRAssignment Numbernvarchar180
21BSIS_BAKAccounting: Secondary Index for G/L Accounts6ZUONRAssignment Numbernvarchar180
22BSSEGAccounting Document Segment44ZUONRAssignment Numbernvarchar180
23CNVA_PCREA_GRIROGR/IR Items - Results (Level 2)7ZUONRAssignment Numbernvarchar180
24CNVTDMS_05_BSADHeader table for BSAD10ZUONRDOCNR for table CNVTDMS_05_VSnvarchar200
25CNVTDMS_05_BSAD1Header table for BSAD10ZUONRZUONR for TDMSnvarchar180
26CNVTDMS_05_BSAKHeader table for BSAK10ZUONRDOCNR for table CNVTDMS_05_VSnvarchar200
27CNVTDMS_05_BSAK1Header table for BSAK10ZUONRZUONR for TDMSnvarchar180
28CNVTDMS_05_BSASFill Header BSAS - P&G7ZUONRZUONR for TDMSnvarchar180
29CNVTDMS_05_BSEGFILL Header BSEG7ZUONRDOCNR for table CNVTDMS_05_VSnvarchar200
30CNVTDMS_05_BSEG1FILL Header BSEG7ZUONRZUONR for TDMSnvarchar180
31CNVTDMS_05_BSISFill Header BSIS - P&G7ZUONRZUONR for TDMSnvarchar180
32EPIC_EBR_HDROBSOLETE!!!57ZUONRAssignment Numbernvarchar180
33FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)6ZUONRAssignment Numbernvarchar180
34FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts6ZUONRAssignment Numbernvarchar180
35FUDT_VDOCBSEGVerification Document Item with Additional Info44ZUONRAssignment Numbernvarchar180
36FUDT_VDOCBSEGEVVerification Document Item in the Entry View44ZUONRAssignment Numbernvarchar180
37FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)44ZUONRAssignment Numbernvarchar180
38GLPOS_C_CTFI Document: Entry View324ZUONRAssignment Numbernvarchar180
39GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items324ZUONRAssignment Numbernvarchar180
40GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items324ZUONRAssignment Numbernvarchar180
41GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items324ZUONRAssignment Numbernvarchar180
42GLPOS_N_CTNew General Ledger: Line Item with Currency Type333ZUONRAssignment Numbernvarchar180
43GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type333ZUONRAssignment Numbernvarchar180
44J_1UF_TAX_POSExtended data of tax document positions29ZUONRAssignment Numbernvarchar180
45MHNDDunning Data18ZUONRAssignment Numbernvarchar180
46REGUPProcessed items from payment program119ZUONRAssignment Numbernvarchar180
47YVIM_1ITEMDocument Item24ZUONRAssignment Numbernvarchar180
48ZEIM_VBAKSales Document: Header Data88ZUONRAssignment numbernvarchar180
TOPAccounting Interface
49GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)133ZUONRAssignment Numbernvarchar180
50GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)133ZUONRAssignment Numbernvarchar180
TOPAdvertising Management
51JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header72ZUONRAssignment Numbernvarchar180
52JHTFPIS-M/AM: Billing/Settlement Documents - Item131ZUONRIS-M: Assignment number in FI documentnvarchar180
TOPAgency Business Global Trade
53WBRKAgency business: Header28ZUONRAssignment Numbernvarchar180
TOPAutomatic Payments
54PAYRQPayment Requests124ZUONRAssignment Numbernvarchar180
55PAYRQPPAYRQ Enhancement (Cross-Country Bank Account Transfers)9ZUONRAssignment Numbernvarchar180
TOPBasic Functions
56ANEKDocument Header Asset Posting34ZUONRAssignment Numbernvarchar180
57BSIWIndex table for customer bills of exchange used4ZUONRAssignment Numbernvarchar180
58BSIXIndex table for customer bills of exchange used4ZUONRAssignment Numbernvarchar180
59FDESCash Management and Forecast: Memo Records22ZUONRAssignment Numbernvarchar180
60FDESDISTCash management memo records (distributed)23ZUONRAssignment Numbernvarchar180
61FEBEPElectronic Bank Statement Line Items35ZUONRAssignment Numbernvarchar180
TOPBilling
62VBRKBilling Document: Header Data80ZUONRAssignment numbernvarchar180
TOPCash Desk
63FMSHERLOCKClarification List (Payments to be Clarified)28ZUONRAssignment Numbernvarchar180
TOPContract Accounts Receivable and Payable
64FKKBEPElectronic Bank Statement Line Items35ZUONRAssignment Numbernvarchar180
TOPCross-Application Components
65BBSIDAccounting: Secondary index for customers8ZUONRAssignment Numbernvarchar180
66VVBAKSales Document: Header Data88ZUONRAssignment numbernvarchar180
TOPData Retention Tool
67TXW_S_BSEGRetrieve BSEG from archive28ZUONRAssignment Numbernvarchar180
TOPData Transfer
68PPDITTransfer to Accounting: Lines in HR IDOCs14ZUONRAssignment Numbernvarchar180
TOPElectronic Bank Statement
69FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)13ZUONRAssignment Numbernvarchar180
70FEB_ACTAcct Assignment Templates13ZUONRAssignment Numbernvarchar180
71FEB_AVIR_EXTDAdvice Note Subitem Enhancement (Bank Statement Postproc.)10ZUONRAssignment Numbernvarchar180
72FEB_ITEM_SAVESaving of Posting Items for Postprocessing (On Account)19ZUONRAssignment Numbernvarchar180
TOPFinancial Accounting
73/OPT/VIM_1HEADDocument Header171ZUONRAssignment Numbernvarchar180
74/OPT/VIM_1ITEMDocument Item24ZUONRAssignment Numbernvarchar180
75ACCTITCompressed Data from FI/CO Document185ZUONRAssignment Numbernvarchar180
76AVIPPayment Advice Line Item17ZUONRAssignment Numbernvarchar180
77BSADAccounting: Secondary Index for Customers (Cleared Items)8ZUONRAssignment Numbernvarchar180
78BSAKAccounting: Secondary Index for Vendors (Cleared Items)8ZUONRAssignment Numbernvarchar180
79BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)6ZUONRAssignment Numbernvarchar180
80BSIDAccounting: Secondary Index for Customers8ZUONRAssignment Numbernvarchar180
81BSIKAccounting: Secondary Index for Vendors8ZUONRAssignment Numbernvarchar180
82BSISAccounting: Secondary Index for G/L Accounts6ZUONRAssignment Numbernvarchar180
83EBSEGDoc.Segment of Fin.Accntng External Documents28ZUONRAssignment Numbernvarchar180
84KMZEIFI: Account Assignment Model Item Information16ZUONRAssignment Numbernvarchar180
85KOMUAccount Assignment Templates for G/L Account Items16ZUONRAssignment Numbernvarchar180
86VBSEGADocument Segment for Document Parking - Asset Database21ZUONRAssignment Numbernvarchar180
87VBSEGDDocument Segment for Customer Document Parking30ZUONRAssignment Numbernvarchar180
88VBSEGKDocument Segment for Vendor Document Parking35ZUONRAssignment Numbernvarchar180
89VBSEGSDocument Segment for Document Parking - G/L Account Database25ZUONRAssignment Numbernvarchar180
TOPFlexible Real Estate Management
90VIXCOTDOCCOA, Distribution of VAT, Documents18ZUONRAssignment Numbernvarchar180
TOPFunds Management-Specific Postings
91FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years27ZUONRAssignment Numbernvarchar180
92PSOSEGADocument Segment for Assets Document Parking22ZUONRAssignment Numbernvarchar180
93PSOSEGDDocument Segment: Recurring Request, Customer31ZUONRAssignment Numbernvarchar180
94PSOSEGKRecurring Request Document Segment, Vendors36ZUONRAssignment Numbernvarchar180
95PSOSEGSRecurring Request Document Segment, G/L Accounts26ZUONRAssignment Numbernvarchar180
TOPGeneral Ledger Accounting
96BSEG_ADDEntry View of Accounting Document for Additional Ledgers16ZUONRAssignment Numbernvarchar180
97FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)6ZUONRAssignment Numbernvarchar180
98FAGLBSISAccounting: Secondary Index for G/L Accounts6ZUONRAssignment Numbernvarchar180
TOPGL transfer
99BKKC02General Ledger: Posting Totals for FI20ZUONRAssignment Numbernvarchar180
100BKKCNOITGLTable of Items not Updated on the Account37ZUONRAssignment Numbernvarchar180
101BKKITGLGen. Ledger: Payment Item Data24ZUONRAssignment Numbernvarchar180
102TBKKCASSGL Account Assignment14ZUONRAssignment Numbernvarchar180
TOPInformation System
103BWPOSValuations for Open Items19ZUONRAssignment Numbernvarchar180
104DKKOPBalance Audit Trail40ZUONRAssignment Numbernvarchar180
105DKOKPOpen Item Account Balance Audit Trail49ZUONRAssignment Numbernvarchar180
106DSKOPBalance Audit Trail45ZUONRAssignment Numbernvarchar180
TOPInvoice Verification
107RBCODocument Item, Incoming Invoice, Account Assignment66ZUONRAssignment Numbernvarchar180
108RBKPDocument Header: Invoice Receipt65ZUONRAssignment Numbernvarchar180
TOPLease Accounting
109FILA_GF_ITEMDATAProcess Data52ZUONRAssignment Numbernvarchar180
TOPLoans Management
110TTONFTVZZBEPPTest neue FIMA: VZZBEPP171ZUONRZuordnungsnummernvarchar180
111VDBEKIFlow Data: Document Header for Actual Record23ZUONRAssignment Numbernvarchar180
112VDBEKI_SHADOWShadow Table for VDBEKI (Restrictions)23ZUONRAssignment Numbernvarchar180
113VDBEPPFlow Data - Planned Item25ZUONRAssignment Numbernvarchar180
114VDBOBEPPBusiness Operation: Entered and Activated Flow Data25ZUONRAssignment Numbernvarchar180
115VDCFWAREHOUSECash Flow Management66ZUONRAssignment Numbernvarchar180
116VDORDERBorrower's note loan order data66ZUONRAssignment Numbernvarchar180
117VZFZE_VDBEKICentral Entry Table for Release Procedure26ZUONRAssignment Numbernvarchar180
118VZFZE_VDBEPPCentral Entry Table for Release Procedure28ZUONRAssignment Numbernvarchar180
TOPLocal Currency Changeover
119EWUMMFIEMU: transfer table for clearing entries MM-FI6ZUONRAssignment Numbernvarchar180
TOPLocalization
120J_3RFTAX_EXTRDTax Extract Detail Lines91ZUONRAssignment Numbernvarchar180
121J_3RSL_BK_TABLETransparent table for SaleBook (ALV)98ZUONRAssignment Numbernvarchar180
122RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions90ZUONRAssignment Numbernvarchar180
123RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions90ZUONRAssignment Numbernvarchar180
124RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions90ZUONRAssignment Numbernvarchar180
TOPPatient Accounting
125NVBRKIS-H: Billing document header data53ZUONRAssignment numbernvarchar180
126TN21ZIS-H: Incoming Payments Control Parameters11ZUONRAssignment Numbernvarchar180
TOPPayment Transactions
127FPRL_ITEMItem Data59ZUONRAssignment Numbernvarchar180
TOPPeriodical Sales and Distribution
128JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS14ZUONRAssignment Numbernvarchar180
129JKACCFIZUOIS-M/SD: Payment Log - FI Document Data at Cycle Level10ZUONRAssignment Numbernvarchar180
TOPReal Estate Management
130VIAKBSEGDocument Line Item from SCS for Interface30ZUONRAssignment Numbernvarchar180
131VIMIIPInvoice Items13ZUONRAssignment Numbernvarchar180
TOPRemaining Beverage - Obsolete Objects
132/BEV1/RBVBAKSales Document: Header Data88ZUONRAssignment numbernvarchar180
133/BEV3/CH1030BSG1Document Segment CH Event Ledger Part146ZUONRAssignment Numbernvarchar180
134/BEV3/CHABELFLUSContract Statement Document Flow16ZUONRAssignment Numbernvarchar180
TOPRouting
135PLMZAllocation of bill of material items to operations4ZUONRNo. for material comp. allocation to task listnvarchar80
TOPRouting EBOM Assignment
136/PLMI/RTGRCALNKHRouting Component Assignment Link12ZUONRNo. for material comp. allocation to task listnvarchar80
TOPSales
137VBAKSales Document: Header Data88ZUONRAssignment numbernvarchar180
TOPSAP Healthcare - Industry-Specific Components for Hospitals
138NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)151ZUONRnvarchar100
TOPSimulation
139VSVBAK_CNVersion: Sales document: Header data89ZUONRAssignment numbernvarchar180
TOPTransaction Manager
140OTC_CONV_FHAPOBackup Table for Financial Transaction Flows95ZUONRAssignment Numbernvarchar180
141OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows72ZUONRAssignment Numbernvarchar180
142VTBFHATransaction38ZUONRFinance Projectnvarchar130
143VTBFHAPOTransaction Flow95ZUONRAssignment Numbernvarchar180
144VTBFHAPO_MIGRMigrated Financial Flows95ZUONRAssignment Numbernvarchar180
145VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows95ZUONRAssignment Numbernvarchar180
146VTIFHAUnderlying transaction36ZUONRFinance Projectnvarchar130
147VTIFHAPOUnderlying transaction flows72ZUONRAssignment Numbernvarchar180
TOPTreasury
148VZZUSPPayment splitting18ZUONRAssignment Numbernvarchar180