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

182 columns | Print definition?ERP 6.0  | FKBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data29FKBERFunctional Areanvarchar160
2/1RA/0SD012MIItems for Class SD01 - Processable30FKBERFunctional Areanvarchar160
3/1RA/0SD014MIItems for Class SD01 - Processed30FKBERFunctional Areanvarchar160
4/ATL/FORDOCSPLITDocument Header and Line details for Splitting9FKBERFunctional Areanvarchar40
5/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta30FKBERnvarchar160
6/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items138FKBERnvarchar40
7/BIC/B0000218000PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs28FKBERnvarchar160
8/BIC/B0000223000PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta37FKBERnvarchar160
9/OPT/VIM_1ITEM_SDocument Item33FKBERFunctional Areanvarchar160
10/OPT/VIM_TITEMDocument Item33FKBERFunctional Areanvarchar160
11/SMD/MD_____0039SID-Tabelle fuer Functional Area3FKBERFunctional Areanvarchar160
12/SMD/MD_____0091SID-Tabelle fuer Functional Area3FKBERFunctional Areanvarchar160
13BSAD_BAKAccounting: Secondary index for customers (cleared items)163FKBERFunctional Areanvarchar160
14BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)168FKBERFunctional Areanvarchar160
15BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)64FKBERFunctional Areanvarchar160
16BSEGAccounting Document Segment268FKBERFunctional Areanvarchar40
17BSID_BAKAccounting: Secondary Index for Customers163FKBERFunctional Areanvarchar160
18BSIK_BAKAccounting: Secondary index for vendors168FKBERFunctional Areanvarchar160
19BSIS_BAKAccounting: Secondary Index for G/L Accounts64FKBERFunctional Areanvarchar160
20BSSEGAccounting Document Segment257FKBERFunctional Areanvarchar160
21FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)64FKBERFunctional Areanvarchar160
22FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts64FKBERFunctional Areanvarchar160
23FARR_C_POB_TYPEConfiguration of Performance Obligation Types18FKBERFunctional Areanvarchar160
24FARR_C_SETTL_ACTSettlement Account customizing table10FKBERFunctional Areanvarchar160
25FARR_D_POBPerformance Obligation35FKBERFunctional Areanvarchar160
26FARR_D_POSTINGPosting table25FKBERFunctional Areanvarchar160
27FIKZD_CONTR_MAPCSubsoil use contracts mapping11FKBERFunctional Areanvarchar40
28FIKZD_CONTR_MAPPSubsoil use contracts mapping14FKBERFunctional Areanvarchar40
29FUDT_VDOCBSEGVerification Document Item with Additional Info257FKBERFunctional Areanvarchar40
30FUDT_VDOCBSEGEVVerification Document Item in the Entry View257FKBERFunctional Areanvarchar40
31FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)257FKBERFunctional Areanvarchar40
32J_1UF_TAXDEC_SELSelections for tax declaration8FKBERFunctional Areanvarchar160
33P2B2_C1HCM Declustering B2 - Cost Distribution Table C142FKBERFunctional Areanvarchar160
34P2B2_CWSTHCM Declustering B2 - PDC Time Tickets127FKBERFunctional Areanvarchar160
35P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay50FKBERFunctional Areanvarchar160
36P2B2_WSTHCM Declustering B2 - PDC Time Tickets127FKBERFunctional Areanvarchar160
37P2PL_RETROADJPayroll Result PL: Retro, originals and changes52FKBERFunctional Areanvarchar160
38P2PL_RETRODIFPayroll Result PL: Retro, originals and changes52FKBERFunctional Areanvarchar160
39P2PL_RETROMEMPayroll Result PL: Retro, originals and changes52FKBERFunctional Areanvarchar160
40P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)59FKBERFunctional Areanvarchar160
41P2RT_CZDAVP18_0343FKBERFunctional Areanvarchar160
42P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)59FKBERFunctional Areanvarchar160
43P2RX_C0Cost Distribution15FKBERFunctional Areanvarchar160
44P2RX_C1Cost Distribution Table C140FKBERFunctional Areanvarchar160
45P2RX_FUNDAccounting Structure for Funds Management27FKBERFunctional Areanvarchar160
46P2RX_WPBPPayroll Results: Work Center/Basic Pay48FKBERFunctional Areanvarchar160
47REGUPProcessed items from payment program177FKBERFunctional Areanvarchar160
48T5REGEmployee Information Log for Destruction of Data33FKBERFunctional Areanvarchar160
49T5RPDPersonnel Data Deletion Log43FKBERFunctional Areanvarchar160
50T5UEFFR_BUND_RECTemporary storage of Bundled records in Effort Certification25FKBERFunctional Areanvarchar160
51YVIM_1ITEMDocument Item33FKBERFunctional Areanvarchar160
52ZEIM_LIPSSD document: Delivery: Item data246FKBERFunctional Areanvarchar160
53ZEIM_VBAPSales Document: Item Data242FKBERFunctional Areanvarchar160
54CMACGRANTGrant Master Data23FKBERFunctional Areanvarchar160
55HRT1759Table Section for Infotype 175914FKBERFunctional Areanvarchar160
56T7PIQSINGLEFEESDefine Attributes for Individual Fees24FKBERFunctional Areanvarchar160
57TCMAC06DDerivation of ISR Scenario Related Data22FKBERFunctional Areanvarchar160
TOPAccounting Interface
58GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)279FKBERFunctional Areanvarchar160
59GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)279FKBERFunctional Areanvarchar160
TOPActual CostingMaterial Ledger
60MLCOMaterial valuation document account assignment information11FKBERFunctional Areanvarchar160
TOPAppropriation Requests
61IMAKAppropriation requests - general data16FKBERFunctional Areanvarchar160
TOPBasic Functions
62ANLPAsset Periodic Values41FKBERFunctional Areanvarchar160
63ANLQPeriod values from dep. posting run per posting level6FKBERFunctional Areanvarchar160
64ANLZTime-Dependent Asset Allocations30FKBERFunctional Areanvarchar160
TOPBilling
65VBRPBilling Document: Item Data211FKBERFunctional Areanvarchar160
TOPClaims Management
66TICL830Entity Table: Operational Area (Possibly Function Area)3FKBERFunctional Areanvarchar160
TOPConditions
67A173CO Area/Ovrhd Type/Fund/Func. Area/GM_GRANT_N7FKBERFunctional Areanvarchar160
68A174CO Area/Ovrhd Type/Func. Area/GM_GRANT_N6FKBERFunctional Areanvarchar160
69A175CO Area/Ovrhd Type/Fund/Func. Area7FKBERFunctional Areanvarchar160
70A177CO Area/Ovrhd Type/Func. Area6FKBERFunctional Areanvarchar160
TOPConstruction Industry
71T5DBVConstruction Pay: Cost Assignment: Hostels39FKBERFunctional Areanvarchar160
72T5DBXConstruction Pay: Incentive Wage Connection39FKBERFunctional Areanvarchar160
TOPContract Accounts Receivable and Payable
73DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations11FKBERFunctional Areanvarchar160
74DFKKFMDYINFOLog Data for Subsequent FM Activation in FI-CA7FKBERFunctional Areanvarchar160
75DFKKOPAADistribution Items with Account Assignment26FKBERFunctional Areanvarchar160
76DFKKOP_REPOpen Items from FPO4160FKBERFunctional Areanvarchar160
77DFKKRP3Returns: Manual Posting Specifications26FKBERFunctional Areanvarchar160
78DFKKSUMPosting totals from FI-CA63FKBERFunctional Areanvarchar160
79DFKKSUMOLDTotals Records Without Account Assignment Changes19FKBERFunctional Areanvarchar160
80TFKFMDY2Account Assignments for Subsequent FM Activation6FKBERFunctional Areanvarchar160
TOPControlling
81COKEY2CO Key Subnumbers Enhancement Table3FKBERFunctional Areanvarchar160
TOPData Retention Tool
82TXW_S_BSEGRetrieve BSEG from archive55FKBERFunctional Areanvarchar160
83TXW_S_COEPRetrieve COEP from archive21FKBERFunctional Areanvarchar160
84TXW_S_MSEGRetrieve MSEG from archive32FKBERFunctional Areanvarchar160
TOPData Transfer
85PPDITTransfer to Accounting: Lines in HR IDOCs47FKBERFunctional Areanvarchar160
86PPDSTTransfer to Accounting: Substituted Acc. Assig. Object32FKBERFunctional Areanvarchar160
87PPKIXTransfer FI/CO: Index of Account Assignment Combinations19FKBERFunctional Areanvarchar160
TOPDemand Management
88T459KControl table for customer requirements38FKBERFunctional Areanvarchar160
TOPElectronic Bank Statement
89FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)20FKBERFunctional Areanvarchar160
90FEB_ACTAcct Assignment Templates20FKBERFunctional Areanvarchar160
TOPExternal Services
91ESKNAccount Assignment in Service Package49FKBERFunctional Areanvarchar160
TOPFinancial Accounting
92/OPT/VIM_1ITEMDocument Item33FKBERFunctional Areanvarchar160
93ACCTITCompressed Data from FI/CO Document137FKBERFunctional Areanvarchar160
94BSADAccounting: Secondary Index for Customers (Cleared Items)163FKBERFunctional Areanvarchar160
95BSAKAccounting: Secondary Index for Vendors (Cleared Items)168FKBERFunctional Areanvarchar160
96BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)64FKBERFunctional Areanvarchar160
97BSIDAccounting: Secondary Index for Customers163FKBERFunctional Areanvarchar160
98BSIKAccounting: Secondary Index for Vendors168FKBERFunctional Areanvarchar160
99BSISAccounting: Secondary Index for G/L Accounts64FKBERFunctional Areanvarchar160
100KMZEIFI: Account Assignment Model Item Information66FKBERFunctional Areanvarchar160
101KOMUAccount Assignment Templates for G/L Account Items66FKBERFunctional Areanvarchar160
102VBSEGADocument Segment for Document Parking - Asset Database61FKBERFunctional Areanvarchar160
103VBSEGDDocument Segment for Customer Document Parking116FKBERFunctional Areanvarchar160
104VBSEGKDocument Segment for Vendor Document Parking127FKBERFunctional Areanvarchar160
105VBSEGSDocument Segment for Document Parking - G/L Account Database105FKBERFunctional Areanvarchar160
TOPFreight Processing
106VFKNAccount Determination in Shipment Costs Item36FKBERFunctional Areanvarchar160
TOPFunds Management
107KBLPDocument Item: Manual Document Entry88FKBERFunctional Areanvarchar160
TOPFunds Management-Specific Postings
108FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years104FKBERFunctional Areanvarchar160
109PAYAC01Account determination10FKBERFunctional Areanvarchar160
110PSOSEGSRecurring Request Document Segment, G/L Accounts104FKBERFunctional Areanvarchar160
TOPGeneral Ledger Accounting
111BSEG_ADDEntry View of Accounting Document for Additional Ledgers71FKBERFunctional Areanvarchar160
112FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)64FKBERFunctional Areanvarchar160
113FAGLBSISAccounting: Secondary Index for G/L Accounts64FKBERFunctional Areanvarchar160
114FAGL_SPLINFOSplittling Information of Open Items55FKBERFunctional Areanvarchar160
TOPGL Account Posting
115TCJ_POSITIONSCash Journal Document Items27FKBERFunctional Areanvarchar160
TOPInventory Management
116MSEGDocument Segment: Material157FKBERFunctional Areanvarchar160
117MWXMSEGZMSEG: Interface for Posting of Value157FKBERFunctional Areanvarchar160
118MWZMSEGZMSEG:Interface for Posting of Value157FKBERFunctional Areanvarchar160
119RESBReservation/dependent requirements183FKBERFunctional Areanvarchar160
120RKPFDocument Header: Reservation49FKBERFunctional Areanvarchar160
TOPInvoice Verification
121RBCODocument Item, Incoming Invoice, Account Assignment14FKBERFunctional Areanvarchar160
TOPLocalization
122IDCN_MAP_EASDetail Expense Accounts (Golden Audit)4FKBERFunctional Areanvarchar160
TOPMaterials Management
123/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions123FKBERFunctional Areanvarchar160
TOPOverhead Cost Controlling
124COEJCO Object: Line Items (by Fiscal Year)190FKBERFunctional Areanvarchar160
125COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)50FKBERFunctional Areanvarchar160
126COEPCO Object: Line Items (by Period)57FKBERFunctional Areanvarchar160
127COEPRCO Object: Line Items for Stat. Key Figs (by Period)22FKBERFunctional Areanvarchar160
128COSPCO Object: Cost Totals for External Postings147FKBERFunctional Areanvarchar160
129COSRCO Object: Statistical Key Figure Totals44FKBERFunctional Areanvarchar160
130COSSCO Object: Cost Totals for Internal Postings163FKBERFunctional Areanvarchar160
131COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis59FKBERFunctional Areanvarchar160
132TFKBFunctional areas2FKBERFunctional Areanvarchar160
133TFKBTName of the functional areas3FKBERFunctional Areanvarchar160
TOPOverhead Cost Orders
134TKZU3Overhead Credit10FKBERFunctional Areanvarchar160
TOPPayment Transactions
135CRACCPayment Cards: Account Assignments in Card Master Record26FKBERFunctional Areanvarchar160
136CRNUMPayment cards: Card master record47FKBERFunctional Areanvarchar160
137FPRL_ITEMItem Data80FKBERFunctional Areanvarchar160
TOPPayroll
138T5TPSC1SPLITRozdelení nákladu50FKBERFunkcní oblastnvarchar160
TOPPayroll General Parts
139HRPY_WPBPHR-PAY: Transparent Table WPBP36FKBERFunctional Areanvarchar160
TOPPersonnel Administration
140PA0001HR Master Record: Infotype 0001 (Org. Assignment)49FKBERFunctional Areanvarchar160
TOPPersonnel Time Events
141TPTCOR_KOSTLCost Assignment (Correction Scenario)18FKBERFunctional Areanvarchar160
TOPPersonnel Time Management
142ASSOBAssignment Objects38FKBERFunctional Areanvarchar160
143CC1ERPIncorrect Time Events from CC1, Postings117FKBERFunctional Areanvarchar160
144COIFTInterface to Activity Allocation70FKBERFunctional Areanvarchar160
145PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)72FKBERFunctional Areanvarchar160
146PTEX2003GENInterface Table for IT 2003: General Information71FKBERFunctional Areanvarchar160
147PTEX2003SPECInterface Table for IT 2003: Interval Information47FKBERFunctional Areanvarchar160
148PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)71FKBERFunctional Areanvarchar160
149TEVEN_MOREAdditional Data for Time Events116FKBERFunctional Areanvarchar160
TOPPosition Budgeting and Control
150HRFPM_DIFFERENCEHRFPM: Personnel Costs Savings/ Overrun39FKBERFunctional Areanvarchar160
151HRFPM_FM_POSHRFPM: FM Documents - Items23FKBERFunctional Areanvarchar160
152HRFPM_FM_POS_BUHRFPM: FM Documents - Items for Budget24FKBERFunctional Areanvarchar160
153HRFPM_FPM_POSHRFPM: FPM Documents - Items37FKBERFunctional Areanvarchar160
154HRFPM_FPM_POS_BUHRFPM: FPM Documents - Items for Budget38FKBERFunctional Areanvarchar160
155HRFPM_OBJECTSHRFPM: Object table of the commitment engine33FKBERFunctional Areanvarchar160
TOPProfitability Analysis
156CECOEJCO-PA Account Based Line Items192FKBERFunctional Areanvarchar160
157CECOEPCO-PA Account Based Line Items59FKBERFunctional Areanvarchar160
TOPPurchasing
158EBANPurchase Requisition114FKBERFunctional Areanvarchar160
159EBKNPurchase Requisition Account Assignment51FKBERFunctional Areanvarchar160
160EKCPAPurchasing Contract Commitment Plan Account Assignment Data11FKBERFunctional Areanvarchar160
161EKKNAccount Assignment in Purchasing Document54FKBERFunctional Areanvarchar160
162EKPOPurchasing Document Item204FKBERFunctional Areanvarchar160
163MEREQXPurchase Requisition Change Parameter114FKBERUpdated information in related user data fieldnvarchar10
TOPRecruitment
164PB0001HR Master Record: Infotype 0001 (Org. Assignment)49FKBERFunctional Areanvarchar160
TOPRemaining Beverage - Obsolete Objects
165/BEV3/CH1030BSG2Document Segment CH Event Ledger Part224FKBERFunctional Areanvarchar160
TOPRepetitive Manufacturing
166COMPMOVEGoods Movement of Components128FKBERFunctional Areanvarchar160
TOPSales
167VBAPSales Document: Item Data249FKBERFunctional Areanvarchar160
168VBKDSales Document: Business Data76FKBERFunctional Areanvarchar160
TOPSelf-Service Procurement
169/SRMERP/D_ACC_ITAccount assignment item37FKBERFunctional Areanvarchar160
TOPShipping
170LIPSSD document: Delivery: Item data246FKBERFunctional Areanvarchar160
TOPSimulation
171VSEBAN_CNVersion: Purchase requisition115FKBERFunctional Areanvarchar160
172VSEBKN_CNVersion: Purchase requisition account assignment40FKBERFunctional Areanvarchar160
173VSRESB_CNVersion: Reservation/Dependent requirements190FKBERFunctional Areanvarchar160
174VSVBKD_CNVersion: Sales document - commercial data77FKBERFunctional Areanvarchar160
TOPStaffing
175HRT1018Table Division Infotype 1018 Cost Distribution13FKBERFunctional Areanvarchar160
TOPThird Party Remittance
176T51R6_FUNDINFORemittance detail table for all entities24FKBERFunctional Areanvarchar160
TOPTraining and Event Management
177T77REFDOCReference Document Table: Training and Event Management62FKBERFunctional Areanvarchar160
TOPTransfer to Financial Accounting
178TRACC_ADDACCDATAAdditional Acct Assignments Dependent on Acct Assignm. Ref.6FKBERFunctional Areanvarchar160
179TRACT_POSCONTEXTTreasury: Position Context Table10FKBERFunctional Areanvarchar160
TOPTravel Expenses
180PA0017HR master record: Infotype 0017 (Travel Privileges)42FKBERFunctional Areanvarchar160
181PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document40FKBERFunctional Areanvarchar160
TOPTravel Planning
182FTPT_REQ_ACCOUNTTravel Request Cost Assignment42FKBERFunctional Areanvarchar160