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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

128 columns | Print definition?ERP 6.0  | SUBID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMB/RCA_BALITMBalancing Item Assignments4SUBIDSpecificationnvarchar120
2/SDF/ZQLMSSQL Monitor: Subkeys1SUBIDNatural Numberint100
3CCGLT_PRTREQ_HDREHS: Print Request Header Table18SUBIDSpecificationnvarchar120
4CCGLT_PR_HDR_UT2EHS: Print Request Header Table Test Data for Unit Test21SUBIDSpecificationnvarchar120
5DFKKODNREPOfficial Document Number for Reporting20SUBIDGeneric Key Extension for Document Class Determinationnvarchar30
6EHPRCD_ACHG_ROOTACP Relevant Change - Root9SUBIDSubstance IDnvarchar120
7EHPRCD_EXIMDSAvailable Search Criteria3SUBIDSpecificationnvarchar120
8EHPRCD_PERFCP: Performance Tests7SUBIDSpecificationnvarchar120
9EHPRCD_STRU_IMGProduct Structure Expanded Image23SUBIDSpecificationnvarchar120
10PA3375HR Master Record: Infotype 337590SUBIDSubmitted bynvarchar200
11PA3376HR Master Record: Infotype 337631SUBIDSubmitted bynvarchar200
12SQLMSSQL Monitor: Subkeys1SUBIDNatural Numberint100
13SQLMZDSQL Monitor: Data3SUBIDNatural Numberint100
14SQLMZSSQL Monitor: Subkeys2SUBIDNatural Numberint100
15SRTMP_DATARuntime Monitoring: Data Table5SUBIDNatural Numberint100
16SRTMP_SUBRuntime Monitoring: Subkey Table3SUBIDNatural Numberint100
17T5FPBS5NPas d'un module de condition d'admissibilité (avancement)4SUBIDNom de la substitutionnvarchar70
18TFK_DOCCLS_DETAssign Document Classes to Document Type sand Origin Keys5SUBIDGeneric Key Extension for Document Class Determinationnvarchar30
19TFK_ODN_SID_DETODN: Sub-ID Determination17SUBIDGeneric Key Extension for Document Class Determinationnvarchar30
20TFK_ODN_SUBIDODN: Sub-ID3SUBIDGeneric Key Extension for Document Class Determinationnvarchar30
21TFK_ODN_SUBIDTODN: Sub-ID (Text)3SUBIDGeneric Key Extension for Document Class Determinationnvarchar30
TOPAccrual Engine
22ACEDSASSGMTStandard Account Assignments for Accrual Objects5SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
23ACEDSOHAccrual Subobject Header Data5SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
24ACEDSOIItem Data for Accrual Subobject5SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
25ACEDSOI_ACCOUNTSAccounts for Accrual Postings per Accrual Item5SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
26ACEDSOPAccrual Subobject Parameters5SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
27ACEPSOHAccrual Subobject: Header Data in Posting Component5SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
28ACEPSOIAccrual Item: Values in Posting Component6SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
29ACEPSOITLine Items for Accrual Item in Accrual Engine6SUBIDAccrual Subobject (Internal Display, Sequence Number)nvarchar50
TOPCATT Computer Aided Test Tool
30CAT_DP_FLDExport fields for DataProvider3SUBIDCharacter field, 8 characters longnvarchar80
31CAT_DP_FORDataTab format for data provider ! Iposition Ioffset !3SUBIDCharacter field, 8 characters longnvarchar80
32CAT_DP_PRODataTab properties for data provider3SUBIDCharacter field, 8 characters longnvarchar80
33CAT_DP_TABSave CATT DataProvider data3SUBIDCharacter field, 8 characters longnvarchar80
34CAT_FDATACATT contents for field lists in CAT_FINFO3SUBIDCharacter field, 8 characters longnvarchar80
35CAT_FINFOGeneral Control field info3SUBIDCharacter field, 8 characters longnvarchar80
36CAT_PARAMSCATT - Data for Controls3SUBIDCharacter field, 8 characters longnvarchar80
37CAT_VARSCATT - Data for Controls3SUBIDCharacter field, 8 characters longnvarchar80
38CAT_VERBSCATT - Controls data3SUBIDCharacter field, 8 characters longnvarchar80
TOPCompliance Check
39EHSBT_RC_ESTRHSHEHS: Table f. Storing Substs w. Constraints in Shared Memory21SUBIDSpecificationnvarchar120
TOPData Collection
40TMCELIS - Environment generation sample reports and references2SUBIDSubset Id for generating function modulesnvarchar50
TOPeCATT Extended Computer Aided Test Tool
41CAT_SVARSDBTab for Control Framework3SUBIDCharacter field, 8 characters longnvarchar80
42ECSCR_TFLDeCATT - TCD Data Provider Data DP_FLD Export Data5SUBIDCharacter field, 8 characters longnvarchar80
43ECSCR_TFOReCATT - TCD Data Provider Data DP_FOR Format for DataTab5SUBIDCharacter field, 8 characters longnvarchar80
44ECSCR_TPAReCATT - TCD Control Data PARAMS5SUBIDCharacter field, 8 characters longnvarchar80
45ECSCR_TPROeCATT - TCD Data Provider Data DP_PRO Properties for DataTab5SUBIDCharacter field, 8 characters longnvarchar80
46ECSCR_TSVAReCATT - TCD Control Data SVARS5SUBIDCharacter field, 8 characters longnvarchar80
47ECSCR_TTABeCATT - TCD Data Provider Data DP_TAB5SUBIDCharacter field, 8 characters longnvarchar80
48ECSCR_TVAReCATT - TCD Control Data VARS5SUBIDCharacter field, 8 characters longnvarchar80
49ECSCR_TVEReCATT - TCD Control Data VERBS5SUBIDCharacter field, 8 characters longnvarchar80
TOPEnvironment, Health and Safety
50/TDAG/CPT_EXIMDSAvailable Search Criteria3SUBIDSpecificationnvarchar120
51/TDAG/CPT_EXUPLCP: Application Table für IMDS Uplolad2SUBIDSpecificationnvarchar120
52/TDAG/CPT_PERFCP: Performance Tests7SUBIDSpecificationnvarchar120
53/TDAG/CPT_TASKHHeader data for tasks3SUBIDSpecificationnvarchar120
54/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv3SUBIDSpecificationnvarchar120
55/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten5SUBIDSpecificationnvarchar120
56/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv5SUBIDSpecificationnvarchar120
57EHQMT_BASIC_DATAEH&S-QM: Basic Data for Inspection Plans5SUBIDSpecificationnvarchar120
TOPGoods Receipt Process
58BORRTTITime for route schedule (new)5SUBIDSchedule Item Numbernvarchar40
59BORRTTSRoute schedule header (new)13SUBIDLast Item Counternvarchar40
TOPInspection Planning
60QMIPD_MAP_QPAMMapping Table for Selected Set from External Source7SUBIDSpecificationnvarchar120
TOPLease Accounting
61FIEH_STATUSObject Status for Restart Exception Handling5SUBIDSubobject Numbernvarchar50
62FILA_GF_ITEMCHAHObject Data: Value ID Change Header Information5SUBIDSubobject Numbernvarchar50
63FILA_GF_ITEMDATAProcess Data5SUBIDSubobject Numbernvarchar50
64FILA_GF_ITEMDOCSAssignment of Process - FI/CO Document Numbers4SUBIDSubobject Numbernvarchar50
65FILA_GF_ITEMLINKAssignment of Objects to Assets5SUBIDSubobject Numbernvarchar50
66FILA_GF_ITEMPARMObject Data: Additional Information5SUBIDSubobject Numbernvarchar50
67FILA_GF_ITEMVALCObject Data: Changed Value IDs5SUBIDSubobject Numbernvarchar50
68FILA_GF_ITEMVALSObject Data: Value IDs and their Values/Contents5SUBIDSubobject Numbernvarchar50
69FILA_GF_PROCINFOObject Data: Processing Info for Process5SUBIDSubobject Numbernvarchar50
70FILA_RE_LNKLink Between Leasing <-> Refinancing4SUBIDSubobject Numbernvarchar50
71FILA_RE_TR_ITranche Item: Selection Result for Refinancing4SUBIDSubobject Numbernvarchar50
72FIOTPOHOne-Time Postings: Header5SUBIDSubobject Numbernvarchar50
73FIOTPOIOne-Time Postings: Items5SUBIDSubobject Numbernvarchar50
74LAE_BILLING_DATPayment Schedule3SUBIDSubobject Numbernvarchar50
75LAE_BILLING_DATAPayment Schedule4SUBIDSubobject Numbernvarchar50
76LAE_CRM_BILLPLANPayment Schedule4SUBIDSubobject Numbernvarchar50
77LAE_CRM_CLASSContract Classification4SUBIDSubobject Numbernvarchar50
78LAE_CRM_CONDSLease-Accounting-Relevant Conditions4SUBIDSubobject Numbernvarchar50
79LAE_CRM_ITEMSLAE: Contract Items4SUBIDSubobject Numbernvarchar50
80LAE_CRM_LNKLink between LAE and CRM Contract Items6SUBIDSubobject Numbernvarchar50
81LAE_CRM_PRODSProduct Information4SUBIDSubobject Numbernvarchar50
82LAE_VICN01_ADAdditional Contract Data for LAE5SUBIDSubobject Numbernvarchar50
TOPMaintenance Orders
83/MRSS/D_DEM_ADMAdministrative Demand Item Data7SUBIDSub ID of Demand Itemnvarchar40
TOPMeasuring Points and Counters
84IMPHMeasurement and Counter Reading Transmission History3SUBIDLine Number in Table IMPH (2,000,000,001 - n)int100
TOPProduct Safety
85CCGLT_AUDHEHS: Audit Data Header Entry13SUBIDSpecificationnvarchar120
86CCRCT_CALCEHS: Calculated Average6SUBIDSpecificationnvarchar120
87CCRCT_COEHS: Confirmed Consumed Quantities6SUBIDSpecificationnvarchar120
88CCRCT_COPLEHS: Planned Consumed Quantities6SUBIDSpecificationnvarchar120
89CCRCT_CUEHS: Customer List - Header Data8SUBIDSpecificationnvarchar120
90CCRCT_EHS_COMPEHS: Composition (EH&S Data)5SUBIDSpecificationnvarchar120
91CCRCT_PREHS: Confirmed Produced Quantities6SUBIDSpecificationnvarchar120
92CCRCT_PRPLEHS: Planned Produced Quantities6SUBIDSpecificationnvarchar120
93CCRCT_PUEHS: Confirmed Purchased Quantities6SUBIDSpecificationnvarchar120
94CCRCT_PUPLEHS: Planned Purchased Quantities6SUBIDSpecificationnvarchar120
95CCRCT_SOEHS: Confirmed Sold Quantities6SUBIDSpecificationnvarchar120
96CCRCT_SOPLEHS: Planned Sold Quantities6SUBIDSpecificationnvarchar120
97CVDDHEHS: Report shipping orders51SUBIDSpecificationnvarchar120
98EHCSMD_SPC_UTCBUI_BO Unit Test Helper DB Table7SUBIDSpecificationnvarchar120
99ESTDHEHS: Report Header16SUBIDSpecificationnvarchar120
100ESTDSCSEHS: eSDS Control Structure16SUBIDSpecificationnvarchar120
101ESTOCCEHS: OCC: Table for Saving Import Information17SUBIDSpecificationnvarchar120
102ESTRHEHS: Specification Header18SUBIDSpecificationnvarchar120
103EST_CHANGE_DOCSEHS: Change Documents in the EH&S System3SUBIDSpecificationnvarchar120
TOPPublic Sector
104PA0752HR Master Record: Infotype 075240SUBIDSubmitted bynvarchar200
105PA0753HR Master Record: Infotype 075332SUBIDSubmitted bynvarchar200
106PA0754HR Master Record: Infotype 075430SUBIDSubmitted bynvarchar200
107PA0755HR Master Record: Infotype 075527SUBIDSubmitted bynvarchar200
TOPRecipe Development
108/PLMB/CCK_DRECompliance Check: Detailed Results4SUBIDSpecification IDnvarchar120
109/PLMB/CCK_OBJCompliance Check: Objects to be checked3SUBIDSpecification IDnvarchar120
110/PLMB/CCK_PDEFCompliance Check: Parameter Defaults2SUBIDSpecification IDnvarchar120
TOPRemaining Beverage - Obsolete Objects
111/BEV3/CHCTBTDATData to be Copied for Each BTE3SUBIDSubset ID for Generating Function Modulesnvarchar50
TOPResourcen Management
112FRMLC71RMS-FRM: Sort Sequence for Diet Groups2SUBIDSubstancenvarchar120
113FRMLC_NTR_GRPRMS-FRM: Nutrient Groups2SUBIDSubstancenvarchar120
114RMXTT_TRIAL_FRMLTrial: Material Consumption (Formula)12SUBIDSpecificationnvarchar120
TOPRuntime Analysis
115HIT_CMP_AUSOutput Structure for Hit List Compare2SUBIDnvarchar10
116SATR_HIT_HIEREvent Hierarchy for SE30 and Hit List Compare3SUBIDSATR: SUBID: Sub-ID of a TRACE Recordnvarchar10
117SATR_ID_SUBIDSATR: Table of ID/SUBID Combinations2SUBIDSATR: SUBID: Sub-ID of a TRACE Recordnvarchar10
118SATR_ID_SUBID_SDRT Analysis: ID/SubID Text Assignment for Sequence Diagram2SUBIDSATR: SUBID: Sub-ID of a TRACE Recordnvarchar10
119SATR_ZUOSATR : Assignment Table ID/SUBID for Main/Middle Groups2SUBIDSATR: SUBID: Sub-ID of a TRACE Recordnvarchar10
TOPSAP System Log
120TSL1DSystem Log Message (Formerly 100S or TSL01)2SUBIDSystem log: Third character of message namenvarchar10
121TSL1TSystem Log: Message texts (Formerly T100S, TSL01)3SUBIDSystem log: Third character of message namenvarchar10
TOPService Data Download
122TCUSSYSLSummary table of message types read from the system log2SUBIDSingle-Character Indicatornvarchar10
TOPSyntax, Compiler, Runtime
123SRTM_DAABRuntime Monitoring: Data Table3SUBIDNatural Numberint100
124SRTM_DATARuntime Monitoring: Data Table3SUBIDNatural Numberint100
125SRTM_DATAXRuntime Monitoring: Data Table for Hexadecimal Strings3SUBIDNatural Numberint100
126SRTM_SUBRuntime Monitoring: Subkey Table1SUBIDNatural Numberint100
TOPValue Adjustment
127/IBS/CRB_BA_NRKRRBD: Number Range Assignment3SUBIDRBD: Sub ID (Help Key Field)nvarchar200
TOPWarranty Claim Processing
128CWTYVSActivation Table for Validation/Substitution6SUBIDSubstitution namenvarchar70