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

95 columns | Print definition?ERP 6.0  | NODE_CAT_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_PFP_ANCHAnchor4NODE_CAT_KEYNodeIDvarbinary160
2/CPD/D_PFP_MSMapped Structure5NODE_CAT_KEYNodeIDvarbinary160
3/IAM/D_ACT_ATTAttachment of Activities4NODE_CAT_KEYNodeIDvarbinary160
4/IAM/D_ACT_DATEDate4NODE_CAT_KEYNodeIDvarbinary160
5/IAM/D_ACT_DESCDescription4NODE_CAT_KEYNodeIDvarbinary160
6/IAM/D_ACT_DTXTDescription Text5NODE_CAT_KEYNodeIDvarbinary160
7/IAM/D_ACT_FOAFollow Up Action4NODE_CAT_KEYNodeIDvarbinary160
8/IAM/D_ACT_FOA_PFollow Up Action Parameter5NODE_CAT_KEYNodeIDvarbinary160
9/IAM/D_ACT_OBJRFObject reference4NODE_CAT_KEYNodeIDvarbinary160
10/IAM/D_ACT_OR_DTLanguage dependant description texts5NODE_CAT_KEYNodeIDvarbinary160
11/IAM/D_ACT_PARTYParty4NODE_CAT_KEYNodeIDvarbinary160
12/IAM/D_ACT_QTYActivity Quantity4NODE_CAT_KEYNodeIDvarbinary160
13/IAM/D_ACT_ROOTRoot3NODE_CAT_KEYNodeIDvarbinary160
14/IAM/D_I_ATTAttachment4NODE_CAT_KEYNodeIDvarbinary160
15/IAM/D_I_DATEDate4NODE_CAT_KEYNodeIDvarbinary160
16/IAM/D_I_DESCDescription node DB table4NODE_CAT_KEYNodeIDvarbinary160
17/IAM/D_I_DESC_TXLanguage dependant description texts node DB table5NODE_CAT_KEYNodeIDvarbinary160
18/IAM/D_I_OBJ_REFIssue reference node DB table4NODE_CAT_KEYNodeIDvarbinary160
19/IAM/D_I_OREF_DTLanguage dependant reference desc. texts node DB table5NODE_CAT_KEYNodeIDvarbinary160
20/IAM/D_I_PARTYParty node DB table4NODE_CAT_KEYNodeIDvarbinary160
21/IAM/D_I_QTYQuantity4NODE_CAT_KEYNodeIDvarbinary160
22/IAM/D_I_ROOTRoot node DB table3NODE_CAT_KEYNodeIDvarbinary160
23/IAM/D_NF_COND/IAM/NOTIFIER Condition4NODE_CAT_KEYNodeIDvarbinary160
24/IAM/D_NF_DESC/IAM/NOTIFIER Description4NODE_CAT_KEYNodeIDvarbinary160
25/IAM/D_NF_RECIP/IAM/NOTIFIER Recipient4NODE_CAT_KEYNodeIDvarbinary160
26/IAM/D_NF_ROOT/IAM/NOTIFIER Root3NODE_CAT_KEYNodeIDvarbinary160
27EHFNDD_LISU_GRPRListed Substance Group Relation4NODE_CAT_KEYNodeIDvarbinary160
28EHFNDD_LISU_NAMEListed Substance Name4NODE_CAT_KEYNodeIDvarbinary160
29EHFNDD_LISU_ROOTListed Substance3NODE_CAT_KEYNodeIDvarbinary160
30EHFNDD_LISU_SUBRSubstance Relation4NODE_CAT_KEYNodeIDvarbinary160
31EHFNDD_REGL_EXEMExemption List4NODE_CAT_KEYNodeIDvarbinary160
32EHFNDD_REGL_EXSRList of Exemptions for Substance5NODE_CAT_KEYNodeIDvarbinary160
33EHFNDD_REGL_PCDSDeclarable Substance4NODE_CAT_KEYNodeIDvarbinary160
34EHFNDD_REGL_ROOTRegulatory List Revision3NODE_CAT_KEYNodeIDvarbinary160
35EHFNDD_RL_C_LSGRResult of compared 'assigned group subs'4NODE_CAT_KEYNodeIDvarbinary160
36EHPRCD_BBT_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160
37EHPRCD_PBB_ATTHolding additional info for WF Attachmen4NODE_CAT_KEYNodeIDvarbinary160
38EHPRCD_PBB_BM_RQRequested BiOMs5NODE_CAT_KEYNodeIDvarbinary160
39EHPRCD_PBB_CR_RQRequested + ass. relevant Comp. Requirem5NODE_CAT_KEYNodeIDvarbinary160
40EHPRCD_PBB_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160
41EHPRCD_PBB_RQCompliance Request4NODE_CAT_KEYNodeIDvarbinary160
42EHPRCD_PBB_TRSFProcess Control - BomBos Transfer4NODE_CAT_KEYNodeIDvarbinary160
43EHPRCD_PCR_ATTAHolding additional info for WF Attachmen4NODE_CAT_KEYNodeIDvarbinary160
44EHPRCD_PCR_CDOAggregated CDO Info4NODE_CAT_KEYNodeIDvarbinary160
45EHPRCD_PCR_COMPLCompliance Check Result4NODE_CAT_KEYNodeIDvarbinary160
46EHPRCD_PCR_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160
47EHPRCD_PSA_ATTAHolding additional info for WF Attachmen4NODE_CAT_KEYNodeIDvarbinary160
48EHPRCD_PSA_MAILReceived E-Mail4NODE_CAT_KEYNodeIDvarbinary160
49EHPRCD_PSA_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160
50EHPRCD_PSI_ATTAHolding additional info for WF Attachmen4NODE_CAT_KEYNodeIDvarbinary160
51EHPRCD_PSI_COMMCommunication Definition Settings4NODE_CAT_KEYNodeIDvarbinary160
52EHPRCD_PSI_INQUIProcess Control - Inquiry4NODE_CAT_KEYNodeIDvarbinary160
53EHPRCD_PSI_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160
54/BOBF/ACT_CONFBOPF Configuration: Assignment of Action to a Node Category7NODE_CAT_KEYNode Categoryvarbinary160
55/BOBF/DET_CONFBOPF Configuration: Execution times of determinations8NODE_CAT_KEYNode Categoryvarbinary160
56/BOBF/OBM_ASSOCCBOPF Configuration: Node Category assignment to associations7NODE_CAT_KEYNode Categoryvarbinary160
57/BOBF/OBM_NCATBOPF Configuration: Node Category4NODE_CAT_KEYNode Categoryvarbinary160
58/BOBF/OBM_NCATTBOPF Configuration: Text Table for /BOPF/OBM_NCAT5NODE_CAT_KEYNode Categoryvarbinary160
59/BOBF/OBM_NODEBOPF Configuration: Node21NODE_CAT_KEYStandard Node Categoryvarbinary160
60/BOBF/OBM_PROPTYBOPF Configuration: Static Properties7NODE_CAT_KEYNode Categoryvarbinary160
61/BOBF/VAL_CONFBOPF Configuration: Assignment of Validations to Actions8NODE_CAT_KEYNode Categoryvarbinary160
TOPBusiness Objects, Common Components
62EHFNDD_PAM_AMTSSpecific Data for Amounts4NODE_CAT_KEYNodeIDvarbinary160
63EHFNDD_PAM_ATTStorage for Additional WF Attachment Info4NODE_CAT_KEYNodeIDvarbinary160
64EHFNDD_PAM_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160
TOPData Replication Framework
65DRFD_APPL_FILT_CFilterCriteria5NODE_CAT_KEYNodeIDvarbinary160
66DRFD_APPL_FILT_HData Replication Filter Root Node4NODE_CAT_KEYNodeIDvarbinary160
TOPReusable Components of Business Suite Foundation
67/BOBF/DM_CST_HDRCustomer Header3NODE_CAT_KEYNodeIDvarbinary160
68/BOBF/DM_CST_HDTCustomer Header Text4NODE_CAT_KEYNodeIDvarbinary160
69/BOBF/DM_LTXT_CLong Text Content4NODE_CAT_KEYNodeIDvarbinary160
70/BOBF/DM_LTXT_RTHeader Text Collection3NODE_CAT_KEYNodeIDvarbinary160
71/BOBF/DM_PRD_HDRProduct Header (Demo)3NODE_CAT_KEYNodeIDvarbinary160
72/BOBF/DM_PRD_HDTHeader Text4NODE_CAT_KEYNodeIDvarbinary160
73/BOBF/DM_SORDITTItem Texts5NODE_CAT_KEYNodeIDvarbinary160
74/BOBF/DM_SORDRTTHeader Text4NODE_CAT_KEYNodeIDvarbinary160
75/BOBF/DM_SORD_ITSales Order Item4NODE_CAT_KEYNodeIDvarbinary160
76/BOBF/DM_SORD_RTSales Order Header3NODE_CAT_KEYNodeIDvarbinary160
77/BOBF/DT_ATFHeader Attachment folder test3NODE_CAT_KEYNodeIDvarbinary160
78/BOBF/D_ATF_DODocument node of the AttachmentFolder4NODE_CAT_KEYNodeIDvarbinary160
79/BOBF/D_TXCCONTextContent5NODE_CAT_KEYNodeIDvarbinary160
80/BOBF/D_TXCTXTText4NODE_CAT_KEYNodeIDvarbinary160
81/BOFU/DDMOCUST_HDemo Customer Header3NODE_CAT_KEYNodeIDvarbinary160
82/BOFU/DDMOCUST_TDemo Customer Header Text4NODE_CAT_KEYNodeIDvarbinary160
83/BOFU/DDMOSORDHDSales Order Header3NODE_CAT_KEYNodeIDvarbinary160
84/BOFU/DDMOSORDITSales Order Item4NODE_CAT_KEYNodeIDvarbinary160
85/BOFU/DDMPARTYN1Party Node4NODE_CAT_KEYNodeIDvarbinary160
86/BOFU/DM_PRD_HDRHeader3NODE_CAT_KEYNodeIDvarbinary160
87/BOFU/DM_PRD_HDTHeader Text4NODE_CAT_KEYNodeIDvarbinary160
88/BOFU/TEST_ADMINAdmin Data3NODE_CAT_KEYNodeIDvarbinary160
TOPSelf-Service Procurement
89/SRMERP/D_SC_ITMShopping Cart Item4NODE_CAT_KEYNodeIDvarbinary160
TOPWorkflows and Tasks for Risk Assessment
90EHHSSD_PRR_ATTStorage of Additional WF Attachment Info4NODE_CAT_KEYNodeIDvarbinary160
91EHHSSD_PRR_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160
92EHHSSD_PRS_RPTProcess Control - Report4NODE_CAT_KEYNodeIDvarbinary160
93EHHSSD_PRT_APPProcess Control - Approval4NODE_CAT_KEYNodeIDvarbinary160
94EHHSSD_PRT_ATTStorage of Additional WF Attachment Info4NODE_CAT_KEYNodeIDvarbinary160
95EHHSSD_PRT_ROOTProcess Control - Root3NODE_CAT_KEYNodeIDvarbinary160