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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

178 columns | Print definition?ERP 6.0  | BUDGET_PD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta68BUDGET_PDnvarchar100
2/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items194BUDGET_PDnvarchar100
3/BIC/B0000218000PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs33BUDGET_PDnvarchar100
4/BIC/B0000223000PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta60BUDGET_PDnvarchar100
5BSAD_BAKAccounting: Secondary index for customers (cleared items)169BUDGET_PDFM: Budget Periodnvarchar100
6BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)174BUDGET_PDFM: Budget Periodnvarchar100
7BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)77BUDGET_PDFM: Budget Periodnvarchar100
8BSEGAccounting Document Segment333BUDGET_PDFM: Budget Periodnvarchar100
9BSID_BAKAccounting: Secondary Index for Customers169BUDGET_PDFM: Budget Periodnvarchar100
10BSIK_BAKAccounting: Secondary index for vendors174BUDGET_PDFM: Budget Periodnvarchar100
11BSIS_BAKAccounting: Secondary Index for G/L Accounts77BUDGET_PDFM: Budget Periodnvarchar100
12FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)81BUDGET_PDFM: Budget Periodnvarchar100
13FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts81BUDGET_PDFM: Budget Periodnvarchar100
14FMADB_TC_WEIGHTSFMADB: Trace - Saved Weights (Last Run)10BUDGET_PDFM: Budget Periodnvarchar100
15FMBASOBJNR_TRACETrace for table FMBASOBJNR11BUDGET_PDFM: Budget Periodnvarchar100
16FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields12BUDGET_PDFM: Budget Periodnvarchar100
17FUDT_VDOCBSEGVerification Document Item with Additional Info321BUDGET_PDFM: Budget Periodnvarchar100
18FUDT_VDOCBSEGEVVerification Document Item in the Entry View321BUDGET_PDFM: Budget Periodnvarchar100
19FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)319BUDGET_PDFM: Budget Periodnvarchar100
20GLPOS_C_CTFI Document: Entry View334BUDGET_PDFM: Budget Periodnvarchar100
21GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items328BUDGET_PDFM: Budget Periodnvarchar100
22GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items328BUDGET_PDFM: Budget Periodnvarchar100
23GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items328BUDGET_PDFM: Budget Periodnvarchar100
24GLPOS_N_CTNew General Ledger: Line Item with Currency Type343BUDGET_PDFM: Budget Periodnvarchar100
25GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type337BUDGET_PDFM: Budget Periodnvarchar100
26P2B2_C1HCM Declustering B2 - Cost Distribution Table C149BUDGET_PDFM: Budget Periodnvarchar100
27P2B2_CWSTHCM Declustering B2 - PDC Time Tickets116BUDGET_PDFM: Budget Periodnvarchar100
28P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay53BUDGET_PDFM: Budget Periodnvarchar100
29P2B2_WSTHCM Declustering B2 - PDC Time Tickets116BUDGET_PDFM: Budget Periodnvarchar100
30P2PL_RETROADJPayroll Result PL: Retro, originals and changes59BUDGET_PDFM: Budget Periodnvarchar100
31P2PL_RETRODIFPayroll Result PL: Retro, originals and changes59BUDGET_PDFM: Budget Periodnvarchar100
32P2PL_RETROMEMPayroll Result PL: Retro, originals and changes59BUDGET_PDFM: Budget Periodnvarchar100
33P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)68BUDGET_PDFM: Budget Periodnvarchar100
34P2RT_CZDAVP18_0350BUDGET_PDFM: Budget Periodnvarchar100
35P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)68BUDGET_PDFM: Budget Periodnvarchar100
36P2RX_C0Cost Distribution18BUDGET_PDFM: Budget Periodnvarchar100
37P2RX_C1Cost Distribution Table C147BUDGET_PDFM: Budget Periodnvarchar100
38P2RX_FUNDAccounting Structure for Funds Management30BUDGET_PDFM: Budget Periodnvarchar100
39P2RX_WPBPPayroll Results: Work Center/Basic Pay51BUDGET_PDFM: Budget Periodnvarchar100
40REGUPProcessed items from payment program183BUDGET_PDFM: Budget Periodnvarchar100
41T5REGEmployee Information Log for Destruction of Data36BUDGET_PDFM: Budget Periodnvarchar100
42T5RPDPersonnel Data Deletion Log46BUDGET_PDFM: Budget Periodnvarchar100
43ZCATSDBRecords changed with processing status '10'28BUDGET_PDnvarchar100
44ZCATSDB2Records changed with processing status '10'29BUDGET_PDnvarchar100
45ZEIM_LIPSSD document: Delivery: Item data281BUDGET_PDFM: Budget Periodnvarchar100
46ZEIM_VBAPSales Document: Item Data244BUDGET_PDFM: Budget Periodnvarchar100
47T7PIQSINGLEFEESDefine Attributes for Individual Fees28BUDGET_PDFM: Budget Periodnvarchar100
TOPBasic Functions
48ANLPAsset Periodic Values52BUDGET_PDFM: Budget Periodnvarchar100
49ANLZTime-Dependent Asset Allocations38BUDGET_PDFM: Budget Periodnvarchar100
TOPBilling
50VBRPBilling Document: Item Data213BUDGET_PDFM: Budget Periodnvarchar100
TOPBudget Control System
51FMBASOBJNRObject numbers for FM addresses13BUDGET_PDFM: Budget Periodnvarchar100
TOPBudgeting
52BUCC_RULEConsistency Checks - Rules14BUDGET_PDKey Figures - Budget Period aggregationnvarchar10
53FMBLFunds management budget document lines (entry documents)12BUDGET_PDFM: Budget Periodnvarchar100
54FMHBLFunds management budget document lines (held documents)12BUDGET_PDFM: Budget Periodnvarchar100
55FMPEP_VARIANTLSession variants (line part) for transaction FMPEP12BUDGET_PDFM: Budget Periodnvarchar100
TOPBudgeting and Availability Control
56GMBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines23BUDGET_PDFM: Budget Periodnvarchar100
57GMHBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines24BUDGET_PDFM: Budget Periodnvarchar100
TOPConstruction Industry
58T5DBVConstruction Pay: Cost Assignment: Hostels46BUDGET_PDFM: Budget Periodnvarchar100
59T5DBXConstruction Pay: Incentive Wage Connection46BUDGET_PDFM: Budget Periodnvarchar100
TOPContract Accounts Receivable and Payable
60DFKKFMDYINFOLog Data for Subsequent FM Activation in FI-CA11BUDGET_PDFM: Budget Periodnvarchar100
61DFKKOPAADistribution Items with Account Assignment30BUDGET_PDFM: Budget Periodnvarchar100
62DFKKOP_REPOpen Items from FPO4164BUDGET_PDFM: Budget Periodnvarchar100
63DFKKRP3Returns: Manual Posting Specifications30BUDGET_PDFM: Budget Periodnvarchar100
64DFKKSUMPosting totals from FI-CA67BUDGET_PDFM: Budget Periodnvarchar100
65DFKKSUMOLDTotals Records Without Account Assignment Changes23BUDGET_PDFM: Budget Periodnvarchar100
66TFKFMDY2Account Assignments for Subsequent FM Activation9BUDGET_PDFM: Budget Periodnvarchar100
TOPControlling
67COKEY2CO Key Subnumbers Enhancement Table11BUDGET_PDFM: Budget Periodnvarchar100
TOPData Transfer
68PPDITTransfer to Accounting: Lines in HR IDOCs59BUDGET_PDFM: Budget Periodnvarchar100
69PPDSTTransfer to Accounting: Substituted Acc. Assig. Object43BUDGET_PDFM: Budget Periodnvarchar100
70PPKIXTransfer FI/CO: Index of Account Assignment Combinations26BUDGET_PDFM: Budget Periodnvarchar100
TOPElectronic Bank Statement
71FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)83BUDGET_PDFM: Budget Periodnvarchar100
72FEB_ACTAcct Assignment Templates83BUDGET_PDFM: Budget Periodnvarchar100
TOPESS Based on WD ABAP
73HRESS_D_CATS_FAVCATS Favorites: database table35BUDGET_PDFM: Receiver Budget Periodnvarchar100
TOPExternal Services
74ESKNAccount Assignment in Service Package61BUDGET_PDFM: Budget Periodnvarchar100
TOPFinancial Accounting
75ACCTITCompressed Data from FI/CO Document158BUDGET_PDFM: Budget Periodnvarchar100
76BSADAccounting: Secondary Index for Customers (Cleared Items)169BUDGET_PDFM: Budget Periodnvarchar100
77BSAKAccounting: Secondary Index for Vendors (Cleared Items)174BUDGET_PDFM: Budget Periodnvarchar100
78BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)77BUDGET_PDFM: Budget Periodnvarchar100
79BSIDAccounting: Secondary Index for Customers169BUDGET_PDFM: Budget Periodnvarchar100
80BSIKAccounting: Secondary Index for Vendors174BUDGET_PDFM: Budget Periodnvarchar100
81BSISAccounting: Secondary Index for G/L Accounts77BUDGET_PDFM: Budget Periodnvarchar100
82KMZEIFI: Account Assignment Model Item Information93BUDGET_PDFM: Budget Periodnvarchar100
83KOMUAccount Assignment Templates for G/L Account Items97BUDGET_PDFM: Budget Periodnvarchar100
84VBSEGADocument Segment for Document Parking - Asset Database90BUDGET_PDFM: Budget Periodnvarchar100
85VBSEGDDocument Segment for Customer Document Parking126BUDGET_PDFM: Budget Periodnvarchar100
86VBSEGKDocument Segment for Vendor Document Parking138BUDGET_PDFM: Budget Periodnvarchar100
87VBSEGSDocument Segment for Document Parking - G/L Account Database145BUDGET_PDFM: Budget Periodnvarchar100
TOPFreight Processing
88VFKNAccount Determination in Shipment Costs Item42BUDGET_PDFM: Budget Periodnvarchar100
TOPFunctions for U.S. Federal Government
89FMFGKEYKey for Facts-Attributes for Ledger 95/FMUSFGT5BUDGET_PDFM: Budget Periodnvarchar100
TOPFund Accounting
90FMADB_ENTITYADB: Entities Involved in Procedure5BUDGET_PDFM: Budget Periodnvarchar100
91FMCCAVCOObject table 110BUDGET_PDFM: Budget Periodnvarchar100
92FMCCAVCRESERVECCAVC aux table for reserved items9BUDGET_PDFM: Budget Periodnvarchar100
93FMCCBASOBJNRObject numbers for CC addresses8BUDGET_PDFM: Budget Periodnvarchar100
94FMPPFUNDItems for Partial Payment by Fund Process17BUDGET_PDFM: Budget Periodnvarchar100
TOPFunds Management
95FMBUDGETPDFM: Budget Period Master Data2BUDGET_PDFM: Budget Periodnvarchar100
96FMBUDGETPDTFM: Budget Period texts3BUDGET_PDFM: Budget Periodnvarchar100
97FMCFAATR-FM: Commitments/Budget Carried Forward19BUDGET_PDFM: Budget Periodnvarchar100
98FMCFABTR-FM: Commitments/Budget Carried Forward (Sender+Receiver)27BUDGET_PDFM: Budget Periodnvarchar100
99FMCFSBFM - CF: Carryforward rules17BUDGET_PDFM: Budget Periodnvarchar100
100FMFGF2MAFFACTS2 MAF File for Edits26BUDGET_PDFM: Budget Periodnvarchar100
101FMFG_YBA_AVCFMFG: Year of Budget Authority - AVC6BUDGET_PDFM: Budget Periodnvarchar100
102FMFUNDBPDFM: Assignments of Funds to Budget Periods4BUDGET_PDFM: Budget Periodnvarchar100
103FMFYCVAValue Adjustments Before Fiscal Year Change28BUDGET_PDFM: Budget Periodnvarchar100
104FMIAActual Line Item Table for Funds Management52BUDGET_PDFM: Budget Periodnvarchar100
105FMICObject table 26BUDGET_PDFM: Budget Periodnvarchar100
106FMICOITFM/CO integration: Line item20BUDGET_PDFM: Budget Periodnvarchar100
107FMIFIITFI Line Item Table in Funds Management49BUDGET_PDFM: Budget Periodnvarchar100
108FMIOICommitment Documents Funds Management55BUDGET_PDFM: Budget Periodnvarchar100
109FMIPPlan Line Items Table for Funds Management30BUDGET_PDFM: Budget Periodnvarchar100
110FMITTotals Table for Funds Management29BUDGET_PDFM: Budget Periodnvarchar100
111FMZUOBAllocation of CO Object to FM Account Assignment17BUDGET_PDFM: Budget Periodnvarchar100
112KBLPDocument Item: Manual Document Entry98BUDGET_PDFM: Budget Periodnvarchar100
TOPFunds Management-Specific Postings
113FMCJIS-PS: Documents in Cash Desk Subsidiary Ledger21BUDGET_PDFM: Budget Periodnvarchar100
114PAYAC01Account determination7BUDGET_PDFM: Budget Periodnvarchar100
115PSOSEGSRecurring Request Document Segment, G/L Accounts99BUDGET_PDFM: Budget Periodnvarchar100
TOPGeneral Ledger Accounting
116BSEG_ADDEntry View of Accounting Document for Additional Ledgers78BUDGET_PDFM: Budget Periodnvarchar100
117FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)81BUDGET_PDFM: Budget Periodnvarchar100
118FAGLBSISAccounting: Secondary Index for G/L Accounts81BUDGET_PDFM: Budget Periodnvarchar100
119FAGL_SPLINFOSplittling Information of Open Items32BUDGET_PDFM: Budget Periodnvarchar100
TOPGL Account Posting
120TCJ_POSITIONSCash Journal Document Items90BUDGET_PDFM: Budget Periodnvarchar100
TOPInventory Management
121MWXMSEGZMSEG: Interface for Posting of Value180BUDGET_PDFM: Budget Periodnvarchar100
122MWZMSEGZMSEG:Interface for Posting of Value181BUDGET_PDFM: Budget Periodnvarchar100
123RESBReservation/dependent requirements188BUDGET_PDFM: Budget Periodnvarchar100
124RKPFDocument Header: Reservation56BUDGET_PDFM: Budget Periodnvarchar100
TOPInvoice Verification
125RBCODocument Item, Incoming Invoice, Account Assignment76BUDGET_PDFM: Budget Periodnvarchar100
TOPMaterials Management
126/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions170BUDGET_PDFM: Budget Periodnvarchar100
TOPOverhead Cost Controlling
127COEJCO Object: Line Items (by Fiscal Year)198BUDGET_PDFM: Budget Periodnvarchar100
128COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)53BUDGET_PDFM: Budget Periodnvarchar100
129COEPCO Object: Line Items (by Period)77BUDGET_PDFM: Budget Periodnvarchar100
130COEPRCO Object: Line Items for Stat. Key Figs (by Period)25BUDGET_PDFM: Budget Periodnvarchar100
131COSPCO Object: Cost Totals for External Postings151BUDGET_PDFM: Budget Periodnvarchar100
132COSRCO Object: Statistical Key Figure Totals48BUDGET_PDFM: Budget Periodnvarchar100
133COSSCO Object: Cost Totals for Internal Postings167BUDGET_PDFM: Budget Periodnvarchar100
134COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis79BUDGET_PDFM: Budget Periodnvarchar100
TOPOverhead Cost Orders
135TKZU3Overhead Credit9BUDGET_PDFM: Budget Periodnvarchar100
TOPPayment Transactions
136CRACCPayment Cards: Account Assignments in Card Master Record31BUDGET_PDFM: Budget Periodnvarchar100
137CRNUMPayment cards: Card master record52BUDGET_PDFM: Budget Periodnvarchar100
TOPPayroll
138T5TPSC1SPLITRozdelení nákladu57BUDGET_PDRR: Období rozpoctunvarchar100
TOPPayroll General Parts
139HRPY_WPBPHR-PAY: Transparent Table WPBP39BUDGET_PDFM: Budget Periodnvarchar100
TOPPersonnel Administration
140PA0001HR Master Record: Infotype 0001 (Org. Assignment)52BUDGET_PDFM: Budget Periodnvarchar100
TOPPersonnel Cost Planning and Simulation
141HRP5010Database Table for Infotype 501037BUDGET_PDFM: Budget Periodnvarchar100
TOPPersonnel Time Events
142TPTCOR_KOSTLCost Assignment (Correction Scenario)22BUDGET_PDFM: Budget Periodnvarchar100
TOPPersonnel Time Management
143ASSOBAssignment Objects45BUDGET_PDFM: Budget Periodnvarchar100
144CC1ERPIncorrect Time Events from CC1, Postings121BUDGET_PDFM: Budget Periodnvarchar100
145CC1TEVTemporary Buffer for Time Events from CC141BUDGET_PDFM: Budget Periodnvarchar100
146COIFTInterface to Activity Allocation77BUDGET_PDFM: Budget Periodnvarchar100
147PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)78BUDGET_PDFM: Budget Periodnvarchar100
148PTEX2003GENInterface Table for IT 2003: General Information77BUDGET_PDFM: Budget Periodnvarchar100
149PTEX2003SPECInterface Table for IT 2003: Interval Information53BUDGET_PDFM: Budget Periodnvarchar100
150PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)77BUDGET_PDFM: Budget Periodnvarchar100
151TEVEN_MOREAdditional Data for Time Events120BUDGET_PDFM: Budget Periodnvarchar100
TOPPosition Budgeting and Control
152HRFPM_DIFFERENCEHRFPM: Personnel Costs Savings/ Overrun38BUDGET_PDFM: Budget Periodnvarchar100
153HRFPM_FM_POSHRFPM: FM Documents - Items22BUDGET_PDFM: Budget Periodnvarchar100
154HRFPM_FM_POS_BUHRFPM: FM Documents - Items for Budget23BUDGET_PDFM: Budget Periodnvarchar100
155HRFPM_FPM_POSHRFPM: FPM Documents - Items36BUDGET_PDFM: Budget Periodnvarchar100
156HRFPM_FPM_POS_BUHRFPM: FPM Documents - Items for Budget37BUDGET_PDFM: Budget Periodnvarchar100
157HRFPM_OBJECTSHRFPM: Object table of the commitment engine32BUDGET_PDFM: Budget Periodnvarchar100
TOPProfitability Analysis
158CECOEJCO-PA Account Based Line Items200BUDGET_PDFM: Budget Periodnvarchar100
159CECOEPCO-PA Account Based Line Items79BUDGET_PDFM: Budget Periodnvarchar100
TOPPurchasing
160EBANPurchase Requisition140BUDGET_PDFM: Budget Periodnvarchar100
161EBKNPurchase Requisition Account Assignment63BUDGET_PDFM: Budget Periodnvarchar100
162EKCPAPurchasing Contract Commitment Plan Account Assignment Data28BUDGET_PDFM: Budget Periodnvarchar100
163EKKNAccount Assignment in Purchasing Document66BUDGET_PDFM: Budget Periodnvarchar100
164EKPOPurchasing Document Item259BUDGET_PDFM: Budget Periodnvarchar100
TOPRecruitment
165PB0001HR Master Record: Infotype 0001 (Org. Assignment)52BUDGET_PDFM: Budget Periodnvarchar100
TOPRepetitive Manufacturing
166COMPMOVEGoods Movement of Components137BUDGET_PDFM: Budget Periodnvarchar100
TOPRevenues and Earnings
167AD01DLIDynamic items (DI)63BUDGET_PDFM: Budget Periodnvarchar100
TOPSales
168VBAPSales Document: Item Data251BUDGET_PDFM: Budget Periodnvarchar100
TOPSelf-Service Procurement
169/SRMERP/D_ACC_ITAccount assignment item48BUDGET_PDFM: Budget Periodnvarchar100
TOPShipping
170LIPSSD document: Delivery: Item data281BUDGET_PDFM: Budget Periodnvarchar100
TOPSimulation
171VSEBAN_CNVersion: Purchase requisition130BUDGET_PDFM: Budget Periodnvarchar100
172VSEBKN_CNVersion: Purchase requisition account assignment62BUDGET_PDFM: Budget Periodnvarchar100
173VSRESB_CNVersion: Reservation/Dependent requirements193BUDGET_PDFM: Budget Periodnvarchar100
TOPStaffing
174HRT1018Table Division Infotype 1018 Cost Distribution19BUDGET_PDFM: Budget Periodnvarchar100
TOPThird Party Remittance
175T51R6_FUNDINFORemittance detail table for all entities21BUDGET_PDFM: Budget Periodnvarchar100
TOPTime Sheet
176CATSCOCross-Application Time Sheet (CATS): Transfer to CO46BUDGET_PDFM: Receiver Budget Periodnvarchar100
177CATSDBCATS: Database Table for Time Sheet28BUDGET_PDFM: Receiver Budget Periodnvarchar100
178CATS_TEMPCATS: Database Table for Templates30BUDGET_PDFM: Receiver Budget Periodnvarchar100