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

59 columns | Print definition?ERP 6.0  | ORG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1MMIM_PREDMM-IM Temporary Data6ORGSingle-Character Indicatornvarchar10
TOPABAP Authorization and Role Management
2USERS_ORGUser settings3ORGCustomized ('C') or standard menu ('S') flagnvarchar10
TOPAddress ManagementBusiness Address
3SADR8Address management: X.400 addresses10ORGAddresses: X.400 organizationnvarchar640
TOPControlling
4CRMC_SVORG_COService Organization2ORGService Organizationnvarchar140
5CRMC_SVORG_CO_TService Organization Texts2ORGService Organizationnvarchar140
TOPFinancials Basis
6UBC_TB_ACTAccount Assignment Fields for each Organizational Unit2ORGOrganizational Unitnvarchar100
7UBC_TB_ACTVValues for Account Assignment Fields2ORGOrganizational Unitnvarchar100
8UBC_TB_BIBatch Input Sessions2ORGOrganizational Unitnvarchar100
9UBC_TB_BILBiller for each Organizational Unit2ORGOrganizational Unitnvarchar100
10UBC_TB_BILDVALAccount Assignment Default Values on Level of Biller2ORGOrganizational Unitnvarchar100
11UBC_TB_CURMax./Min. Amounts per User and Currency2ORGOrganizational Unitnvarchar100
12UBC_TB_GUIDGUID for USER, ORG. WI_ID4ORGOrganizational Unitnvarchar100
13UBC_TB_INVHBill (Header)2ORGOrganizational Unitnvarchar100
14UBC_TB_INVHACTAccount Assignments on Bill Header2ORGOrganizational Unitnvarchar100
15UBC_TB_INVHMESBill: Messages from Inbound Processing2ORGOrganizational Unitnvarchar100
16UBC_TB_INVPBill Item2ORGOrganizational Unitnvarchar100
17UBC_TB_INVPACTAccount Assignments on Level of Item2ORGOrganizational Unitnvarchar100
18UBC_TB_NOTESTable for Notes2ORGOrganizational Unitnvarchar100
19UBC_TB_ORGOrganizational Units2ORGOrganizational Unitnvarchar100
20UBC_TB_ORGDVALAccount Assignment Default Values on Level of Biller2ORGOrganizational Unitnvarchar100
21UBC_TB_RAPermitted Bill Types for each Biller2ORGOrganizational Unitnvarchar100
22UBC_TB_RADVALAccount Assignment Default Values on Level of Bill Type2ORGOrganizational Unitnvarchar100
23UBC_TB_REJRejection Control2ORGOrganizational Unitnvarchar100
24UBC_TB_RPAPermitted Bill Item Types for each Biller2ORGOrganizational Unitnvarchar100
25UBC_TB_RPADVALAccount Assignment Default Values on Level of Bill Item Type2ORGOrganizational Unitnvarchar100
26UBC_TB_SAPFIField Assignments for Creating BI Sessions2ORGOrganizational Unitnvarchar100
27UBC_TB_SAPFI0Structure Assignment for Creation of BI Sessions2ORGOrganizational Unitnvarchar100
28UBC_TB_STRATStrategies for WF (Sequence of Processors)2ORGOrganizational Unitnvarchar100
29UBC_TB_STRATTStrategy Texts2ORGOrganizational Unitnvarchar100
30UBC_TB_STRUSRUser Sequence2ORGOrganizational Unitnvarchar100
31UBC_TB_USRUser per Organizational Unit2ORGOrganizational Unitnvarchar100
32UBC_TB_WFMLLast Mail Transmission for each Org2ORGOrganizational Unitnvarchar100
33UBC_TT_ACTTexts for Account Assignment Fields2ORGOrganizational Unitnvarchar100
34UBC_TT_ACTVTexts for Values of Account Assignment Fields2ORGOrganizational Unitnvarchar100
35UBC_TT_RABill Types (Texts)2ORGOrganizational Unitnvarchar100
36UBC_TT_RPABill Item Types (Texts)2ORGOrganizational Unitnvarchar100
TOPNon-Ferrous Metal enhancements
37/NFM/TABEINPermitted Different Coverage Customer3ORGOrganizational unit to which NF data refernvarchar40
38/NFM/TCOVHISCoverage History3ORGOrganizational unit to which NF data refernvarchar40
39/NFM/TCOVMASCoverage Master3ORGOrganizational unit to which NF data refernvarchar40
40/NFM/TDEF_DIFFDifferent Rate Determination2ORGSales Organizationnvarchar40
41/NFM/TKBBMovement Type s for NF Metal Provision3ORGOrganizational unit to which NF data refernvarchar40
42/NFM/TNEB_ORGDifferent Base Key on Organizational Level4ORGOrganizational unit to which NF data refernvarchar40
43/NFM/TNES_ORGDifferent NF Key Data on Organizational Level4ORGOrganizational unit to which NF data refernvarchar40
44/NFM/TNES_USEUse of NF Key4ORGOrganizational unit to which NF data refernvarchar40
45/NFM/TNFSRate Determination Key3ORGOrganizational unit to which NF data refernvarchar40
46/NFM/TNFSTXRate Determination Key - Texts4ORGOrganizational unit to which NF data refernvarchar40
47/NFM/TNFS_FIELDField Control for NF Rate Determination Key3ORGOrganizational unit to which NF data refernvarchar40
48/NFM/TPROVHISProvision: History3ORGOrganizational unit to which NF data refernvarchar40
49/NFM/TPROVLIFProvision Master: Vendor3ORGOrganizational unit to which NF data refernvarchar40
50/NFM/TPROVMASProvision Master3ORGOrganizational unit to which NF data refernvarchar40
51/NFM/TPROVMOVProvision: Goods Movement7ORGOrganizational unit to which NF data refernvarchar40
52/NFM/TRATESRate Table4ORGOrganizational unit to which NF data refernvarchar40
53/NFM/TRATESPROVRate Table of Providers3ORGOrganizational unit to which NF data refernvarchar40
54/NFM/TVGWNFK Charge Weights for Materials on Organizational Level5ORGOrganizational unit to which NF data refernvarchar40
55/NFM/TVGW_TMPFile for Incorrect Data in Direct Input8ORGOrganizational unit to which NF data refernvarchar40
TOPProduct Cost Planning
56TCWB_IN_OUTUmschlüsselung von Input-Werten6ORGnvarchar10
57TNAMECHANGENamensersetzung: Umschlüsselung7ORGnvarchar10
TOPProject System
58PSHLP_DRAFT_DBTable holds Draft Workbench Information14ORGOrganizational Data in Draftsnvarchar10
59PSHLP_DRAFT_DB_NTable holds Draft Workbench Information14ORGOrganizational Data in Draftsnvarchar10