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

50 columns | Print definition?ERP 6.0  | CHUSR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BSNAGT/FILE_INFFile Status Information14CHUSRUser Namenvarchar120
2BKK_OPD_IT_EXTExternal Item Selection Table - Outgoing Payment Dispatcher49CHUSRLast user to change objectnvarchar120
3CNVMBTCLUSTTABCluster tables DDIC for de-clustered systems3CHUSRUser Namenvarchar120
TOPAccount Management
4BKK42_NTCMaster Data for Notice and Allowances19CHUSRLast user to change objectnvarchar120
5BKKNTCNotice: Partial Amount and Full Amount Notice20CHUSRLast user to change objectnvarchar120
TOPBank Customer Accounts
6BKK58Master Data Savings Prod: Fxd-Term Deposit, Installmnt Savgs24CHUSRLast user to change objectnvarchar120
7BKKCORRITEMAuxiliary Table: Payment Items for Adjustments94CHUSRLast user to change objectnvarchar120
8BKKSOBCA: Standing Orders39CHUSRLast user to change objectnvarchar120
9BKK_PRENOTEPrenotes40CHUSRLast user to change objectnvarchar120
10NIHC_DB_PO_PNTASource Document for Incoming Payment Orders45CHUSRUser that created or changed the objectnvarchar120
11TBKKCORRBCA: Table showing if Correspondence is Active6CHUSRLast user to change objectnvarchar120
TOPBusiness Partner
12BPOBTABPartner-Object Relationship16CHUSRLast user to change objectnvarchar120
TOPContract Accounts Receivable and Payable
13DFKK_BL_BPLocked Business Partners from GTS5CHUSRLast user to change objectnvarchar120
14DFKK_EMBARGOEmbargo Countries from GTS3CHUSRLast user to change objectnvarchar120
15DFKK_EMBARGO2Embargo Countries From - To from GTS4CHUSRLast user to change objectnvarchar120
TOPFinancial Supply Chain Management
16BNK_BATCH_HEADERBatch Header20CHUSRChange Usernvarchar120
TOPFSCM In-House Cash
17IHC_DB_PNSource Document for Incoming Payment Orders91CHUSRChanged Bynvarchar120
TOPGeneric Contract Accounts Receivable and Payable
18BCA_DIM_CALCDETCalculation details for billing items22CHUSRLast Changed bynvarchar120
TOPGL transfer
19BKKC01Gen.Ledger: Reconciliation Key Accounting Documents12CHUSRLast user to change objectnvarchar120
20BKKCNOITGLTable of Items not Updated on the Account42CHUSRLast user to change objectnvarchar120
21BKKCVAAdministration Table Individual Value Adjustment13CHUSRLast user to change objectnvarchar120
TOPIncentive and Commission Management ICM
22TCACS_AUT05Commissions: Assignment of Users to Authorization Group5CHUSRLast user to change objectnvarchar120
TOPMaster Data
23BCA_US_HLD2RELHold Records which have not been released - Dual Control26CHUSRLast user to change objectnvarchar120
24BCA_US_HOLDHold Amounts Which Affect Available Balance25CHUSRLast user to change objectnvarchar120
TOPPayment Item
25BKKITPayment Item94CHUSRLast user to change objectnvarchar120
26BKKITAIInfo Items for Interest Penalty at Balancing27CHUSRLast user to change objectnvarchar120
27BKKITENQBlocked Payment Items94CHUSRLast user to change objectnvarchar120
28BKKITRELPayment Item94CHUSRLast user to change objectnvarchar120
29BKKITTMPPlanned Payment Items95CHUSRLast user to change objectnvarchar120
30BKKITTMP_DELPlanned Payment Items - Completed95CHUSRLast user to change objectnvarchar120
TOPPayment Order
31BKKPOHDPayment Order, Header Data33CHUSRLast user to change objectnvarchar120
32BKKPOHD_TMPPlanned Payment Order, Header Data34CHUSRLast user to change objectnvarchar120
33BKKPOHD_TMP_DELPlanned Payment Order, Header Data34CHUSRLast user to change objectnvarchar120
TOPReal Estate Management
34BPOBIMMOBusiness Partner - Object Relationship: Real Estate27CHUSRLast user to change objectnvarchar120
TOPStakeholder Relationship Management
35USC_CONTACTSRM Contact: Central Storage of Contacts17CHUSRLast user to change objectnvarchar120
36USC_CONT_DOCSRM Contact: Documents11CHUSRLast user to change objectnvarchar120
37USC_CONT_KWDSRM Contact: Keywords8CHUSRLast user to change objectnvarchar120
38USC_CONT_RELSRM Contact: Related Contacts8CHUSRLast user to change objectnvarchar120
39USC_CONT_STHSRM Contact: Stakeholders14CHUSRLast user to change objectnvarchar120
40USS_STAKEHOLDERSEM-SRM: Specific Master Data of Stakeholder12CHUSRLast user to change objectnvarchar120
41USS_STH_COVERSEM-SRM: Relationship Stakeholder and Coverage8CHUSRLast user to change objectnvarchar120
42USS_STH_EXPECTSEM-SRM: Expectations of Stakeholders18CHUSRLast user to change objectnvarchar120
43USS_STH_INFLSEM-SRM: Influence of Stakeholders13CHUSRLast user to change objectnvarchar120
44USS_STH_SHARESEM-SRM: Shares of Stakeholders12CHUSRLast user to change objectnvarchar120
45USS_STH_STH_GRPSEM-SRM: Group of Stakeholders11CHUSRLast user to change objectnvarchar120
TOPUse AP-MD-BP Components
46BUT000BP: General data I79CHUSRLast user to change objectnvarchar120
47BUT000_TDBP: General Data I, Shadow Table Time Dependency80CHUSRLast user to change objectnvarchar120
48BUT000_TDSBP: General Data I, Shadow Table Time Dependency81CHUSRLast user to change objectnvarchar120
49BUT050BP relationships/role definitions: General data15CHUSRLast user to change objectnvarchar120
50BUT050SBP Relationships/Role Definitions: General Data16CHUSRLast user to change objectnvarchar120