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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

149 columns | Print definition?ERP 6.0  | ZTERM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta35ZTERMnvarchar40
2/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta35ZTERMnvarchar40
3/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items74ZTERMnvarchar40
4/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact74ZTERMnvarchar40
5/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items87ZTERMnvarchar40
6/CCEE/SIFI_UMSITTax items applied for decrease/increase of input VAT17ZTERMTerms of Payment Keynvarchar40
7BBP_PAYTERMTerms of Payment, Backend-Dependent3ZTERMTerms of Payment Keynvarchar40
8BBP_PAYTERM_TEXTTexts for Terms of Payment, Backend-Dependent4ZTERMTerms of Payment Keynvarchar40
9BBP_RBKPDocument Header: Invoice Receipt23ZTERMTerms of Payment Keynvarchar40
10BBP_TMP_VENObsolete from 2.0C Onwards. Was Never used Before6ZTERMTerms of Payment Keynvarchar40
11BBP_TMP_VEN000Temporary: Request 'Bidder', Purchasing Data6ZTERMTerms of Payment Keynvarchar40
12BSAD_BAKAccounting: Secondary index for customers (cleared items)40ZTERMTerms of Payment Keynvarchar40
13BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)42ZTERMTerms of Payment Keynvarchar40
14BSEGAccounting Document Segment107ZTERMTerms of Payment Keynvarchar40
15BSID_BAKAccounting: Secondary Index for Customers40ZTERMTerms of Payment Keynvarchar40
16BSIK_BAKAccounting: Secondary index for vendors42ZTERMTerms of Payment Keynvarchar40
17BSSEGAccounting Document Segment96ZTERMTerms of Payment Keynvarchar40
18FIEUD_MMINV_HSAFT:MM: Header table for XML Purchase Invoice26ZTERMTerms of Payment Keynvarchar40
19FISUBSTKW_RETCustomize Retention for Statement of Subcontractor Report3ZTERMTerms of Payment Keynvarchar40
20FUDT_VDOCBSEGVerification Document Item with Additional Info96ZTERMTerms of Payment Keynvarchar40
21FUDT_VDOCBSEGEVVerification Document Item in the Entry View96ZTERMTerms of Payment Keynvarchar40
22FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)96ZTERMTerms of Payment Keynvarchar40
23FUDT_VDOCBSEZItem Additional Information of Verification Doc24ZTERMTerms of Payment Keynvarchar40
24FUDT_VDOCBSEZHItem Additional Information of Verification Doc(History)24ZTERMTerms of Payment Keynvarchar40
25GLPOS_C_CTFI Document: Entry View322ZTERMTerms of Payment Keynvarchar40
26GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items322ZTERMTerms of Payment Keynvarchar40
27GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items322ZTERMTerms of Payment Keynvarchar40
28GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items322ZTERMTerms of Payment Keynvarchar40
29GLPOS_N_CTNew General Ledger: Line Item with Currency Type331ZTERMTerms of Payment Keynvarchar40
30GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type331ZTERMTerms of Payment Keynvarchar40
31REGUPProcessed items from payment program50ZTERMTerms of Payment Keynvarchar40
32T043GTolerances for Groups of Customers/Vendors13ZTERMStandard Payment Term for Carryforward Postingsnvarchar40
33T052STerms of Payment for Holdback/Retainage2ZTERMTerms of Payment Keynvarchar40
34T056SInterest scale interest terms (acct bal.int.calc.)4ZTERMTerms of Payment Keynvarchar40
35T056UControl table for calculation of interest on arrears4ZTERMTerms of Payment Keynvarchar40
36TZD0BDarwin: Customer default values per co.cd/trn.type for KNB120ZTERMTerms of Payment Keynvarchar40
37VEN000Business Partner: General Vendor Data6ZTERMTerms of Payment Keynvarchar40
38ZCMM_MTM_01MtM Persistency per Transaction33ZTERMTerms of Payment Keynvarchar40
39ZCMM_MTM_TCMtM per TC40ZTERMTerms of Payment Keynvarchar40
40ZID_KREDICATTBasis Data for CATT zid_apowe8ZTERMTerms of Payment Keynvarchar40
TOPAccounting Interface
41GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)101ZTERMTerms of Payment Keynvarchar40
42GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)101ZTERMTerms of Payment Keynvarchar40
TOPAdvertising Management
43JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset71ZTERMTerms of Payment Keynvarchar40
44JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order27ZTERMTerms of Payment Keynvarchar40
45JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header37ZTERMTerms of Payment Keynvarchar40
46JHTVAABPIS-M/AM: Contract Settlement Item Data37ZTERMTerms of Payment Keynvarchar40
47JHTVKOIS-M/AM: Contract90ZTERMTerms of Payment Keynvarchar40
48JJTVVIS-M/AM: Media Sales Agent Contract23ZTERMTerms of Payment Keynvarchar40
49TJJB9IS-M/AM: Determine Terms of Payment6ZTERMTerms of Payment Keynvarchar40
TOPAgency Business Global Trade
50WBRKAgency business: Header36ZTERMTerms of Payment Keynvarchar40
TOPBasic Functions
51AKKPDocumentary Payment Guarantee: Fin.Doc.Master - Header Data59ZTERMTerms of Payment Keynvarchar40
52EMBKLegal Control: License Master - Header Data38ZTERMTerms of Payment Keynvarchar40
53FDS1Cash Management & Forecast: Line Items of SD Documents12ZTERMTerms of Payment Keynvarchar40
54FPLTBilling Plan: Dates20ZTERMTerms of Payment Keynvarchar40
55FPLTPOBilling Plan: Dates20ZTERMTerms of Payment Keynvarchar40
56VFPLTBilling Plan: Dates20ZTERMTerms of Payment Keynvarchar40
TOPBilling
57VBRKBilling Document: Header Data29ZTERMTerms of Payment Keynvarchar40
TOPBusiness Partner
58TIVBPVENDORCMPVendor Preassignment (CoCd Data)15ZTERMTerms of Payment Keynvarchar40
TOPChargeback
59WCOCOHCondition Contract: Header17ZTERMTerms of Payment Keynvarchar40
TOPConditions
60KONAAgreements32ZTERMTerms of Payment Keynvarchar40
61KONPConditions (Item)44ZTERMTerms of Payment Keynvarchar40
TOPContract Accounts Receivable and Payable
62FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts23ZTERMTerms of Payment Keynvarchar40
63FKK_JLRK_SHORTHeader Data for IS-M/SD Service Settlement - Extracts21ZTERMTerms of Payment Keynvarchar40
64TE052Terms of Payment3ZTERMTerms of Payment Keynvarchar40
TOPCosting
65COERSales Order Value Revenue50ZTERMTerms of Payment Keynvarchar40
TOPCross-Application Components
66BBSIDAccounting: Secondary index for customers40ZTERMTerms of Payment Keynvarchar40
67VVBKDSales Document: Business Data17ZTERMTerms of Payment Keynvarchar40
TOPCustomer Master
68KNVVCustomer Master Sales Data38ZTERMTerms of Payment Keynvarchar40
TOPData Collection
69S008Communications Table SD -> CO/Projects28ZTERMTerms of Payment Keynvarchar40
TOPData Retention Tool
70TXW_S_BSEGRetrieve BSEG from archive88ZTERMTerms of Payment Keynvarchar40
71TXW_S_VBRKRetrieve VBRK from archive29ZTERMTerms of Payment Keynvarchar40
TOPDownloadUpload
72/DSD/HH_RACOLPAYDSD - RA: Revenue and Payment Processing2ZTERMTerms of Payment Keynvarchar40
73/DSD/HH_RAPAYBCDSD - RA: Bank Codes (Not Accepted for Payment Term)2ZTERMTerms of Payment Keynvarchar40
74/DSD/HH_RAPAYTYPDSD - RA: Payment Type (Valid for Payment Term)2ZTERMTerms of Payment Keynvarchar40
TOPExchanges
75OIA08LIA Document: Item Data19ZTERMTerms of Payment Keynvarchar40
TOPFinancial Accounting
76BSADAccounting: Secondary Index for Customers (Cleared Items)40ZTERMTerms of Payment Keynvarchar40
77BSAKAccounting: Secondary Index for Vendors (Cleared Items)42ZTERMTerms of Payment Keynvarchar40
78BSIDAccounting: Secondary Index for Customers40ZTERMTerms of Payment Keynvarchar40
79BSIKAccounting: Secondary Index for Vendors42ZTERMTerms of Payment Keynvarchar40
80KNB1Customer Master (Company Code)23ZTERMTerms of Payment Keynvarchar40
81LFB1Vendor Master (Company Code)16ZTERMTerms of Payment Keynvarchar40
82T052Terms of Payment2ZTERMTerms of Payment Keynvarchar40
83T052UOwn Explanations for Terms of Payment3ZTERMTerms of Payment Keynvarchar40
84VACSPLTFI Document Parking (Enjoy): Amount Split10ZTERMTerms of Payment Keynvarchar40
85VBSEGDDocument Segment for Customer Document Parking50ZTERMTerms of Payment Keynvarchar40
86VBSEGKDocument Segment for Vendor Document Parking56ZTERMTerms of Payment Keynvarchar40
TOPFunctions for U.S. Federal Government
87FMRES_INSTMTSComplete log on Rescheduling8ZTERMTerms of Payment Keynvarchar40
88FMRES_RECV_LISTList of all rescheduled receivables12ZTERMTerms of Payment Keynvarchar40
TOPFunds Management-Specific Postings
89PSOSEGDDocument Segment: Recurring Request, Customer51ZTERMTerms of Payment Keynvarchar40
90PSOSEGKRecurring Request Document Segment, Vendors57ZTERMTerms of Payment Keynvarchar40
TOPGeneric Contract Accounts Receivable and Payable
91TFSC052Terms of Payment3ZTERMTerms of Payment Keynvarchar40
TOPGlobal Trade Services
92/SAPSLL/CUITCustoms Document: Item76ZTERMTerm of Paymentnvarchar60
93/SAPSLL/LCLICKGTS: License - Terms of Payment4ZTERMTerm of Paymentnvarchar60
94/SAPSLL/TCOZTMGTS: Terms of Payment2ZTERMTerm of Paymentnvarchar60
95/SAPSLL/TCOZTMTGTS: Terms of Payment - Texts3ZTERMTerm of Paymentnvarchar60
96/SAPSLL/TLEZGSAssgmt of Term of Payt from FS to Term of Payt at FS Grp Lvl4ZTERMTerm of Paymentnvarchar60
97/SAPSLL/TLEZVSAssignment of Term of Payt from FS to Term of Payt at FS Lvl4ZTERMTerm of Paymentnvarchar60
TOPInformation System
98DKKOSBalance Audit Trail65ZTERMTerms of Payment Keynvarchar40
99DKOKPOpen Item Account Balance Audit Trail63ZTERMTerms of Payment Keynvarchar40
100DKOKSOpen Item Account Balance Audit Trail Master Record68ZTERMTerms of Payment Keynvarchar40
TOPIntegration
101FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts26ZTERMTerms of Payment Keynvarchar40
TOPInvoice Verification
102RBKPDocument Header: Invoice Receipt23ZTERMTerms of Payment Keynvarchar40
103RBVSInvoice Verification: Split Invoice Amount9ZTERMTerms of Payment Keynvarchar40
TOPJoint Venture und Production Sharing Accounting
104T8J68JV EDI Terms of payment2ZTERMTerms of Payment Keynvarchar40
TOPLocalization
105FPIA_FI_IDXFI Index Table for Interest Calculation - Chorus9ZTERMTerms of Payment Keynvarchar40
106FPIA_INTERESTTable for Penalty Interest14ZTERMTerms of Payment Keynvarchar40
107ISJPPAYTERMSTerms of payment with validity period5ZTERMTerms of Payment Keynvarchar40
108J_1BNFDOCNota Fiscal Header21ZTERMTerms of Payment Keynvarchar40
109J_3RFTAX_EXTRDTax Extract Detail Lines90ZTERMTerms of Payment Keynvarchar40
110J_3RF_T052STerms of Payment for Splitting by Goods Shelf Life2ZTERMTerms of Payment Keynvarchar40
111RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions89ZTERMTerms of Payment Keynvarchar40
112RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions89ZTERMTerms of Payment Keynvarchar40
113RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions89ZTERMTerms of Payment Keynvarchar40
TOPLogistics - General
114WBHDTrading Contract: Commercial Data15ZTERMTerms of Payment Key Purchasingnvarchar40
TOPMaster Data
115JGTBVIS-M/SD: Employment Relationship16ZTERMTerms of Payment Keynvarchar40
116JGTVSGVIS-M/SD: Sales Area Data for Service Company7ZTERMTerms of Payment Keynvarchar40
117JGTVSMAIS-M/SD: Default Settlement Data for Service Company6ZTERMTerms of Payment Keynvarchar40
TOPMaterial Maintenance
118TVZBCustomers: Terms of payment2ZTERMTerms of Payment Keynvarchar40
119TVZBTCustomers: Terms of Payment Texts3ZTERMTerms of Payment Keynvarchar40
TOPPatient Accounting
120NVBRKIS-H: Billing document header data19ZTERMTerms of Payment Keynvarchar40
TOPPayment Transactions
121REGUP_COREProcessed Items from Payment Program24ZTERMTerms of payment keynvarchar40
TOPPeriodical Sales and Distribution
122JFRKIS-M/SD: Billing - Header Data19ZTERMTerms of Payment Keynvarchar40
123JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS15ZTERMTerms of Payment Keynvarchar40
124JKKDSales Order: Business Data15ZTERMTerms of Payment Keynvarchar40
125JLRKIS-M/SD: Settlement Header Data19ZTERMTerms of Payment Keynvarchar40
TOPPOS Interface
126WVFBDRS Interface, Intermediate Buffer, Order Item FM10ZTERMTerms of Payment Keynvarchar40
TOPProduction and Revenue Accounting
127OIUCM_CONTRACTPRA Contracts34ZTERMTerms of Payment Keynvarchar40
TOPPurchasing
128EKKOPurchasing Document Header15ZTERMTerms of Payment Keynvarchar40
TOPReal Estate Management
129VIAKBSEGDocument Line Item from SCS for Interface129ZTERMTerms of Payment Keynvarchar40
TOPRemaining Beverage - Obsolete Objects
130/BEV1/CPVBTerms of Payment/Order Types for Cash Payers2ZTERMTerms of Payment for Cash Payersnvarchar40
131/BEV1/CPZBTerms of Payment for Cash Payers2ZTERMTerms of Payment for Cash Payersnvarchar40
132/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)44ZTERMTerms of Payment Keynvarchar40
133/BEV3/CH1030BSG1Document Segment CH Event Ledger Part198ZTERMTerms of Payment Keynvarchar40
134/BEV3/CHCTBDGSZAssign Term of Payment to Deferral Period3ZTERMTerms of Payment Keynvarchar40
TOPSales
135VBKDSales Document: Business Data17ZTERMTerms of Payment Keynvarchar40
TOPSimulation
136VSFPLT_CNVersion: Billing schedule: Dates21ZTERMTerms of Payment Keynvarchar40
137VSVBKD_CNVersion: Sales document - commercial data18ZTERMTerms of Payment Keynvarchar40
TOPTrading Contract
138PPE_D_ITEM_LISTEvents15ZTERMTerms of Payment Keynvarchar40
TOPTransfer to Financial Accounting
139TRACT_ACCITEMAccounting Items24ZTERMTerms of Payment Keynvarchar40
TOPTreasury
140VZKNB1Collector for batch input KNB1 from RF-VV18ZTERMTerms of Payment Keynvarchar40
TOPUS Prompt Payment Act
141T023GActivate company code dependent U.S. Federal functionality7ZTERMTerms of Payment Keynvarchar40
142T023PMapping of material groups to terms of payment keys4ZTERMTerms of Payment Keynvarchar40
143T023QFast/Accelerated Pay Payment Term3ZTERMTerms of Payment Keynvarchar40
TOPVendor Master
144LFM1Vendor master record purchasing organization data13ZTERMTerms of Payment Keynvarchar40
145LFM2Vendor Master Record: Purchasing Data15ZTERMTerms of Payment Keynvarchar40
TOPWaste Management
146EWA_WA_PCKGDSREGGeneral Cargo Entry15ZTERMTerms of Payment Keynvarchar40
147EWA_WA_WEIGHOFFLOffline Weighing70ZTERMTerms of Payment Keynvarchar40
148EWA_WA_WEIGHPROCWeighing Transaction50ZTERMTerms of Payment Keynvarchar40
149EWA_WEIGH_FAVORFavorite Table of Suppliers19ZTERMTerms of Payment Keynvarchar40