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

61 columns | Print definition?ERP 6.0  | RELATION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/DT_BP_PROCBest Practice Framework - Process7RELATIONRelationnvarchar30
2/OPT/VIM_TPOL3PO line logic Check Group Fields6RELATIONRelationnvarchar30
3BBP_O_TO_VG_RELConversion Org.Model Ext. Partners (Relationships)5RELATIONRelationship Between Objectsnvarchar30
4BBP_PD_INITCHECKDescription of the PD Sets by Object Type8RELATIONType of Relationship Between a Set and an SRM Documentnvarchar10
5CNV_10020_CONDCCConditions complex7RELATIONLogical linknvarchar10
6CNV_10020_CONDCMConditions for specific function modules6RELATIONLogical linknvarchar10
7CNV_10020_CONDCRConditions for specific form routines7RELATIONLogical linknvarchar10
8CNV_10020_CONDDDConditions for comparison of determination and determ.24RELATIONLogical linknvarchar10
9CNV_10020_CONDDVConditions for comparison of determation and values17RELATIONLogical linknvarchar10
10CNV_10020_CONDFDConditions for comparison of field and determination18RELATIONLogical linknvarchar10
11CNV_10020_CONDFFConditions for comparison of field and field12RELATIONLogical linknvarchar10
12CNV_10020_CONDFVConditions for comparison of field and values11RELATIONLogical linknvarchar10
13CNV_10020_DTFLDAssignment of determination to tables and fields15RELATIONLogical linknvarchar10
14CNV_10030_PACKDPDependent packages and dependencies between them6RELATIONRelationship between source package and higher-level packagenvarchar10
15CNV_10100_SETCONFI Set Data Relation between SETCLASS and appl. package4RELATIONRelation of Set conversion customizing to value or key fieldnvarchar10
16T7UNPF_HR_DEPNDDependent details10RELATIONRelationnvarchar100
17T7UNPF_HR_RELMRelation Mapping Table5RELATIONRelationnvarchar100
18TQOPCompare Operators for View Maintenance Query1RELATIONCompare operator for view maintenance function modulesnvarchar20
19TQOPTCompare operators for view maintenance query (texts)2RELATIONCompare operator for view maintenance function modulesnvarchar20
20USMD0072CStatus of a Relationship4RELATIONRelationship Between Entity Typesnvarchar90
TOPABAP Editor
21SEDI_NAV_OO_LOCATable for Local Classes/Interfaces Navigation4RELATIONClasses/Interface Navigation Varianttinyint30
TOPAccounts Receivable Accounting Process Integration
22FDM_DCOBJFSCM-DM Integration: Disputed Objects5RELATIONRelationship in Recordnvarchar20
TOPApplication Framework
23USMD0023Data Model: Relationships of Entity Types4RELATIONRelationship Between Entity Typesnvarchar90
24USMD0023TData Model: Relationships of Entity Types, Descriptive Texts5RELATIONRelationship Between Entity Typesnvarchar90
25USMD0026Data Model: Foreign Key Definition4RELATIONRelationship Between Entity Typesnvarchar90
TOPBasic Functions
26UDM_CLASS_ADMINFSCM-DM: Mapping of Classification to Anchor and Relationshp3RELATIONPOID - POID Relation Type for Areasnvarchar20
TOPBusiness Context Viewer
27/BCV/C_EXPAROutput Parameter9RELATIONReference Fieldnvarchar300
28/BCV/C_QATTRQuery Field16RELATIONReference Fieldnvarchar300
TOPBusiness Partners
29NNOKAdditional HC-Specific Next of Kin Data for SAP BP4RELATIONIS-H: Relationshipnvarchar10
TOPClinical System
30N2VDIS-H*MED PD: Progress Documentation Administrative Data3RELATIONPD: Reference to Contextnvarchar10
TOPCross-Application Components
31/OPT/VPR_PARTNERPartners for Registered Vendor5RELATIONVendor Partner Relationship Codenvarchar20
TOPData Retention Tool
32TXW_C_V4Data view: Selection conditions6RELATIONRelationnvarchar20
TOPEnterprise Service Framework Layer
33SCOOLOBJECTVALValue Table for Cool Objects1RELATIONRelationnvarchar300
34SCOOLRELATIONSRelations2RELATIONRelationnvarchar300
TOPFinancial Accounting
35/OPT/VIM_T119Document Type Determination Step Details11RELATIONRelationnvarchar30
TOPGovernance, Risk and Compliance
36GRFNTASKAUTHRELRelated authorization details per WF task4RELATIONObject Relationnvarchar10
TOPIncentive and Commission Management ICM
37TCACS_OBJRELARelations Between the Field Lists of Generated Objects5RELATIONRelationship Between Two Generated Structuresnvarchar10
TOPLocalization
38J_1BECD_CUST07TTexts for Inter-Company Relationship Codes4RELATIONIntercompany Relationshipnvarchar2550
TOPLogistics - General
39HBSAFFAffected building in Home Building Solution6RELATIONRelationship Between Affected Buildingsnvarchar20
TOPNetWeaver Business Content
40BIZCRDCBusiness Content: Development Component Versions7RELATIONBusiness Content: Component Relationnvarchar200
41BIZCRDCVObsolete7RELATIONBusiness Content: Component Relationnvarchar200
42BIZCRSCVBusiness Content: Software Component Versions8RELATIONBusiness Content: Component Relationnvarchar200
TOPPackage Tools
43AKB_PRODUCTSProduct Catalog5RELATIONObsolete: Relationship Between Productsnvarchar10
TOPProduct Structure Browser
44FILTERDEFOperative Filter Entries for Product Structure Browser8RELATIONRelationship between obj. types in Product Structure Browsernvarchar50
TOPProfitability Analysis
45TKENODE01ACO-PA: Attributes for Node Table TKENODE017RELATIONCO-PA Hierarchy: Relationship of objects to predecessorsnvarchar80
TOPResourcen Management
46RMXTC_M04TMS-TLS: Monitor Customizing - Task Relationship Rules11RELATIONObject Relationshipnvarchar10
TOPSAP Records Management
47SRMRGDEFRELRegistry: Defaults: Customizing Relation Types3RELATIONFramework Registry: Customizing for Defaults: Relationnvarchar100
48SRMRGDEFRELTFramework Registry: Customizing for Defaults: Relation Texts3RELATIONFramework Registry: Customizing for Defaults: Relationnvarchar100
49SRM_REG_DEFAULTSRegistry: Defaults: Customizing Relations3RELATIONFramework Registry: Customizing for Defaults: Relationnvarchar100
TOPSearch Integration
50/PLMPCV/C_EXPAROutput Parameter7RELATIONReference Fieldnvarchar300
TOPSpecification 2
51SPCFILESPEC 2000 messages & fields11RELATIONIndicates which fields in the given message are relatednvarchar10
52SPCIPMAPSPEC2000: MetaData Information on IP Files12RELATIONIndicates which fields in the given message are relatednvarchar10
53SPCMFILESPEC 2000 AEC messages & fields12RELATIONIndicates which fields in the given message are relatednvarchar10
TOPStructural Graphics
54T77GLDesign Description (Type-Oriented/Relationships)3RELATIONRelationshipnvarchar40
55T77GRData Set Description (Relationships)3RELATIONRelationshipnvarchar40
56T77GVDefinition of Relationship Data1RELATIONRelationshipnvarchar40
57T77LVTexts for Relationship Data2RELATIONRelationshipnvarchar40
TOPTraining Management
58LSOTFORMP_CDelivery Method Attributes4RELATIONSubtypenvarchar40
TOPTravel Expenses
59PTRV_RECDETAILParticipant(s) in Entertainment Receipts8RELATIONRelationship to Companynvarchar10
TOPUSA
60BRCDTABSI-TAX 4.0 BRCDTA7RELATIONBSI40: RELATIONnvarchar20
61BRCGDTABSI-TAX 4.0 BRCGDTA7RELATIONBSI40: RELATIONnvarchar20