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

146 columns | Print definition?ERP 6.0  | FIPOS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/FORDOCSPLITDocument Header and Line details for Splitting5FIPOSCommitment Itemnvarchar140
2/OPT/VIM_1ITEM_SDocument Item32FIPOSCommitment Itemnvarchar140
3/OPT/VIM_TITEMDocument Item32FIPOSCommitment Itemnvarchar140
4BSAD_BAKAccounting: Secondary index for customers (cleared items)96FIPOSCommitment Itemnvarchar140
5BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)100FIPOSCommitment Itemnvarchar140
6BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)65FIPOSCommitment Itemnvarchar140
7BSEGAccounting Document Segment221FIPOSCommitment Itemnvarchar140
8BSID_BAKAccounting: Secondary Index for Customers96FIPOSCommitment Itemnvarchar140
9BSIK_BAKAccounting: Secondary index for vendors100FIPOSCommitment Itemnvarchar140
10BSIS_BAKAccounting: Secondary Index for G/L Accounts65FIPOSCommitment Itemnvarchar140
11BSSEGAccounting Document Segment210FIPOSCommitment Itemnvarchar140
12CNV_20100_SKB1CNV backup copy for SKB136FIPOSCommitment Itemnvarchar140
13FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)65FIPOSCommitment Itemnvarchar140
14FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts65FIPOSCommitment Itemnvarchar140
15FIAPSAD_ADPSFSettelement Details for KSA11FIPOSCommitment Itemnvarchar140
16FIAPSAD_ORDR_LTLine Item for Order Number KSA22FIPOSCommitment Itemnvarchar140
17FMADB_DEFAULT_AAFMADB: Default Account Assignment for Petty Amounts4FIPOSCommitment Itemnvarchar140
18FUDT_VDOCBSEGVerification Document Item with Additional Info210FIPOSCommitment Itemnvarchar140
19FUDT_VDOCBSEGEVVerification Document Item in the Entry View210FIPOSCommitment Itemnvarchar140
20FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)210FIPOSCommitment Itemnvarchar140
21GLPOS_C_CTFI Document: Entry View114FIPOSCommitment Itemnvarchar140
22GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items114FIPOSCommitment Itemnvarchar140
23GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items114FIPOSCommitment Itemnvarchar140
24GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items114FIPOSCommitment Itemnvarchar140
25GLPOS_N_CTNew General Ledger: Line Item with Currency Type116FIPOSCommitment Itemnvarchar140
26GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type116FIPOSCommitment Itemnvarchar140
27P2B2_C1HCM Declustering B2 - Cost Distribution Table C122FIPOSCommitment Itemnvarchar140
28P2B2_CWSTHCM Declustering B2 - PDC Time Tickets129FIPOSCommitment Itemnvarchar140
29P2B2_WSTHCM Declustering B2 - PDC Time Tickets129FIPOSCommitment Itemnvarchar140
30P2PL_RETROADJPayroll Result PL: Retro, originals and changes32FIPOSCommitment Itemnvarchar140
31P2PL_RETRODIFPayroll Result PL: Retro, originals and changes32FIPOSCommitment Itemnvarchar140
32P2PL_RETROMEMPayroll Result PL: Retro, originals and changes32FIPOSCommitment Itemnvarchar140
33P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)39FIPOSCommitment Itemnvarchar140
34P2RT_CZDAVP18_0323FIPOSCommitment Itemnvarchar140
35P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)39FIPOSCommitment Itemnvarchar140
36P2RX_C1Cost Distribution Table C120FIPOSCommitment Itemnvarchar140
37REGUPProcessed items from payment program97FIPOSCommitment Itemnvarchar140
38YVIM_1ITEMDocument Item32FIPOSCommitment Itemnvarchar140
39ZEIM_LIPSSD document: Delivery: Item data117FIPOSCommitment Itemnvarchar140
40ZSAFIZuordnung Sako-Fipo5FIPOSFinanzpositionnvarchar140
TOPAccounting Interface
41GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)181FIPOSCommitment Itemnvarchar140
42GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)181FIPOSCommitment Itemnvarchar140
TOPActual CostingMaterial Ledger
43MLCOMaterial valuation document account assignment information10FIPOSCommitment Itemnvarchar140
TOPBasic Functions
44SKB1G/L account master (company code)35FIPOSCommitment Itemnvarchar140
45SKM1Sample G/L accounts33FIPOSCommitment Itemnvarchar140
TOPConfirmations
46AFRVConfirmation pool30FIPOSCommitment Itemnvarchar140
47AFRV_DELBackup Copy for Confirmation Pool30FIPOSCommitment Itemnvarchar140
TOPConstruction Industry
48T5DBVConstruction Pay: Cost Assignment: Hostels19FIPOSCommitment Itemnvarchar140
49T5DBXConstruction Pay: Incentive Wage Connection19FIPOSCommitment Itemnvarchar140
TOPCross-Application Components
50BBSIDAccounting: Secondary index for customers96FIPOSCommitment Itemnvarchar140
TOPData Transfer
51PPDITTransfer to Accounting: Lines in HR IDOCs26FIPOSCommitment Itemnvarchar140
52PPDSTTransfer to Accounting: Substituted Acc. Assig. Object15FIPOSCommitment Itemnvarchar140
TOPDefense Forces and Public Security
53/ISDFPS/ZEBANCopy of EBAN85FIPOSCommitment Itemnvarchar140
TOPElectronic Bank Statement
54FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)57FIPOSCommitment Itemnvarchar140
55FEB_ACTAcct Assignment Templates57FIPOSCommitment Itemnvarchar140
TOPExpense-Related Billing
56PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines14FIPOSCommitment Itemnvarchar140
TOPExternal Services
57ESKNAccount Assignment in Service Package33FIPOSCommitment Itemnvarchar140
TOPFinancial Accounting
58/OPT/VIM_1ITEMDocument Item32FIPOSCommitment Itemnvarchar140
59ACCTITCompressed Data from FI/CO Document102FIPOSCommitment Itemnvarchar140
60BSADAccounting: Secondary Index for Customers (Cleared Items)96FIPOSCommitment Itemnvarchar140
61BSAKAccounting: Secondary Index for Vendors (Cleared Items)100FIPOSCommitment Itemnvarchar140
62BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)65FIPOSCommitment Itemnvarchar140
63BSIDAccounting: Secondary Index for Customers96FIPOSCommitment Itemnvarchar140
64BSIKAccounting: Secondary Index for Vendors100FIPOSCommitment Itemnvarchar140
65BSISAccounting: Secondary Index for G/L Accounts65FIPOSCommitment Itemnvarchar140
66KMZEIFI: Account Assignment Model Item Information54FIPOSCommitment Itemnvarchar140
67KOMUAccount Assignment Templates for G/L Account Items54FIPOSCommitment Itemnvarchar140
68VBSEGADocument Segment for Document Parking - Asset Database35FIPOSCommitment Itemnvarchar140
69VBSEGDDocument Segment for Customer Document Parking86FIPOSCommitment Itemnvarchar140
70VBSEGKDocument Segment for Vendor Document Parking100FIPOSCommitment Itemnvarchar140
71VBSEGSDocument Segment for Document Parking - G/L Account Database85FIPOSCommitment Itemnvarchar140
TOPFreight Processing
72VFKNAccount Determination in Shipment Costs Item32FIPOSCommitment Itemnvarchar140
TOPFund Accounting
73FMPPFUNDItems for Partial Payment by Fund Process10FIPOSCommitment Itemnvarchar140
TOPFunds Management
74FM01SAdditional master data for budgeting tools4FIPOSCommitment Itemnvarchar140
75FMAVCis being deleted3FIPOSCommitment Itemnvarchar140
76FMCFSIFFI-FM: Selected Open Documents from FI Update26FIPOSCommitment Itemnvarchar140
77FMCFSIOFI-FM: Selected Open Commitment Documents29FIPOSCommitment Itemnvarchar140
78FMCFSIO_TRFI-FM: Selected Open Commitment Documents29FIPOSCommitment Itemnvarchar140
79FMCICommitment items master data34FIPOSCommitment Itemnvarchar140
80FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values13FIPOSCommitment Itemnvarchar140
81FMDECK3Cover eligibility: amount management for sender budget obj.5FIPOSCommitment Itemnvarchar140
82FMFPOFIFM: Commitment Item3FIPOSCommitment Itemnvarchar140
83FMFPOTTexts for a Financia Management Item4FIPOSCommitment Itemnvarchar140
84FMFXPOCommitment item, internal and external number (conversion)2FIPOSCommitment itemnvarchar140
85FMICOITFM/CO integration: Line item9FIPOSCommitment Itemnvarchar140
86FMPPCommitment Item in Chart of Commitment Items10FIPOSCommitment Itemnvarchar140
87FMRC_BSEGReconciliation of Lines from FI8FIPOSCommitment Itemnvarchar140
88FMVORTRCmmt items for carryover item category of totals records5FIPOSCommitment Itemnvarchar140
89FMWF_BDGRPFM Account Groups for FM Role Definition5FIPOSCommitment Itemnvarchar140
90FMZUCHChange information on allocation of CO Object to FM Object10FIPOSCommitment Itemnvarchar140
91FMZUGRAllocation of CO Group to FM Account Assignment10FIPOSCommitment Itemnvarchar140
92FMZUKAAllocation of Cost Element to FM Account Assignment7FIPOSCommitment Itemnvarchar140
93FMZUOBAllocation of CO Object to FM Account Assignment8FIPOSCommitment Itemnvarchar140
94KBLPDocument Item: Manual Document Entry22FIPOSCommitment itemnvarchar140
95TBPFMFM Active Availability Control4FIPOSCommitment Itemnvarchar140
96TBPW1is being deleted5FIPOSCommitment Itemnvarchar140
TOPFunds Management-Specific Postings
97FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years84FIPOSCommitment Itemnvarchar140
98FMPSO_ACQU_TAXTable of Commitment Items that Represent Acquisition Taxes2FIPOSCommitment Itemnvarchar240
99PSOSEGADocument Segment for Assets Document Parking36FIPOSCommitment Itemnvarchar140
100PSOSEGDDocument Segment: Recurring Request, Customer87FIPOSCommitment Itemnvarchar140
101PSOSEGKRecurring Request Document Segment, Vendors101FIPOSCommitment Itemnvarchar140
102PSOSEGSRecurring Request Document Segment, G/L Accounts83FIPOSCommitment Itemnvarchar140
TOPGeneral Ledger Accounting
103BSEG_ADDEntry View of Accounting Document for Additional Ledgers43FIPOSCommitment Itemnvarchar140
104FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)65FIPOSCommitment Itemnvarchar140
105FAGLBSISAccounting: Secondary Index for G/L Accounts65FIPOSCommitment Itemnvarchar140
106FAGL_SPLINFOSplittling Information of Open Items29FIPOSCommitment Itemnvarchar140
TOPGL Account Posting
107TCJ_POSITIONSCash Journal Document Items64FIPOSCommitment Itemnvarchar140
TOPInventory Management
108MSEGDocument Segment: Material119FIPOSCommitment Itemnvarchar140
109MWXMSEGZMSEG: Interface for Posting of Value119FIPOSCommitment Itemnvarchar140
110MWZMSEGZMSEG:Interface for Posting of Value119FIPOSCommitment Itemnvarchar140
111RESBReservation/dependent requirements178FIPOSCommitment Itemnvarchar140
112RKPFDocument Header: Reservation35FIPOSCommitment Itemnvarchar140
TOPInvoice Verification
113RBCODocument Item, Incoming Invoice, Account Assignment12FIPOSCommitment Itemnvarchar140
TOPLocal Currency Changeover
114EWUFI_SCAEMU conversion: Table of the clearings to be adjusted24FIPOSCommitment Itemnvarchar140
TOPMaterials Management
115/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions90FIPOSCommitment Itemnvarchar140
TOPPayment Transactions
116CRACCPayment Cards: Account Assignments in Card Master Record23FIPOSCommitment itemnvarchar140
117CRNUMPayment cards: Card master record44FIPOSCommitment itemnvarchar140
TOPPayroll
118T5TPSC1SPLITRozdelení nákladu30FIPOSRozpoctová položkanvarchar140
TOPPersonnel Time Events
119TPTCOR_KOSTLCost Assignment (Correction Scenario)20FIPOSCommitment Itemnvarchar140
TOPPersonnel Time Management
120ASSOBAssignment Objects18FIPOSCommitment Itemnvarchar140
121CC1ERPIncorrect Time Events from CC1, Postings119FIPOSCommitment Itemnvarchar140
122COIFTInterface to Activity Allocation50FIPOSCommitment Itemnvarchar140
123PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)59FIPOSCommitment Itemnvarchar140
124PTEX2003GENInterface Table for IT 2003: General Information58FIPOSCommitment Itemnvarchar140
125PTEX2003SPECInterface Table for IT 2003: Interval Information34FIPOSCommitment Itemnvarchar140
126PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)58FIPOSCommitment Itemnvarchar140
127TEVEN_MOREAdditional Data for Time Events118FIPOSCommitment Itemnvarchar140
TOPPlant Data Collection
128RUECKTemp. storage for subsystem confirmations25FIPOSCommitment Itemnvarchar140
TOPPurchasing
129EBANPurchase Requisition85FIPOSCommitment Itemnvarchar140
130EBKNPurchase Requisition Account Assignment35FIPOSCommitment Itemnvarchar140
131EKCPAPurchasing Contract Commitment Plan Account Assignment Data9FIPOSCommitment Itemnvarchar140
132EKKNAccount Assignment in Purchasing Document38FIPOSCommitment Itemnvarchar140
133EKPOPurchasing Document Item99FIPOSCommitment Itemnvarchar140
134MEREQXPurchase Requisition Change Parameter85FIPOSUpdated information in related user data fieldnvarchar10
TOPRemaining Beverage - Obsolete Objects
135/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1212FIPOSCommitment Itemnvarchar140
TOPRepetitive Manufacturing
136COMPMOVEGoods Movement of Components121FIPOSCommitment Itemnvarchar140
TOPRevenues and Earnings
137AD01DLIDynamic items (DI)13FIPOSCommitment Itemnvarchar140
TOPSelf-Service Procurement
138/SRMERP/D_ACC_ITAccount assignment item32FIPOSCommitment Itemnvarchar140
TOPShipping
139LIPSSD document: Delivery: Item data117FIPOSCommitment Itemnvarchar140
TOPSimulation
140VSEBAN_CNVersion: Purchase requisition85FIPOSCommitment Itemnvarchar140
141VSEBKN_CNVersion: Purchase requisition account assignment36FIPOSCommitment Itemnvarchar140
142VSRESB_CNVersion: Reservation/Dependent requirements182FIPOSCommitment Itemnvarchar140
TOPTechnical Application Support
143CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted21FIPOSCommitment Itemnvarchar140
TOPTravel Expenses
144PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document25FIPOSCommitment Itemnvarchar140
TOPTravel Planning
145FTPT_REQ_ACCOUNTTravel Request Cost Assignment22FIPOSCommitment Itemnvarchar140
TOPTreasury
146FLQLPOS_FIPOSRelationship: Liquidity Items - Commitment Items4FIPOSLiquidity Calculation: Short Commitment Itemnvarchar100