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

116 columns | Print definition?ERP 6.0  | LSTAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item22LSTARActivity Typenvarchar60
2/OPT/VIM_TITEMDocument Item22LSTARActivity Typenvarchar60
3BSEGAccounting Document Segment296LSTARActivity Typenvarchar60
4BSSEGAccounting Document Segment285LSTARActivity Typenvarchar60
5CNV_40305_ANKA_BBackup of ANKA from prior to the conversion12LSTARActivity Typenvarchar60
6COD_MAT_ACTTYMapping Material to Activity Type3LSTARActivity Typenvarchar60
7FUDT_VDOCBSEGVerification Document Item with Additional Info285LSTARActivity Typenvarchar60
8FUDT_VDOCBSEGEVVerification Document Item in the Entry View285LSTARActivity Typenvarchar60
9FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)285LSTARActivity Typenvarchar60
10GLPCA_CTProfit Center Documents87LSTARActivity Typenvarchar60
11GLPCA_T_CTProfit Center Documents103LSTARActivity Typenvarchar60
12GLPOS_C_CTFI Document: Entry View166LSTARActivity Typenvarchar60
13GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items166LSTARActivity Typenvarchar60
14GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items166LSTARActivity Typenvarchar60
15GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items166LSTARActivity Typenvarchar60
16GLPOS_N_CTNew General Ledger: Line Item with Currency Type169LSTARActivity Typenvarchar60
17GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type169LSTARActivity Typenvarchar60
18P2B2_C1HCM Declustering B2 - Cost Distribution Table C131LSTARActivity Typenvarchar60
19P2PL_RETROADJPayroll Result PL: Retro, originals and changes41LSTARActivity Typenvarchar60
20P2PL_RETRODIFPayroll Result PL: Retro, originals and changes41LSTARActivity Typenvarchar60
21P2PL_RETROMEMPayroll Result PL: Retro, originals and changes41LSTARActivity Typenvarchar60
22P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)48LSTARActivity Typenvarchar60
23P2RT_CZDAVP18_0332LSTARActivity Typenvarchar60
24P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)48LSTARActivity Typenvarchar60
25P2RX_C1Cost Distribution Table C129LSTARActivity Typenvarchar60
26YVIM_1ITEMDocument Item22LSTARActivity Typenvarchar60
27ZCATSDBRecords changed with processing status '10'6LSTARnvarchar60
28ZCATSDB2Records changed with processing status '10'7LSTARnvarchar60
29ZPPMC_CPL_T_CACHCache for Delta Posting12LSTARActivity Typenvarchar60
TOPAccounting Interface
30GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)141LSTARActivity Typenvarchar60
31GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)141LSTARActivity Typenvarchar60
TOPActivity-Based Costing
32HRP1209Infotype 1209 DB Table18LSTARActivity Typenvarchar60
TOPActual CostingMaterial Ledger
33FCML_MATML Characteristics for Material (Selection Criteria)20LSTARActivity Typenvarchar60
34MLCOMaterial valuation document account assignment information33LSTARActivity Typenvarchar60
TOPActual Revenues and Forecast
35TEBCOCO/SD Interface: Product Number Determination from CO6LSTARCO/SD key conversion: activity typenvarchar60
TOPAlternative Valuation Run
36CKMLAVRDOCITLines for Cumulation Posting Document44LSTARActivity Typenvarchar60
TOPAttendancesAbsences
37CATSHRCross-Application Time Sheet (CATS): Transfer to HR25LSTARActivity Typenvarchar60
38PA0315CATS: Sender Information25LSTARActivity Typenvarchar60
TOPBasic Functions
39ANGAAsset catalog general data18LSTARActivity Typenvarchar60
40ANKAAsset classes: general data19LSTARActivity Typenvarchar60
41ANLPAsset Periodic Values43LSTARActivity Typenvarchar60
42ANLQPeriod values from dep. posting run per posting level10LSTARActivity Typenvarchar60
43ANLZTime-Dependent Asset Allocations10LSTARActivity Typenvarchar60
TOPCapital Investments
44ANIADepr. simulation for invest. projects14LSTARActivity Typenvarchar60
TOPConfirmations
45AFRVConfirmation pool39LSTARActivity Typenvarchar60
46AFRV_DELBackup Copy for Confirmation Pool39LSTARActivity Typenvarchar60
TOPConstruction Industry
47T5DBVConstruction Pay: Cost Assignment: Hostels28LSTARActivity Typenvarchar60
48T5DBXConstruction Pay: Incentive Wage Connection28LSTARActivity Typenvarchar60
TOPControlling
49CRMCO_CONF_COSTSCRM/CO: Actual Costs for Confirmations8LSTARActivity Typenvarchar60
50CRMC_TOOL_COCRM Service: Cost Center / Activity Type for Tool7LSTARActivity Typenvarchar60
51CSLAActivity master3LSTARActivity Typenvarchar60
52CSLTActivity type texts4LSTARActivity Typenvarchar60
TOPCross-Application Components
53ONRKLObject Number Index, Cost Center/Activity Type5LSTARActivity Typenvarchar60
TOPCross-Application Objects in HR
54HRP5587DB Table for Infotype 558719LSTARActivity Typenvarchar60
TOPData Collection
55CF003Projects39LSTARList type keynvarchar30
56S027Product Costs11LSTARActivity Typenvarchar60
57S027ES027 - Structural Information6LSTARActivity Typenvarchar60
58S227Product costs: repetitive manufacturing11LSTARActivity Typenvarchar60
59S227ES227 - Structural Information6LSTARActivity Typenvarchar60
TOPElectronic Bank Statement
60FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)23LSTARActivity Typenvarchar60
61FEB_ACTAcct Assignment Templates23LSTARActivity Typenvarchar60
TOPESS Based on WD ABAP
62HRESS_D_CATS_FAVCATS Favorites: database table13LSTARActivity Typenvarchar60
TOPExpense-Related Billing
63PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines11LSTARActivity Typenvarchar60
TOPExternal Services
64ESKNAccount Assignment in Service Package56LSTARActivity Typenvarchar60
TOPFinancial Accounting
65/OPT/VIM_1ITEMDocument Item22LSTARActivity Typenvarchar60
66ACCTITCompressed Data from FI/CO Document145LSTARActivity Typenvarchar60
67VBSEGADocument Segment for Document Parking - Asset Database62LSTARActivity Typenvarchar60
68VBSEGSDocument Segment for Document Parking - G/L Account Database119LSTARActivity Typenvarchar60
TOPFreight Processing
69VFKNAccount Determination in Shipment Costs Item40LSTARActivity Typenvarchar60
TOPGeneral Ledger Accounting
70BSEG_ADDEntry View of Accounting Document for Additional Ledgers68LSTARActivity Typenvarchar60
TOPGL Account Posting
71TCJ_POSITIONSCash Journal Document Items30LSTARActivity Typenvarchar60
TOPInformation System
72MCKALKVVersions: Cost Itemization9LSTARActivity Typenvarchar60
73MCKALKWVersions: Cost Itemization6LSTARActivity Typenvarchar60
74MCSFISR/2 SFIS Data: Old10LSTARActivity Typenvarchar60
TOPInventory Management
75MSEGDocument Segment: Material182LSTARActivity Typenvarchar60
76RKPFDocument Header: Reservation54LSTARActivity Typenvarchar60
TOPInvoice Verification
77RBCODocument Item, Incoming Invoice, Account Assignment49LSTARActivity Typenvarchar60
TOPJoint Venture und Production Sharing Accounting
78JVPO1JVA: Plan Line Items131LSTARActivity Typenvarchar60
79JVSO1JV LI Table with Objects for JVTO167LSTARActivity Typenvarchar60
TOPMaintenance Notifications
80QMFEQuality notification - items53LSTARActivity Typenvarchar60
TOPOverhead Cost Controlling
81CSSLCost Center/Activity Type4LSTARActivity Typenvarchar60
TOPPatient Accounting
82NLCOIS-HCO: Transfer information7LSTARIS-HCO: Activity Typenvarchar60
TOPPayroll
83T5TPSC1SPLITRozdelení nákladu39LSTARDruh výkonunvarchar60
TOPPersonnel Administration
84T703EIncentive Wages: Convert Activity Types to Result Types4LSTARCumulation rule for activity typenvarchar60
TOPPersonnel Time Management
85ASSOBAssignment Objects27LSTARActivity Typenvarchar60
86COIFTInterface to Activity Allocation59LSTARActivity Typenvarchar60
87PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)68LSTARActivity Typenvarchar60
88PTEX2003GENInterface Table for IT 2003: General Information67LSTARActivity Typenvarchar60
89PTEX2003SPECInterface Table for IT 2003: Interval Information43LSTARActivity Typenvarchar60
90PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)67LSTARActivity Typenvarchar60
TOPPlant Data Collection
91RUECKTemp. storage for subsystem confirmations34LSTARActivity Typenvarchar60
TOPProduct Cost Planning
92CKISItems Unit Costing/Itemization Product Costing65LSTARActivity Typenvarchar60
TOPProfit Center Accounting
93GLPCAEC-PCA: Actual Line Items53LSTARActivity Typenvarchar60
94GLPCPEC-PCA: Plan Line Items115LSTARActivity Typenvarchar60
TOPPurchasing
95EBKNPurchase Requisition Account Assignment58LSTARActivity Typenvarchar60
96EKKNAccount Assignment in Purchasing Document63LSTARActivity Typenvarchar60
TOPRepetitive Manufacturing
97COMPMOVEGoods Movement of Components129LSTARActivity Typenvarchar60
TOPRevenues and Earnings
98AD01DLIDynamic items (DI)10LSTARActivity Typenvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
99NLDIS_004DIS - Kostpreis3LSTARPrestatiesoortnvarchar60
100NLDIS_005DIS - Kostpreis4LSTARLeistungsartnvarchar60
101NLHCO_KOSTENARTNL-HCO: Kostenarten5LSTARPrestatiesoortnvarchar60
102NLHCO_LEISTARTNL-HCO: Leistungsarten5LSTARPrestatiesoortnvarchar60
103NLHCO_TARIFIS-H NL: Plan auftrag tarif uber NL splittungs profile5LSTARPrestatiesoortnvarchar60
104NWCHLCOEAIS-HCO: Überleitungsinformationen8LSTARIS-HCO: tipo di prestazionenvarchar60
TOPSelf-Service Procurement
105/SRMERP/D_ACC_ITAccount assignment item43LSTARActivity Typenvarchar60
TOPSimulation
106VSEBKN_CNVersion: Purchase requisition account assignment59LSTARActivity Typenvarchar60
TOPStructures
107PSSKF_DEFAU_TABDefault SKF for the the Project Parameters8LSTARActivity Typenvarchar60
TOPTime Sheet
108CATSCOCross-Application Time Sheet (CATS): Transfer to CO8LSTARActivity Typenvarchar60
109CATSDBCATS: Database Table for Time Sheet6LSTARActivity Typenvarchar60
110CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS17LSTARActivity Typenvarchar60
111CATSPSCross-Application Time Sheet (CATS): Transfer to PS17LSTARActivity Typenvarchar60
112CATS_TEMPCATS: Database Table for Templates8LSTARActivity Typenvarchar60
113TCATX_DEDUCCATX: Data Derived from Type/Component/Level8LSTARActivity Typenvarchar60
TOPTraining and Event Management
114HRP1037Infotype 1037 DB Table21LSTARActivity Type for Business Eventsnvarchar60
TOPTravel Planning
115FTPT_REQ_ACCOUNTTravel Request Cost Assignment31LSTARActivity Typenvarchar60
TOPWork Center
116CRCOAssignment of Work Center to Cost Center12LSTARActivity Typenvarchar60