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

58 columns | Print definition?ERP 6.0  | ATIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_BADIExit: Implementation side: Attributes11ATIMETimenvarchar60
2CNVCMIS_A_SESSTable to store status information about table analysis5ATIMEDate in CHAR Formatnvarchar80
3CNVTDMS_02_SESSTable to store status information about table analysis5ATIMETime in CHAR formatnvarchar60
4DFKKEPRTLog for Inconsistent FI-CA Documents32ATIMETime at which the object was creatednvarchar60
5P2B2_SKOHCM Declustering B2 - Table SKO11ATIMETime point for time evaluationnvarchar60
6PAPBSGBH_13_CHESA: Contract table (2012/13 onwards)6ATIMETimenvarchar60
7PAPBSGBH_13_PHESA: Person table (2012/13 onwards)5ATIMETimenvarchar60
8PAPBSGB_HESA_CHESA Archive table for NISR Contract table6ATIMETimenvarchar60
9PAPBSGB_HESA_GRHESA Archive table for NISR Grade table6ATIMETimenvarchar60
10PAPBSGB_HESA_PHESA: Archive table for NISR Person table5ATIMETimenvarchar60
11PAPBSGB_SWF_CTRLSWF : Control11ATIMETimenvarchar60
12PAPBSGB_TPS_ARCHTPS Archive table for TPS Annual return records of type 17ATIMETimenvarchar60
13TLANOCSSprachentransport - OCS Import7ATIMESystemzeitnvarchar60
TOPAccounts Receivable Accounting Process Integration
14DEBPPEVENTLOGLogged Event9ATIMETime of Log Entrynvarchar60
TOPBelgium
15T5BSDSI Declaration: directory table14ATIMEnvarchar60
TOPBusiness Planning
16UPB_CW_ANSWERCost Center Wizard: Answers12ATIMELast changed atnvarchar60
17UPB_CW_CCECost Center Wizard: Applications7ATIMELast changed atnvarchar60
18UPB_CW_CCSECost Center Wizard: Subapplication12ATIMELast changed atnvarchar60
19UPB_CW_EP_UICost Center Wizard: Interfaces10ATIMELast changed atnvarchar60
TOPBusiness Planning and Simulation
20UPB_AREA_ATRBalance Sheet Planning: Attributes of Application on Area8ATIMELast changed atnvarchar60
21UPB_PS_NAMEBalance Sheet Planning Interfaces8ATIMELast changed atnvarchar60
22UPC_AREAPlanning Areas8ATIMELast changed atnvarchar60
23UPC_PACKAGEPlanning Packages9ATIMELast changed atnvarchar60
24UPC_PLEVELPlanning Levels8ATIMELast changed atnvarchar60
25UPC_PROFILEPlanning Profiles6ATIMELast changed atnvarchar60
26UPC_STEPSRelations between Characteristics of a Planning Area17ATIMELast changed atnvarchar60
27UPC_VARVariables12ATIMELast changed atnvarchar60
28UPC_VARIABLEVariables - Old Version of Database (New is UPC_VAR)11ATIMELast changed atnvarchar60
29UPE_COUNTCounter8ATIMELast changed atnvarchar60
30UPE_MODELPlanning Modeler: Table Models6ATIMELast changed atnvarchar60
31UPE_PARAMPlanning: Parameterization (SD files)9ATIMELast changed atnvarchar60
32UPE_PARAMT_DOCPlanning: Parameter Group Texts10ATIMELast changed atnvarchar60
33UPE_PARAM_ABCPlanning: Parameterization (ABC files)8ATIMELast changed atnvarchar60
34UPE_PARAM_DOCPlanning: Parameter Group (Documents)8ATIMELast changed atnvarchar60
35UPE_ZAHLCounter8ATIMELast changed atnvarchar60
36UPF_BUNDLEBundle of Planning Functions8ATIMELast changed atnvarchar60
37UPF_PARAMPlanning Functions: Parameterization12ATIMELast changed atnvarchar60
38UPF_PLANFPlanning Functions13ATIMELast changed atnvarchar60
39UPP_PARAMPlanning: Parameterization (Layouts)9ATIMELast changed atnvarchar60
40UPS_TP_HIERARCHYConnection Subplan-Hierarchy13ATIMELast changed atnvarchar60
41UPX_CLUSTERCluster Table for Sales Planning6ATIMETIME Data Element for SYSTnvarchar60
TOPCustomer Enhancements
42SXC_ATTRExit: Implementation side: Attributes7ATIMETimenvarchar60
TOPGeneral Application Functions
43TFISEVENTLOGLogged Event8ATIMETime of Log Entrynvarchar60
TOPIncentive and Commission Management ICM
44CACS_RET_ATIMERetention: Last access time-spot in process5ATIMETime Stamp (YYYY.MM.DD hh:mm:ss)nvarchar140
TOPIreland
45PAPBSIE_PRDPRD: Re-Calculated PRD Amount Table5ATIMETimenvarchar60
46T7IEEEHECS: Return Data6ATIMETimenvarchar60
TOPLanguage Transport
47TLANEXPLanguage Transport: Export Actions8ATIMESystem Timenvarchar60
48TLANIMPLanguage Transport: Import Action7ATIMESystem Timenvarchar60
49TLANSUPLanguage Transport: Supplementation Action7ATIMESystem Timenvarchar60
50TLSY7Language Import History6ATIMEStart Timenvarchar60
TOPMaxDB
51ADATABSIZESAP DB: Table Sizes Including Indexes in KB10ATIMESAP DB: Analysis Timenvarchar60
TOPPersonnel Time Management
52PA2012HR Time Record: Infotype 2012 (Time Transfer Specifications)29ATIMETime point for time evaluationnvarchar60
TOPProduct Safety
53CCGLT_AUDHEHS: Audit Data Header Entry6ATIMETime in CHAR Formatnvarchar60
TOPProfitability Analysis
54/EACA/TPMLIDOCSource Document PM Line Item5ATIMETimenvarchar60
TOPTranslation Tools
55BRACNTLIndustry control table6ATIMETime of last industry changenvarchar60
56BRALOGIndustry log for import/activation of industries7ATIMEStart time of activitynvarchar60
TOPUnited Kingdom
57PAGB_ASHEASHE Return Data8ATIMETimenvarchar60
TOPWorkbench Utilities
58FLLOGFlight data5ATIMEArrival Timenvarchar60