SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
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

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
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

TableColumnsDescription
1OITM249Items
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
PHPRef.com - the webs number one PHP Function reference tool

206 columns | Print definition?ERP 6.0  | FISTL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/FORDOCSPLITDocument Header and Line details for Splitting6FISTLFunds Centernvarchar160
2/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta65FISTLnvarchar160
3/OPT/VIM_1ITEM_SDocument Item35FISTLFunds Centernvarchar160
4/OPT/VIM_TITEMDocument Item35FISTLFunds Centernvarchar160
5/SAPF15/FIPO2BWF15 Finanzposition -> Bewirtschafter4FISTLFinanzstellenvarchar160
6/SAPF15/FMITFIPOHHM Summenbeleg F15 Relevanz4FISTLFinanzstellenvarchar160
7BSAD_BAKAccounting: Secondary index for customers (cleared items)129FISTLFunds Centernvarchar160
8BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)132FISTLFunds Centernvarchar160
9BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)66FISTLFunds Centernvarchar160
10BSEGAccounting Document Segment257FISTLFunds Centernvarchar160
11BSID_BAKAccounting: Secondary Index for Customers129FISTLFunds Centernvarchar160
12BSIK_BAKAccounting: Secondary index for vendors132FISTLFunds Centernvarchar160
13BSIS_BAKAccounting: Secondary Index for G/L Accounts66FISTLFunds Centernvarchar160
14BSSEGAccounting Document Segment246FISTLFunds Centernvarchar160
15DFKKEPRTLog for Inconsistent FI-CA Documents58FISTLFunds Centernvarchar160
16FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)66FISTLFunds Centernvarchar160
17FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts66FISTLFunds Centernvarchar160
18FIAPSAD_ORDR_LTLine Item for Order Number KSA20FISTLFunds Centernvarchar160
19FIKZD_CONTR_MAPPSubsoil use contracts mapping15FISTLFunds Centernvarchar160
20FMADB_DEFAULT_AAFMADB: Default Account Assignment for Petty Amounts5FISTLFunds Centernvarchar160
21FMADB_TC_WEIGHTSFMADB: Trace - Saved Weights (Last Run)8FISTLFunds Centernvarchar160
22FUDT_VDOCBSEGVerification Document Item with Additional Info246FISTLFunds Centernvarchar160
23FUDT_VDOCBSEGEVVerification Document Item in the Entry View246FISTLFunds Centernvarchar160
24FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)246FISTLFunds Centernvarchar160
25GLPOS_C_CTFI Document: Entry View116FISTLFunds Centernvarchar160
26GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items116FISTLFunds Centernvarchar160
27GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items116FISTLFunds Centernvarchar160
28GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items116FISTLFunds Centernvarchar160
29GLPOS_N_CTNew General Ledger: Line Item with Currency Type118FISTLFunds Centernvarchar160
30GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type118FISTLFunds Centernvarchar160
31P2B2_C1HCM Declustering B2 - Cost Distribution Table C121FISTLFunds Centernvarchar160
32P2B2_CWSTHCM Declustering B2 - PDC Time Tickets108FISTLFunds Centernvarchar160
33P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay48FISTLFunds Centernvarchar160
34P2B2_WSTHCM Declustering B2 - PDC Time Tickets108FISTLFunds Centernvarchar160
35P2PL_RETROADJPayroll Result PL: Retro, originals and changes31FISTLFunds Centernvarchar160
36P2PL_RETRODIFPayroll Result PL: Retro, originals and changes31FISTLFunds Centernvarchar160
37P2PL_RETROMEMPayroll Result PL: Retro, originals and changes31FISTLFunds Centernvarchar160
38P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)38FISTLFunds Centernvarchar160
39P2RT_CZDAVP18_0322FISTLFunds Centernvarchar160
40P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)38FISTLFunds Centernvarchar160
41P2RX_C0Cost Distribution11FISTLFunds Centernvarchar160
42P2RX_C1Cost Distribution Table C119FISTLFunds Centernvarchar160
43P2RX_FUNDAccounting Structure for Funds Management10FISTLFunds Centernvarchar160
44P2RX_WPBPPayroll Results: Work Center/Basic Pay46FISTLFunds Centernvarchar160
45REGUPProcessed items from payment program134FISTLFunds Centernvarchar160
46T5REGEmployee Information Log for Destruction of Data31FISTLFunds Centernvarchar160
47T5RPDPersonnel Data Deletion Log41FISTLFunds Centernvarchar160
48T5UEFFR_BUND_RECTemporary storage of Bundled records in Effort Certification24FISTLFunds Centernvarchar160
49YVIM_1ITEMDocument Item35FISTLFunds Centernvarchar160
50ZEIM_LIPSSD document: Delivery: Item data118FISTLFunds Centernvarchar160
51ZEIM_VBAPSales Document: Item Data241FISTLFunds Centernvarchar160
52CMACGRANTGrant Master Data16FISTLFunds Centernvarchar160
53HRT1759Table Section for Infotype 175916FISTLFunds Centernvarchar160
54T7PIQSINGLEFEESDefine Attributes for Individual Fees22FISTLFunds Centernvarchar160
55TCMAC06DDerivation of ISR Scenario Related Data20FISTLFunds Centernvarchar160
TOPAccounting Interface
56GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)182FISTLFunds Centernvarchar160
57GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)182FISTLFunds Centernvarchar160
TOPActual CostingMaterial Ledger
58MLCOMaterial valuation document account assignment information9FISTLFunds Centernvarchar160
TOPBasic Functions
59ANLPAsset Periodic Values56FISTLFunds Centernvarchar160
60ANLZTime-Dependent Asset Allocations28FISTLFunds Centernvarchar160
TOPBilling
61VBRPBilling Document: Item Data210FISTLFunds Centernvarchar160
TOPBudget Management
62HRP1519DB Table for Infotype 151920FISTLFunds Centernvarchar160
TOPBudgeting and Availability Control
63FMCDRBRevenues Increasing the Budget Government of Canada5FISTLFunds Centernvarchar160
64FMCDRBERevenues Increasing Budget Government of Canada (Receiver)5FISTLSender funds centernvarchar160
65FMFCTRMVStore Bgt vals. returned before moving funds ctr.3FISTLFunds Centernvarchar160
TOPConfirmations
66AFRVConfirmation pool29FISTLFunds Centernvarchar160
67AFRV_DELBackup Copy for Confirmation Pool29FISTLFunds Centernvarchar160
TOPConstruction Industry
68T5DBVConstruction Pay: Cost Assignment: Hostels18FISTLFunds Centernvarchar160
69T5DBXConstruction Pay: Incentive Wage Connection18FISTLFunds Centernvarchar160
TOPContract Accounts Receivable and Payable
70DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations9FISTLFunds Centernvarchar160
71DFKKFMDYINFOLog Data for Subsequent FM Activation in FI-CA5FISTLFunds Centernvarchar160
72DFKKOPAADistribution Items with Account Assignment24FISTLFunds Centernvarchar160
73DFKKOP_REPOpen Items from FPO4158FISTLFunds Centernvarchar160
74DFKKRP3Returns: Manual Posting Specifications24FISTLFunds Centernvarchar160
75DFKKSUMPosting totals from FI-CA61FISTLFunds Centernvarchar160
76DFKKSUMOLDTotals Records Without Account Assignment Changes17FISTLFunds Centernvarchar160
77FMCA_CLEAR_ACCMaintain Assgt of Clarification Worklist to FM Acct Assgt5FISTLFunds Centernvarchar160
78TFKFMDY2Account Assignments for Subsequent FM Activation4FISTLFunds Centernvarchar160
TOPCross-Application Components
79BBSIDAccounting: Secondary index for customers129FISTLFunds Centernvarchar160
TOPCross-Application Objects in HR
80HRP5581DB Table for Infotype 558140FISTLFunds Centernvarchar160
TOPData Transfer
81PPDITTransfer to Accounting: Lines in HR IDOCs25FISTLFunds Centernvarchar160
82PPDSTTransfer to Accounting: Substituted Acc. Assig. Object14FISTLFunds Centernvarchar160
83PPKIXTransfer FI/CO: Index of Account Assignment Combinations17FISTLFunds Centernvarchar160
TOPDefense Forces and Public Security
84/ISDFPS/ZEBANCopy of EBAN86FISTLFunds Centernvarchar160
TOPElectronic Bank Statement
85FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)56FISTLFunds Centernvarchar160
86FEB_ACTAcct Assignment Templates56FISTLFunds Centernvarchar160
TOPExternal Services
87ESKNAccount Assignment in Service Package47FISTLFunds Centernvarchar160
TOPFinancial Accounting
88/OPT/VIM_1ITEMDocument Item35FISTLFunds Centernvarchar160
89ACCTITCompressed Data from FI/CO Document103FISTLFunds Centernvarchar160
90BSADAccounting: Secondary Index for Customers (Cleared Items)129FISTLFunds Centernvarchar160
91BSAKAccounting: Secondary Index for Vendors (Cleared Items)132FISTLFunds Centernvarchar160
92BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)66FISTLFunds Centernvarchar160
93BSIDAccounting: Secondary Index for Customers129FISTLFunds Centernvarchar160
94BSIKAccounting: Secondary Index for Vendors132FISTLFunds Centernvarchar160
95BSISAccounting: Secondary Index for G/L Accounts66FISTLFunds Centernvarchar160
96KMZEIFI: Account Assignment Model Item Information55FISTLFunds Centernvarchar160
97KOMUAccount Assignment Templates for G/L Account Items55FISTLFunds Centernvarchar160
98VBSEGADocument Segment for Document Parking - Asset Database38FISTLFunds Centernvarchar160
99VBSEGDDocument Segment for Customer Document Parking38FISTLFunds Centernvarchar160
100VBSEGKDocument Segment for Vendor Document Parking43FISTLFunds Centernvarchar160
101VBSEGSDocument Segment for Document Parking - G/L Account Database101FISTLFunds Centernvarchar160
TOPFreight Processing
102VFKNAccount Determination in Shipment Costs Item34FISTLFunds Centernvarchar160
TOPFund Accounting
103FMADB_ENTITYADB: Entities Involved in Procedure3FISTLFunds Centernvarchar160
104FMPPFUNDItems for Partial Payment by Fund Process11FISTLFunds Centernvarchar160
TOPFunds Management
105FIWF_ACGRPAccount Assignment Groups for Role Definition12FISTLFunds Centernvarchar160
106FMAVCis being deleted4FISTLFunds Centernvarchar160
107FMCDRBBSFM Rev. Incr. Budget History - Government Canada5FISTLSender funds centernvarchar160
108FMCFSIFFI-FM: Selected Open Documents from FI Update24FISTLFunds Centernvarchar160
109FMCFSIF_TRSelected Open FI Documents (Settlement)24FISTLFunds Centernvarchar160
110FMCFSIOFI-FM: Selected Open Commitment Documents27FISTLFunds Centernvarchar160
111FMCFSIO_TRFI-FM: Selected Open Commitment Documents27FISTLFunds Centernvarchar160
112FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values11FISTLFunds Centernvarchar160
113FMEUTRANSParameters for Euro Conversion4FISTLFunds Center for Euro Conversionnvarchar160
114FMFYCVAValue Adjustments Before Fiscal Year Change17FISTLFunds Centernvarchar160
115FMHISVHierarchy table of funds centers in Hivariant4FISTLFunds Centernvarchar160
116FMIAAAssignment Table for Budget Ledger5FISTLFunds Centernvarchar160
117FMICOITFM/CO integration: Line item12FISTLFunds Centernvarchar160
118FMIFIITFI Line Item Table in Funds Management18FISTLFunds Centernvarchar160
119FMIOObject Table for Funds Management8FISTLFunds Centernvarchar160
120FMIOICommitment Documents Funds Management24FISTLFunds Centernvarchar160
121FMLGD_H_VG_01_01Budget Type 01: Customer Down Payment9FISTLFunds Centernvarchar160
122FMLGD_H_VG_02_01Posting Type 02: Vendor Down Payment9FISTLFunds Centernvarchar160
123FMLGD_H_VG_03_01Posting Type 03: G/L Account Debit Posting7FISTLFunds Centernvarchar160
124FMLGD_H_VG_04_01Posting Type 04: G/L Account Credit Posting7FISTLFunds Centernvarchar160
125FMMM1Assignment Table for Warehouse Funds Center4FISTLFunds Centernvarchar160
126FMSPLITOObject table 113FISTLFunds Centernvarchar160
127FMUSFGOObject table 1 for US Federal Government16FISTLFunds Centernvarchar160
128FMWF_BDGRPFM Account Groups for FM Role Definition6FISTLFunds Centernvarchar160
129FMZUCHChange information on allocation of CO Object to FM Object11FISTLFunds Centernvarchar160
130FMZUGRAllocation of CO Group to FM Account Assignment11FISTLFunds Centernvarchar160
131FMZUOBAllocation of CO Object to FM Account Assignment9FISTLFunds Centernvarchar160
132KBLPDocument Item: Manual Document Entry26FISTLFunds Centernvarchar160
133TBPCABudget Costing6FISTLFunds Centernvarchar160
134TBPFMFM Active Availability Control3FISTLFunds Centernvarchar160
135TBPFMXActive availability control on commitment budget3FISTLFunds Centernvarchar160
136TBPW1is being deleted4FISTLFunds Centernvarchar160
TOPFunds Management-Specific Postings
137FMBGACORRSHistory for Input Tax Adjustments PCOs6FISTLFunds Centernvarchar160
138FMBGADCTAXData from Backdated Tax Calculation for PCOs6FISTLFunds Centernvarchar160
139FMBGAKONTAssignment of FM Account Assignment to PCO5FISTLFunds Centernvarchar160
140FMD1_F15_FIPO2BWF15 Interface - Commitment Item -> Manager3FISTLFunds Centernvarchar160
141FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years100FISTLFunds Centernvarchar160
142PAYAC01Account determination8FISTLFunds Centernvarchar160
143PSO50Stop Mass Processing Data for Invoice Reference7FISTLFunds Centernvarchar160
144PSO54Posting Information Small Amounts8FISTLFunds Centernvarchar160
145PSOSEGADocument Segment for Assets Document Parking39FISTLFunds Centernvarchar160
146PSOSEGDDocument Segment: Recurring Request, Customer39FISTLFunds Centernvarchar160
147PSOSEGKRecurring Request Document Segment, Vendors44FISTLFunds Centernvarchar160
148PSOSEGSRecurring Request Document Segment, G/L Accounts100FISTLFunds Centernvarchar160
TOPGeneral Ledger Accounting
149BSEG_ADDEntry View of Accounting Document for Additional Ledgers54FISTLFunds Centernvarchar160
150FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)66FISTLFunds Centernvarchar160
151FAGLBSISAccounting: Secondary Index for G/L Accounts66FISTLFunds Centernvarchar160
152FAGL_SPLINFOSplittling Information of Open Items30FISTLFunds Centernvarchar160
TOPGL Account Posting
153TCJ_POSITIONSCash Journal Document Items63FISTLFunds Centernvarchar160
TOPInventory Management
154MSEGDocument Segment: Material147FISTLFunds Centernvarchar160
155MWXMSEGZMSEG: Interface for Posting of Value147FISTLFunds Centernvarchar160
156MWZMSEGZMSEG:Interface for Posting of Value147FISTLFunds Centernvarchar160
157RESBReservation/dependent requirements180FISTLFunds Centernvarchar160
158RKPFDocument Header: Reservation51FISTLFunds Centernvarchar160
TOPInvoice Verification
159RBCODocument Item, Incoming Invoice, Account Assignment13FISTLFunds Centernvarchar160
TOPLocal Currency Changeover
160EWUFI_SCAEMU conversion: Table of the clearings to be adjusted25FISTLFunds Centernvarchar160
TOPLocalization
161ITFM_D_RESIDUALSITFM: Residuals: EFD Residuals data Table14FISTLFunds Centernvarchar160
TOPMaterials Management
162/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions91FISTLFunds Centernvarchar160
TOPPayment Transactions
163CRACCPayment Cards: Account Assignments in Card Master Record24FISTLFunds Centernvarchar160
164CRNUMPayment cards: Card master record45FISTLFunds Centernvarchar160
TOPPayroll
165T5TPSC1SPLITRozdelení nákladu29FISTLFinancní místonvarchar160
TOPPayroll General Parts
166HRPY_WPBPHR-PAY: Transparent Table WPBP34FISTLFunds Centernvarchar160
TOPPersonnel Administration
167PA0001HR Master Record: Infotype 0001 (Org. Assignment)47FISTLFunds Centernvarchar160
TOPPersonnel Time Events
168TPTCOR_KOSTLCost Assignment (Correction Scenario)10FISTLFunds Centernvarchar160
TOPPersonnel Time Management
169ASSOBAssignment Objects17FISTLFunds Centernvarchar160
170CC1ERPIncorrect Time Events from CC1, Postings109FISTLFunds Centernvarchar160
171CC1TEVTemporary Buffer for Time Events from CC133FISTLFunds Centernvarchar160
172COIFTInterface to Activity Allocation49FISTLFunds Centernvarchar160
173PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)58FISTLFunds Centernvarchar160
174PTEX2003GENInterface Table for IT 2003: General Information57FISTLFunds Centernvarchar160
175PTEX2003SPECInterface Table for IT 2003: Interval Information33FISTLFunds Centernvarchar160
176PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)57FISTLFunds Centernvarchar160
177TEVEN_MOREAdditional Data for Time Events108FISTLFunds Centernvarchar160
TOPPlant Data Collection
178RUECKTemp. storage for subsystem confirmations24FISTLFunds Centernvarchar160
TOPPosition Budgeting and Control
179HRFPM_DIFFERENCEHRFPM: Personnel Costs Savings/ Overrun40FISTLFunds Centernvarchar160
180HRFPM_FM_POSHRFPM: FM Documents - Items24FISTLFunds Centernvarchar160
181HRFPM_FM_POS_BUHRFPM: FM Documents - Items for Budget25FISTLFunds Centernvarchar160
182HRFPM_FPM_POSHRFPM: FPM Documents - Items38FISTLFunds Centernvarchar160
183HRFPM_FPM_POS_BUHRFPM: FPM Documents - Items for Budget39FISTLFunds Centernvarchar160
184HRFPM_OBJECTSHRFPM: Object table of the commitment engine34FISTLFunds Centernvarchar160
TOPPurchasing
185EBANPurchase Requisition86FISTLFunds Centernvarchar160
186EBKNPurchase Requisition Account Assignment49FISTLFunds Centernvarchar160
187EKCPAPurchasing Contract Commitment Plan Account Assignment Data10FISTLFunds Centernvarchar160
188EKKNAccount Assignment in Purchasing Document52FISTLFunds Centernvarchar160
189EKPOPurchasing Document Item98FISTLFunds Centernvarchar160
190MEREQXPurchase Requisition Change Parameter86FISTLUpdated information in related user data fieldnvarchar10
TOPRecruitment
191PB0001HR Master Record: Infotype 0001 (Org. Assignment)47FISTLFunds Centernvarchar160
TOPRemaining Beverage - Obsolete Objects
192/BEV3/CH1030BSG2Document Segment CH Event Ledger Part213FISTLFunds Centernvarchar160
TOPRepetitive Manufacturing
193COMPMOVEGoods Movement of Components127FISTLFunds Centernvarchar160
TOPSales
194VBAPSales Document: Item Data248FISTLFunds Centernvarchar160
TOPSelf-Service Procurement
195/SRMERP/D_ACC_ITAccount assignment item34FISTLFunds Centernvarchar160
TOPShipping
196LIPSSD document: Delivery: Item data118FISTLFunds Centernvarchar160
TOPSimulation
197VSEBAN_CNVersion: Purchase requisition86FISTLFunds Centernvarchar160
198VSEBKN_CNVersion: Purchase requisition account assignment38FISTLFunds Centernvarchar160
199VSRESB_CNVersion: Reservation/Dependent requirements184FISTLFunds Centernvarchar160
TOPStaffing
200HRT1018Table Division Infotype 1018 Cost Distribution15FISTLFunds Centernvarchar160
TOPTechnical Application Support
201CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted22FISTLFunds Centernvarchar160
TOPThird Party Remittance
202T51R6_FUNDINFORemittance detail table for all entities7FISTLFunds Centernvarchar160
TOPTraining and Event Management
203T77REFDOCReference Document Table: Training and Event Management60FISTLFunds Centernvarchar160
TOPTravel Expenses
204PA0017HR master record: Infotype 0017 (Travel Privileges)36FISTLFunds Centernvarchar160
205PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document24FISTLFunds Centernvarchar160
TOPTravel Planning
206FTPT_REQ_ACCOUNTTravel Request Cost Assignment21FISTLFunds Centernvarchar160