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
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

63 columns | Print definition?ERP 6.0  | STOKZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents122STOKZIndicator: Document Has Been Reversednvarchar10
2GLPCA_T_CTProfit Center Documents138STOKZIndicator: Document Has Been Reversednvarchar10
3N1SE_DOMAINISHMED: Table for Search Domain10STOKZIS-H: Cancellation Indicatornvarchar10
4N1SE_INDEXISHMED: Table for Search Indexes17STOKZIS-H: Cancellation Indicatornvarchar10
5N1SE_INDEX_ATTRISHMED: Search Index Attributes18STOKZIS-H: Cancellation Indicatornvarchar10
TOPAttendancesAbsences
6CATSHRCross-Application Time Sheet (CATS): Transfer to HR3STOKZIndicator: Document Has Been Reversednvarchar10
TOPClinical System
7N1CYSRVTPLCORD: Cyclical Service Template26STOKZIS-H: Cancellation Indicatornvarchar10
8N1SRVServices: Service Data33STOKZIS-H: Cancellation Indicatornvarchar10
9N1SRVPROPNursing Services: Service Properties14STOKZIS-H: Cancellation Indicatornvarchar10
10N1SRVTEAMServices: Employee for Service11STOKZIS-H: Cancellation Indicatornvarchar10
11N2DGAILEMISH*MED : Kontrolltabelle Überleitung med. Leist -> DGAI10STOKZKDS-Stornierungskennzeichen (interne Nutzung)nvarchar10
TOPCollectionsDisbursements
12VKKINTERESTHISTInt. Calc. History for Deposit Acct9STOKZLine Item in Interest History Reversednvarchar10
TOPConfirmations
13AFRUOrder Confirmations95STOKZIndicator: Document Has Been Reversednvarchar10
TOPContract Accounts Receivable and Payable
14DFKKIHFI-CA: Table with Interest History11STOKZLine Item in Interest History Reversednvarchar10
TOPControlling
15COBK_INDXIndex in COBK for ORGVG10STOKZIndicator: Document Has Been Reversednvarchar10
16COK41C_IDIdentification Table for Posting Runs9STOKZPosting Run was Reversednvarchar10
17COK41C_IXIndex Table for Documents in a Posting Run5STOKZIndicator: Document Has Been Reversednvarchar10
18COPPP_HDRCO Postprocessing List - Headers17STOKZIndicator: Document Has Been Reversednvarchar10
TOPCost Element Accounting
19COFISActual line items for reconciliation ledger60STOKZIndicator: Document Has Been Reversednvarchar10
TOPCost Object
20FCO_DOC_HEADFailure Cost Document Header46STOKZIndicator: Document Has Been Reversednvarchar10
21PZPELine Items for Measuring Point Update21STOKZIndicator: Document Has Been Reversednvarchar10
TOPExternal Services
22ESLLLines of Service Package82STOKZIndicator: Document Has Been Reversednvarchar10
TOPFunds Management
23KBLEDocument Item Processing: Manual Document Entry15STOKZIndicator: Document Has Been Reversednvarchar10
TOPInput Tax Treatment
24VIBEBASEBerichtigungsbasis17STOKZBerichtigungsbasissatz wurde storniert (nur manuelle)nvarchar10
25VIBEITEMGebuchte Berichtigungen35STOKZKennzeichen 'Beleg wurde storniert'nvarchar10
TOPInterest
26TZIN1Document Header Data from Source Document (PS Int.Calc.)13STOKZIndicator: Document Has Been Reversednvarchar10
TOPInvoicing
27ERDKPrint Document/Header Data9STOKZDocument Has Been Reversednvarchar10
28ERDK_SHORTHeader Data for Print Document - Extract9STOKZDocument Has Been Reversednvarchar10
TOPNursing
29N1NRSPENursing Plan: Entry27STOKZIS-H: Cancellation Indicatornvarchar10
30N1NRSPEENursing Plan: Entry Evaluation19STOKZIS-H: Cancellation Indicatornvarchar10
31N1NRSPEPNursing Plan: Suspension of an Entry16STOKZIS-H: Cancellation Indicatornvarchar10
32N1NRSPHPOBSOLETE11STOKZIS-H: Cancellation Indicatornvarchar10
33N1NSRVTEAMOBSOLETE - Nursing Services: Employees for Service11STOKZIS-H: Cancellation Indicatornvarchar10
TOPOverhead Cost Controlling
34COBKCO Object: Document Header16STOKZIndicator: Document Has Been Reversednvarchar10
TOPOverhead Cost Orders
35AUAKDocument Header for Settlement15STOKZIndicator: Document Has Been Reversednvarchar10
TOPPegging, Grouping, and Distribution
36DIS_ADMINDistribution - Administration Table31STOKZIndicator: Document Has Been Reversednvarchar10
TOPPersonnel Time Events
37TPTCOR_LOGISTICLogistics Orders (Correction Scenario)10STOKZIndicator: "Confirmation Cancelled"nvarchar10
TOPPersonnel Time Management
38AFRUHROrder Confirmations for HR7STOKZIndicator: "Confirmation Cancelled"nvarchar10
39CC1ERPIncorrect Time Events from CC1, Postings24STOKZIndicator: "Confirmation Cancelled"nvarchar10
40PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)5STOKZIndicator: Data Record Cancelednvarchar10
41PTEX2003GENInterface Table for IT 2003: General Information5STOKZIndicator: Data Record Cancelednvarchar10
42PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)5STOKZIndicator: Data Record Cancelednvarchar10
43PTEXDIRInterface Table for Infotypes (Directory Table)5STOKZIndicator: Data Record Cancelednvarchar10
44TEVENTime Events25STOKZIndicator: "Confirmation Cancelled"nvarchar10
45TEVEN_MOREAdditional Data for Time Events23STOKZIndicator: "Confirmation Cancelled"nvarchar10
TOPProduct Cost by Period
46CEZPReporting Points Line Items28STOKZIndicator: Document Has Been Reversednvarchar10
TOPProfit Center Accounting
47GLPCAEC-PCA: Actual Line Items90STOKZIndicator: Document Has Been Reversednvarchar10
48GLPCPEC-PCA: Plan Line Items143STOKZIndicator: Document Has Been Reversednvarchar10
TOPReal Estate Management
49VIEPOSLine items for correction items22STOKZIndicator: Document has been reversednvarchar10
50VITAXALine items for correction items24STOKZIndicator: Document has been reversednvarchar10
51VITAXDTax Shares per Real Estate Account Assignment39STOKZIndicator: Document has been reversednvarchar10
52VIVSTBDocument reference for input tax treatment13STOKZIndicator: Document has been reversednvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
53NFSRIS-H: Billing documents for collective invoice (Austria)8STOKZIS-H: Reversal allowed indidicator (if <> ' ')nvarchar10
TOPSAP Utilities
54ECONCPOSTPosting Details for Concession15STOKZDocument Has Been Reversednvarchar10
TOPTime Sheet
55CABAREFCATS: Transfer from CATS II to PS, PM, and CO3STOKZIndicator: Document Has Been Reversednvarchar10
56CATSCOCross-Application Time Sheet (CATS): Transfer to CO3STOKZIndicator: Document Has Been Reversednvarchar10
57CATSCOSUMData Transfer: Time Sheet -> CO Summarization Table3STOKZIndicator: Document Has Been Reversednvarchar10
58CATSMMCross-Application Time Sheet (CATS): Transfer to MM3STOKZIndicator: Document Has Been Reversednvarchar10
59CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS3STOKZIndicator: Document Has Been Reversednvarchar10
60CATSPSCross-Application Time Sheet (CATS): Transfer to PS3STOKZIndicator: Document Has Been Reversednvarchar10
TOPTime Tickets
61EVHRHR Order Confirmations (Times/Time Events)23STOKZIndicator: "Confirmation Cancelled"nvarchar10
62LSHRHR Order Confirmations (Durations/Time Tickets)23STOKZIndicator: "Confirmation Cancelled"nvarchar10
TOPTransfer Prices and Decentralized Responsibility
63KFPKDocument Header: Transfer Price Agreement/Allocation34STOKZIndicator: Document Has Been Reversednvarchar10