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

125 columns | Print definition?ERP 6.0  | REFERENCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPCC_LOGLog Credit Card Interface41REFERENCEReferencenvarchar190
2/DSCSAG/DOC_REDTable with redundant data19REFERENCECDESK: Checkboxnvarchar10
3/OPT/CT_IDH_MAILInbound Document Handler: Email Input Log - obsolete12REFERENCENot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
4/XPPM/CAR_C_OPOutput and selection definiton6REFERENCEField or Methodnamenvarchar300
5CMCBD_DOCUMENTCash Budgeting Document10REFERENCEDocument Referencenvarchar210
6CNVCMIS_A_1_FUNPFucp type Repository Analysis12REFERENCECall by referencenvarchar10
7CNV_10940_PARAStoring parameters and select options8REFERENCEText of length 132nvarchar1320
8E070ASSystem-Specific (CTS): Attributes of a Request5REFERENCEAttribute valuenvarchar320
9E070AS_PREVIEWSystem-Specific (CTS): Attributes of a Request (preview)5REFERENCEAttribute valuenvarchar320
10EPIC_EBR_FEBAdditional Data on Bank Statement Line Item for Bank Receipt17REFERENCEReference Key on Bank Receiptnvarchar400
11EPIC_EBR_HDROBSOLETE!!!13REFERENCEReference Key on Bank Receiptnvarchar400
12GRFNDEOFLDDummy EO Fields13REFERENCEReference fieldnvarchar700
13GRFNEVTFIELDEvent Fields10REFERENCEEvent Reference Fieldnvarchar200
14J_1UF_CLR_REFReferences to Clearing doc for which no tax docs needed8REFERENCECharacter field of length 40nvarchar400
15J_1UF_FINAL_CLRClearing documents for which no tax documents needed11REFERENCECharacter field of length 40nvarchar400
16OCS_CP_E070ATLOGO E070A für CP TR: Attribute eines Auftrags4REFERENCEWert des Attributesnvarchar320
17T7INCLM_ADV_TRNSClaims & Advance Transaction Table5REFERENCESystem generated Reference Numbernvarchar200
18T7INLEAVE_EN_TRLeave Encashment Transaction table3REFERENCESystem generated Reference Numbernvarchar200
19T7INLOAN_TRNSDTLoans Specific Data3REFERENCESystem generated Reference Numbernvarchar200
20T7INREIM_TRNSDTTemporary table store & retrieve Reimbursement Specific data4REFERENCESystem generated Reference Numbernvarchar200
21T7INREPAY_TRNSRepayment Specific data3REFERENCESystem generated Reference Numbernvarchar200
22T7INTRNS_METADATIPS: Temp tab to monitor transactional data changes5REFERENCESystem generated Reference Numbernvarchar200
23T7INTRNS_META_DTLog changes to status of transactional data6REFERENCESystem generated Reference Numbernvarchar200
24ZPH_RESS_STATUSStatus table for resources (Logbook)16REFERENCECharacter string - 64 user-defined charactersnvarchar640
25HRT1750Table Section for Infotype 175018REFERENCEDate Referencenvarchar10
26T7PIQAUDDACTIONAudit: BSP Views2REFERENCEReference Type for Action Group or Exception Groupnvarchar10
27T7PIQAUDDACTNGRPAudit: Action Groups for BSP Views3REFERENCEReference Type for Action Group or Exception Groupnvarchar10
28T7PIQAUDDEXCNGRPAudit: Exception Groups for Dialog with BSP Views3REFERENCEReference Type for Action Group or Exception Groupnvarchar10
29T7PIQAUDDEXCPTNAudit: Dialog Exceptions with BSP Views2REFERENCEReference Type for Action Group or Exception Groupnvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
30CRMSDPCOLLOGOUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED7REFERENCEnvarchar320
TOPAccounting - General
31TFC_INST_HDRHeader Information on Status Admin for Fast Close13REFERENCEReference Fieldnvarchar500
32TFC_TEMPL_HDRHeader Information on Status Admin for Fast Close13REFERENCEReference Fieldnvarchar500
TOPAccounts Receivable Accounting Process Integration
33DEBPPEVENTLOGLogged Event20REFERENCEExternal Transaction as Reference for Log Entriesnvarchar240
TOPAnti-Virus Protection
34VSCAN_PROFVirus Scan Profiles6REFERENCEReference Profilenvarchar400
TOPAudit Management
35PLMM_QUEST_RESAudit Question/Reply List/Item37REFERENCEReference to an Objectvarbinary160
TOPBank Customer Accounts
36TBCA_US_R_HOLDRefrence adjustment types that can be created9REFERENCEOpen reference field for lookupsnvarchar300
TOPCentral Part of Product Master
37COMM_PRCATFRGRAssignment Product Category - Set Type6REFERENCESet Type Data Is Referencednvarchar10
38COMM_PRCATFRGRHProduct Category - Set Type Assignment: History7REFERENCESet Type Data Is Referencednvarchar10
TOPChargeback
39WCOCOHCondition Contract: Header6REFERENCECondition Contract: Referencenvarchar160
40WCOCOICondition Contract: Eligible Partner9REFERENCECondition Contract: Referencenvarchar160
TOPClaims Management
41ICLCCEVENTBClaim Bundle - Participant Occurrence13REFERENCEReference (Contract Number or Customer Number)nvarchar170
42ICLPARTParticipants11REFERENCEReference (Contract Number or Customer Number)nvarchar300
43ICSCCEVENTBClaim Bundle - Participant Occurrence13REFERENCEReference (Contract Number or Customer Number)nvarchar170
44ICSPARTParticipant in Claim11REFERENCEReference (Contract Number or Customer Number)nvarchar300
TOPClassification System New
45CME_ST_FORMATCME Data Type: Format Details25REFERENCEReference for Complex Data Typevarbinary160
46CME_ST_FORMAT1CME-Datentyp: Formatangaben24REFERENCEReferenz für komplexen Datentypvarbinary160
47CME_ST_FORMATHCME Data Type: Format Details23REFERENCEReference for Complex Data Typevarbinary160
TOPCollectionsDisbursements
48ITAGCYINSCOMPSHAgency Collections: Shares to Be Transferred to Insurance4REFERENCEShares to Insurance: Reference to Originnvarchar200
TOPConditions
49KONDINDGeneral Document Index for Conditions9REFERENCEReferencenvarchar180
TOPContract Accounts Receivable and Payable
50DFKKCRRepository For Checks51REFERENCEReference Informationnvarchar500
51DFKKCRDELCR: Deleted Payment Medium / Basic Data54REFERENCEReference Informationnvarchar500
TOPCross-Application Components
52SPRTL16Data Collection Function Modules: Definition of Parameters5REFERENCEDrag&Relate: Reference for the Parameternvarchar1320
TOPFinancial Accounting
53DEFTAX_ITEMData for Deferred Taxes43REFERENCEReference Fieldnvarchar200
TOPFunction Builder
54FUPARAREFParameters of function modules7REFERENCECall by referencenvarchar10
55FUPARAREF_ENHAParameters of function modules7REFERENCECall by referencenvarchar10
TOPGeneral Application Functions
56TFISEVENTLOGLogged Event20REFERENCEExternal Transaction as Bracket for Event Entriesnvarchar240
TOPGovernance, Risk and Compliance
57GRFNDMFPCCNDataMart: Facts PC Control10REFERENCELeading case GUIDnvarchar320
58GRFNDMFPCECDataMart: Facts ELC9REFERENCELeading case GUIDnvarchar320
59GRFNDMFPCSPDataMart: Facts PC Subprocess9REFERENCELeading case GUIDnvarchar320
TOPInterest Calculation
60T056ITime-dep.terms for interest calc.rule9REFERENCEReference Interest Ratenvarchar100
TOPLocalization
61J_3RFSEC_ITEMData for Secondary events for deferred tax38REFERENCEReference Fieldnvarchar200
62J_3RTSESecondary index table for VAT15REFERENCEAllocation numbernvarchar180
TOPLogistics Basic Data
63WRF_CMMD_CDT1Category18REFERENCEReference Nodenvarchar180
64WRF_CMMD_CDT2Subcategory18REFERENCEReference Nodenvarchar180
65WRF_CMMD_CDT3Segment18REFERENCEReference Nodenvarchar180
66WRF_CMMD_CDT4Subsegment18REFERENCEReference Nodenvarchar180
67WRF_CMMD_CDT5Sub-Subsegment18REFERENCEReference Nodenvarchar180
68WRF_CMMD_CDT6Product Group18REFERENCEReference Nodenvarchar180
69WRF_CMMD_CDT7Brand18REFERENCEReference Nodenvarchar180
70WRF_MATGRP_MD1Hierarchy Level 1 - Time-Dependent23REFERENCEReference Nodenvarchar180
71WRF_MATGRP_MD10Hierarchy Level 10 - Time-Dependent32REFERENCEReference Nodenvarchar180
72WRF_MATGRP_MD2Hierarchy Level 2 - Time-Dependent24REFERENCEReference Nodenvarchar180
73WRF_MATGRP_MD3Hierarchy Level 3 - Time-Dependent25REFERENCEReference Nodenvarchar180
74WRF_MATGRP_MD4Hierarchy Level 4 - Time-Dependent26REFERENCEReference Nodenvarchar180
75WRF_MATGRP_MD5Hierarchy Level 5 - Time-Dependent27REFERENCEReference Nodenvarchar180
76WRF_MATGRP_MD6Hierarchy Level 6 - Time-Dependent28REFERENCEReference Nodenvarchar180
77WRF_MATGRP_MD7Hierarchy Level 7 - Time-Dependent29REFERENCEReference Nodenvarchar180
78WRF_MATGRP_MD8Hierarchy Level 8 - Time-Dependent30REFERENCEReference Nodenvarchar180
79WRF_MATGRP_MD9Hierarchy Level 9 - Time-Dependent31REFERENCEReference Nodenvarchar180
80WRF_MATGRP_STRUCCategory Structure13REFERENCEReference Nodenvarchar180
TOPManagement of Internal Controls
81HRP1804DB Table for InfoType 180429REFERENCEnvarchar100
TOPMaterial Master
82WER_TMPL_REF_AReferences to template elements: where-used list (Customers)3REFERENCEElement unique identifiernvarchar320
83WER_TMPL_REF_SReferences to template elements: where-used list2REFERENCEElement unique identifiernvarchar320
TOPMetadata Repository
84RSOCLASSREFBW Metadata Repository: References for a Class2REFERENCEBW Metadata Repository, Class: Name of a Referencenvarchar300
TOPMobile Applications
85/ISDFPS/ME_COMATCompatibility Matrix2REFERENCEGUIDnvarchar320
TOPPrice Planning Workbench
86WRF_PPW_PPDCALCPPD Calculation Set4REFERENCEvarbinary160
87WRF_PPW_PPDPAPPD Price Activation Level4REFERENCEvarbinary160
TOPProcess Controls
88GRPCCTRLPROPOSALGRPC:Control Proposal22REFERENCEReferenced Object (Type + ID)nvarchar100
89HRP5304DB Table for Infotype 530435REFERENCEnvarchar100
TOPProduct Safety
90EST_CHANGE_DOCSEHS: Change Documents in the EH&S System21REFERENCESpecificationnvarchar120
TOPRecords and Case Management
91RMPS_DISELEMSRetention Elements (Data Record Descriptions)15REFERENCERecord No.nvarchar640
TOPRemaining Beverage - Obsolete Objects
92/BEV3/CHBCALCCAgreement Calculation - Formula Constant9REFERENCEReference valuenvarchar320
93/BEV3/CHCFMCONFormula constant4REFERENCEReference valuenvarchar320
TOPReusable Components of Business Suite Foundation
94/BOBF/D_TXCTXTText9REFERENCEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
95/BOFU/C_TXCTTSAssignment Text Type to Text Schema and Configuration8REFERENCEReferencenvarchar10
96/BOFU/C_TXC_TSText Schema: Definition8REFERENCEnvarchar10
97/BOFU/S_TXCTTSAssignment Text Type to Text Schema and Configuration7REFERENCEReferencenvarchar10
98/BOFU/S_TXC_TSDefault Text Schema Definition7REFERENCEnvarchar10
TOPSales
99LORDC_MAPPINGMapping Table for Lean Order Interface3REFERENCEName of a Screen Elementnvarchar1320
TOPSAP NetWeaver Mobile - Use subcomponents
100MEREP_809Function Module Interfaces5REFERENCEPass by Reference Flagnvarchar10
TOPSAP Records Management
101SRMRGOBJECResults of Program Runs in Record Character Generation6REFERENCERecord Numbernvarchar1280
102SRMRGRESERReservation5REFERENCEnvarchar1280
TOPService Data Download
103/BDL/IFCHA/BDL/SDCC: In/Out-Parameter8REFERENCESingle-Character Indicatornvarchar10
104/BDL/IFEXP/bdl/sdcc: export-parameter6REFERENCESingle-Character Indicatornvarchar10
105/BDL/IFIMP/BDL/SDCC: Import-Parameter8REFERENCESingle-Character Indicatornvarchar10
106BDLIFCHABDL SDCC: Input/Output Parameters8REFERENCESingle-Character Indicatornvarchar10
107BDLIFEXPBDLSDCC: Export Parameters6REFERENCESingle-Character Indicatornvarchar10
108BDLIFIMPBDL SDCC: Import Parameters8REFERENCESingle-Character Indicatornvarchar10
TOPStructural Graphics
109T77GFDefinition of Object Data7REFERENCEReference to Object Datanvarchar120
TOPTemplates
110TFW_MTPTYPETFW: Mini-Template Types4REFERENCEType of Referencing in the Template Frameworknvarchar10
TOPText Retrieval and Information Extraction
111SRETCLASSClasses5REFERENCENumeratornvarchar50
TOPTransaction Manager
112OTC_CONV_FINKOBackup Table for Financial Transaction Conditions90REFERENCEReferencenvarchar320
113OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions89REFERENCEReferencenvarchar320
114TCORT_CODIADeal: Interest Rate Adjustment10REFERENCEReference Interest Ratenvarchar100
115TEMT_RAWEXPOSRaw Exposure22REFERENCEReference (E-HA)nvarchar160
116TEMT_VERSEXPOSVersioned Exposure37REFERENCEReference (E-HA)nvarchar160
117TEXT_POSITIONSExposure Positions52REFERENCEReferencenvarchar160
118THMEXT_TRANSE-HA: Transactions9REFERENCEReference (E-HA)nvarchar160
119VTBFINKOTransaction Condition90REFERENCEReferencenvarchar320
120VTIFINKOUnderlying transaction conditions89REFERENCEReferencenvarchar320
TOPTransport Management System
121LISCOMDESLIS: Destination Table11REFERENCEAlias name for destinationnvarchar320
TOPTransport Organizer
122E070AChange & Transport System: Attributes of a Request4REFERENCEAttribute valuenvarchar320
123E070A__PREVIEWTransport Request Preview: Attributes of a Request4REFERENCEAttribute valuenvarchar320
124WBOATTRCTS: Request Attributes3REFERENCEAttribute value obligatorynvarchar10
TOPWorkbench Utilities
125SPAR_NTDBParameter Storage: Persistent Nametab Container3REFERENCEName of Dictionary Typenvarchar300