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

69 columns | Print definition?ERP 6.0  | CRUSR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BSNAGT/FILE_INFFile Status Information11CRUSRUser Namenvarchar120
2BKK_OPD_IT_EXTExternal Item Selection Table - Outgoing Payment Dispatcher46CRUSRUser who created the objectnvarchar120
3BKK_SEPA_LIM_EVEvent Table for Mandate Limits17CRUSRUser Who Created Events for Mandate Limitsnvarchar120
4BKK_SEPA_LIM_HISHistory Table for Mandate Limits18CRUSRUser Who Created Events for Mandate Limitsnvarchar120
5CNVLTHCM_STATUSStatus of Path Determination7CRUSRCreated bynvarchar120
6CNV_10020_ACTActions - Header data11CRUSRCreated bynvarchar120
7CNV_10020_CDOBJHCondition objects: Header data10CRUSRCreated bynvarchar120
8CNV_10020_CFOBJHConcatenated/fragmented objects: Header data11CRUSRCreated bynvarchar120
9CNV_10020_CONDConditions - Header data11CRUSRCreated bynvarchar120
10CNV_10020_DTFLDAssignment of determination to tables and fields24CRUSRCreated bynvarchar120
11CNV_10020_DTOBJHDetermination objects12CRUSRCreated bynvarchar120
12CNV_10020_FVOBJFixed value objects12CRUSRCreated bynvarchar120
13CNV_10020_PATHDetermination paths: Header data27CRUSRCreated bynvarchar120
14CNV_10020_RCOMPAssignment of rules to non-transp. field components15CRUSRCreated bynvarchar120
15CNV_10020_RDTOBJAssignment of rules to determination object components15CRUSRCreated bynvarchar120
16CNV_10020_RULERules - Header data10CRUSRCreated bynvarchar120
17CNV_10020_VLISTValue lists - Header data11CRUSRCreated bynvarchar120
18SEPA_CI_PROCSEPA CI Limits and CI Whitelist11CRUSRUser Namenvarchar120
19SEPA_CI_PROC_HISSEPA CI Limits and CI Whitelist12CRUSRUser Namenvarchar120
TOPAccount Management
20BKK42_NTCMaster Data for Notice and Allowances16CRUSRUser who created the objectnvarchar120
21BKKNTCNotice: Partial Amount and Full Amount Notice17CRUSRUser who created the objectnvarchar120
TOPBank Customer Accounts
22BKK58Master Data Savings Prod: Fxd-Term Deposit, Installmnt Savgs21CRUSRUser who created the objectnvarchar120
23BKKCORRITEMAuxiliary Table: Payment Items for Adjustments91CRUSRUser who created the objectnvarchar120
24BKKSOBCA: Standing Orders36CRUSRUser who created the objectnvarchar120
25BKK_PRENOTEPrenotes37CRUSRUser who created the objectnvarchar120
26NIHC_DB_PO_PNTASource Document for Incoming Payment Orders41CRUSRUser that created or changed the objectnvarchar120
27NIHC_DB_PO_STATStatus of Payment Order7CRUSRUser that created or changed the objectnvarchar120
28TBKKCORRBCA: Table showing if Correspondence is Active3CRUSRUser who created the objectnvarchar120
TOPBusiness Partner
29BPOBTABPartner-Object Relationship13CRUSRUser who created the objectnvarchar120
TOPFinancial Supply Chain Management
30BNK_BATCH_HEADERBatch Header17CRUSRCreate Usernvarchar120
31BNK_BTCH_STREFStatus reference8CRUSRCreate Usernvarchar120
32BNK_XSTAT_MSGExternal Status Message6CRUSRCreate Usernvarchar120
TOPFSCM In-House Cash
33IHC_DB_PNSource Document for Incoming Payment Orders87CRUSRCreated Bynvarchar120
34IHC_DB_PN_STATUSIHC: Payment Order Status13CRUSRUser that created or changed the objectnvarchar120
TOPGeneric Contract Accounts Receivable and Payable
35BCA_DIM_CALCDETCalculation details for billing items20CRUSRCreated Bynvarchar120
TOPGL transfer
36BKKC01Gen.Ledger: Reconciliation Key Accounting Documents11CRUSRUser who created the objectnvarchar120
37BKKCNOITGLTable of Items not Updated on the Account39CRUSRUser who created the objectnvarchar120
38BKKCVAAdministration Table Individual Value Adjustment10CRUSRUser who created the objectnvarchar120
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
39TFACDFactory calendar definition15CRUSRCalendar: Calendar creator/changernvarchar120
40THOCIPublic holiday calendar index5CRUSRCalendar: Calendar creator/changernvarchar120
TOPMaster Data
41BCA_US_HLD2RELHold Records which have not been released - Dual Control23CRUSRUser who created the objectnvarchar120
42BCA_US_HOLDHold Amounts Which Affect Available Balance22CRUSRUser who created the objectnvarchar120
TOPPayment Item
43BKKITPayment Item91CRUSRUser who created the objectnvarchar120
44BKKITAIInfo Items for Interest Penalty at Balancing24CRUSRUser who created the objectnvarchar120
45BKKITENQBlocked Payment Items91CRUSRUser who created the objectnvarchar120
46BKKITRELPayment Item91CRUSRUser who created the objectnvarchar120
47BKKITTMPPlanned Payment Items92CRUSRUser who created the objectnvarchar120
48BKKITTMP_DELPlanned Payment Items - Completed92CRUSRUser who created the objectnvarchar120
TOPPayment Order
49BKKPOHDPayment Order, Header Data30CRUSRUser who created the objectnvarchar120
50BKKPOHD_TMPPlanned Payment Order, Header Data31CRUSRUser who created the objectnvarchar120
51BKKPOHD_TMP_DELPlanned Payment Order, Header Data31CRUSRUser who created the objectnvarchar120
TOPPublic Sector Contract Accounts Receivable and Payable
52FMOPBLDocument Reference IS-PS <=> IS-PS-CA6CRUSRUser who created the objectnvarchar120
TOPReal Estate Management
53BPOBIMMOBusiness Partner - Object Relationship: Real Estate24CRUSRUser who created the objectnvarchar120
TOPStakeholder Relationship Management
54USC_CONTACTSRM Contact: Central Storage of Contacts14CRUSRUser who created the objectnvarchar120
55USC_CONT_DOCSRM Contact: Documents8CRUSRUser who created the objectnvarchar120
56USC_CONT_KWDSRM Contact: Keywords5CRUSRUser who created the objectnvarchar120
57USC_CONT_RELSRM Contact: Related Contacts5CRUSRUser who created the objectnvarchar120
58USC_CONT_STHSRM Contact: Stakeholders11CRUSRUser who created the objectnvarchar120
59USS_STAKEHOLDERSEM-SRM: Specific Master Data of Stakeholder9CRUSRUser who created the objectnvarchar120
60USS_STH_COVERSEM-SRM: Relationship Stakeholder and Coverage5CRUSRUser who created the objectnvarchar120
61USS_STH_EXPECTSEM-SRM: Expectations of Stakeholders15CRUSRUser who created the objectnvarchar120
62USS_STH_INFLSEM-SRM: Influence of Stakeholders10CRUSRUser who created the objectnvarchar120
63USS_STH_SHARESEM-SRM: Shares of Stakeholders9CRUSRUser who created the objectnvarchar120
64USS_STH_STH_GRPSEM-SRM: Group of Stakeholders8CRUSRUser who created the objectnvarchar120
TOPUse AP-MD-BP Components
65BUT000BP: General data I76CRUSRUser who created the objectnvarchar120
66BUT000_TDBP: General Data I, Shadow Table Time Dependency77CRUSRUser who created the objectnvarchar120
67BUT000_TDSBP: General Data I, Shadow Table Time Dependency78CRUSRUser who created the objectnvarchar120
68BUT050BP relationships/role definitions: General data12CRUSRUser who created the objectnvarchar120
69BUT050SBP Relationships/Role Definitions: General Data13CRUSRUser who created the objectnvarchar120