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

89 columns | Print definition?ERP 6.0  | REF_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBO_ASOSB: OData Associations9REF_TYPEService Builder: OData Text Reference Typenvarchar10
2/IWBEP/I_SBO_ATSB: OData Association Sets8REF_TYPEService Builder: OData Text Reference Typenvarchar10
3/IWBEP/I_SBO_CTSB: OData Complex Types7REF_TYPEService Builder: OData Text Reference Typenvarchar10
4/IWBEP/I_SBO_ESSB: OData Entity Sets15REF_TYPEService Builder: OData Text Reference Typenvarchar10
5/IWBEP/I_SBO_ETSB: OData Entity Type11REF_TYPEService Builder: OData Text Reference Typenvarchar10
6/IWBEP/I_SBO_FISB: OData Function Imports12REF_TYPEService Builder: OData Text Reference Typenvarchar10
7/IWBEP/I_SBO_FPSB: Function Import Parameters17REF_TYPEService Builder: OData Text Reference Typenvarchar10
8/IWBEP/I_SBO_MRSB: OData Model Referece5REF_TYPEService Builder: OData Model Reference Typenvarchar40
9/IWBEP/I_SBO_NPSB: OData Navigation Property8REF_TYPEService Builder: OData Text Reference Typenvarchar10
10/IWBEP/I_SBO_PRSB: OData Properties28REF_TYPEService Builder: OData Text Reference Typenvarchar10
11/IWBEP/I_SBO_RCSB: OData Referential Constraints9REF_TYPEService Builder: OData Text Reference Typenvarchar10
12/SDF/CC_RELLink between CC_OBJECTS and CC_REF entries30REF_TYPEnvarchar40
13/UIF/LREPDEREFLRep external reference table3REF_TYPELRep reference typenvarchar100
14/UIF/LREPDEREFCDLRep external reference table - client-dependent4REF_TYPELRep reference typenvarchar100
15/UIF/LREPDEREFULRep external reference table - user-dependent5REF_TYPELRep reference typenvarchar100
16/UIF/LREPDREFLRep reference table3REF_TYPELRep reference typenvarchar100
17/UIF/LREPDREFCDLRep reference table - client-dependent4REF_TYPELRep reference typenvarchar100
18/UIF/LREPDREFULRep reference table - user-dependent5REF_TYPELRep reference typenvarchar100
19CNVCDOPUCIA_RESCDOP : UCIA - Result of Remote Comparison of SAP Objects14REF_TYPEnvarchar10
20CNVMBTDELREFDeletion references for the coordinated reorganization4REF_TYPEDeletion typesnvarchar10
21CPEC_EXTENSIONCPE Extension3REF_TYPECPE Reference Typenvarchar10
22CPED_EXTENSIONCPE Extension Data5REF_TYPECPE Reference Typenvarchar10
23EDOREFTYPEeDocument Document Reference type1REF_TYPEeDocument Document Reference Typenvarchar100
24EDOREFTYPETeDocument: Document Reference Type Description2REF_TYPEeDocument Document Reference Typenvarchar100
25J_1UF_CLR_REFReferences to Clearing doc for which no tax docs needed7REF_TYPEReference Document Typenvarchar10
26RSBPCB_SOBJ_LKPBPC: Semantic object link parameter7REF_TYPEBPC: Typenvarchar200
27TNNL_KT_DBCDiagnose Thesaurus Beziehung DBC Kode7REF_TYPEReferenz typnvarchar200
28TNNL_KT_ICD10Diagnose Thesaurus Beziehung ICD10 Kode7REF_TYPEReferenz typnvarchar200
TOPAgency Business Global Trade
29WBRPAgency business: Item136REF_TYPEReference Document Categorynvarchar20
TOPASAP AcceleratedSAP
30IATNODE01RGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
31TNODEREVRReferences for Review Structures3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPASAP Tools and Contents
32SMAPTNODERSolution Map: Node references3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPAuthoring Tools
33QMM_NODERQMM: General Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPBank
34SEPA_MANDATESEPA Mandate27REF_TYPESEPA Mandate: Reference Typenvarchar100
TOPBank Customer Accounts
35TBCA_US_R_HOLDRefrence adjustment types that can be created3REF_TYPEHold Reference Typenvarchar20
36TBCA_US_R_HOLDTText table for reference table4REF_TYPEHold Reference Typenvarchar20
TOPBusiness Navigator
37BMTNODE01RStructure repository for process model objects: References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
38DFTNODE01RStructure repository for process model objects: References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPCondition Technique
39/SAPCND/CONDREFCondition References3REF_TYPEType of Condition Referencenvarchar300
40/SAPCND/REF_TYPECondition Reference Types1REF_TYPEType of Condition Referencenvarchar300
41/SAPCND/REF_TYPTText for Types of Condition Reference1REF_TYPEType of Condition Referencenvarchar300
TOPCorporate Performance Monitor
42UMV_VD100Obsolete: Value Drivers: Header Table5REF_TYPEObject Typenvarchar10
TOPCustom Development Management Cockpit
43CNVCDMCUCIA_RESCDMC : UCIA - Result of Remote Comparison of SAP Objects14REF_TYPEnvarchar10
TOPCustomer Enhancements
44ENH4DELTABTable for Cleanup After Import Object Deletion3REF_TYPEObject Typenvarchar40
TOPDocument Management Framework
45KDS_NODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPDocument Management Services
46SDOKNODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPeCATT Extended Computer Aided Test Tool
47ECBR_NODERSHI3 ECBR/ECBO - Node References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPFinancial Supply Chain Management
48BNK_BTCH_STPAYLDBatch status payload3REF_TYPESource message typenvarchar40
49BNK_BTCH_STREFStatus reference4REF_TYPESource message typenvarchar40
50TBNK_MSG_TYPMessage type2REF_TYPESource message typenvarchar40
51TBNK_MSG_TYP_TMessage type2REF_TYPESource message typenvarchar40
TOPFSCM In-House Cash
52IHC_TAB_LOG_REFIHC: References in Log1REF_TYPEReference Type for Log Fieldnvarchar40
53IHC_TAB_LOG_REFTIHC: Reference Types in Log, Text Table1REF_TYPEReference Type for Log Fieldnvarchar40
TOPHierarchy Storage
54TARCH01RGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
55TNODE01RGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
56TNODERTYPENode type: Assignable link types2REF_TYPEValid Reference Types in Structure Repositorynvarchar40
57TRTYPEHList of valid link types1REF_TYPEValid Reference Types in Structure Repositorynvarchar40
58TRTYPETName of valid link types2REF_TYPEValid Reference Types in Structure Repositorynvarchar40
59TTREV_REFHierarchy tool: Versioning of Links3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPImplementation Guide
60TDOKUIMGRGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
61TNODEIMGRReferences for the new IMG3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
62TNODEPRRGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
63TNODERELNRGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPIncentive and Commission Management ICM
64CACS_FFLTHDFulfillment Level Header6REF_TYPEReference Typenvarchar20
TOPInvoice Forecasting
65IFW_ITEMInvoice forecasting item13REF_TYPEType of Invoice Reference Objectnvarchar20
TOPKnowledge Warehouse
66CUSTNODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
67IWB0NODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
68IWB1NODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
69IWB2NODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
70IWB7NODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
71KWN_NODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
72TXML_NODERXML: General Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPMaster Data
73BCA_US_HLD2RELHold Records which have not been released - Dual Control13REF_TYPEHold Reference Typenvarchar20
74BCA_US_HOLDHold Amounts Which Affect Available Balance12REF_TYPEHold Reference Typenvarchar20
TOPMaterials Management
75/SAPPSPRO/TGMEMFGuaranteed Minimum: Earmarked Fund document type maintenance3REF_TYPEReference Transactionnvarchar50
TOPNetWeaver Enterprise Search
76ESH_QL_QLOGQuery Log8REF_TYPEParent Query Reference Typenvarchar40
TOPPayment Transactions
77FSEPA_REFTYPESEPA Mandate: Permitted Contract Types2REF_TYPESEPA Mandate: Contract Typenvarchar100
78FSEPA_REFTYPETSEPA Mandate: Text Table for Permitted Contract Types3REF_TYPESEPA Mandate: Contract Typenvarchar100
TOPPerformance Assessment Workbench
79KWPWNODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPPrice Planning Workbench
80WRF_PPW_PPDOSPPD Organization Set - Header4REF_TYPEReference Type of a Permanent Organization Setnvarchar300
TOPProfitability Analysis
81TKENODE01RGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPSAPscript
82TFORM01RSAPscript Form Tree: References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPService
83DVS1NODERGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPSession Manager
84TMENU01RGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
85TMENUBK01RGeneral Structure Storage References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPStructures Workbench
86/ISDFPS/MATSPPLNMaterials Planned for Force Element26REF_TYPEType of Reference Relationshipnvarchar20
TOPTalent Management
87T77TMCDELEMPRCAssignments of Dyn. Elements of Templates to Processes3REF_TYPEAppraisal Element - Reference Typenvarchar20
TOPTest Organizer
88TNODE02RTest Organizer, References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40
TOPWorkbench Utilities
89RLB_DB_TRRReuse Library: Structure Repository: References3REF_TYPEValid Reference Types in Structure Repositorynvarchar40