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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

43 columns | Print definition?ERP 6.0  | DEL_FLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/N_EVENTGBT Event12DEL_FLAGDeletion Flag of Database Entrynvarchar10
2/GBT/O_BAT_HDRBatch master - Header table19DEL_FLAGDeletion Flagnvarchar10
3/OTEI/T_ACT_DELCConfigure Activity Log delete options5DEL_FLAGEFM: Deletion Flagnvarchar10
4CNVTDMSBW_CLINDRList of cli-ind tables to be deleted in receiver6DEL_FLAGFlag to Indicate Non-Existencenvarchar10
5CNVTDMSBW_REQOBJRequests and objects between tdms ERP and BI10DEL_FLAGGeneral Flagnvarchar10
6CNVTDMSSCM_CLINDList of cli-ind tables to be deleted in receiver6DEL_FLAGFlag to Indicate Non-Existencenvarchar10
7CNV_20551HROBJIDHR object IDs (internally numbered) and deletion flag5DEL_FLAGDeletion indicator ( X = relevant for deletion)nvarchar10
8CNV_20551_APLNOIdentific. applicant number and relevance for deletion4DEL_FLAGDeletion indicator ( X = relevant for deletion)nvarchar10
9CNV_20551_PERNRIdentific. personnel areas and relevance for deletion4DEL_FLAGDeletion indicator ( X = relevant for deletion)nvarchar10
10CNV_20551_PERSAPersonnel areas (DEL_FLAG=X => relevant for deletion)4DEL_FLAGDeletion indicator ( X = relevant for deletion)nvarchar10
11HRAE_D_NOMINEESPromotion Nominees15DEL_FLAGData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
12J_1I_BANK_CHARGBank Charges8DEL_FLAGMarked For Deletionnvarchar10
13J_1I_BANK_SLABSMaintain Slabs for Bank Charges6DEL_FLAGMarked For Deletionnvarchar10
TOPArchiveLink
14TOAR7SAP ArchiveLink: Request table (asynchronous storage)17DEL_FLAGSAP ArchiveLink: Status flagnvarchar10
TOPAssortment
15WRF_APC_PABDPlanned Article Basic Data18DEL_FLAGPlanned Material Deletion Flag (OAPC)nvarchar10
TOPAssortment List
16WBB_SAVE1Save Changed Assortment List Objects Temporarily10DEL_FLAGIndicator: Generate Deletion Recordnvarchar10
TOPBasic Functions
17LFSSTNSustainability details for Vendor18DEL_FLAGCheckboxnvarchar10
TOPCross-Application Components
18/IXOS/DC_TCHIERHierarchy of a view21DEL_FLAGFlag for 'Deletion allowed'nvarchar10
TOPEasy Enhancement Workbench
19AXT_CAT_DICT_KEYCatalogue object dictionnary entry key8DEL_FLAGBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPEEW Generator
20GOX_TR_OBJECTSList of generated objects for transport8DEL_FLAGBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
21GOX_TR_TABKEYTable Keys for GOX Objects8DEL_FLAGBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPElectronic Data Interchange
22PRICAT_K003PRICAT: Catalog item basic data19DEL_FLAGFlag Material for Deletion at Client Levelnvarchar10
23PRICAT_K003_PROIndication of Data to be Adopted from PRICAT_K00317DEL_FLAGIndicator for copying catalog datanvarchar10
TOPHierarchy Storage
24TTREV_REFHierarchy tool: Versioning of Links7DEL_FLAGFlag with values ' ' and 'X'nvarchar10
TOPMaterial Master
25MGIR_SSTNMaterial / Info Record Sustainability table15DEL_FLAGCheckboxnvarchar10
TOPOffice Suite Program
26/OSP/T_REPMD5BKTOSP : Report MD5 Book Keeping Table6DEL_FLAGFlagnvarchar10
27/OSP/T_TEAMD5BKTOSP : Team Management MD5 Book Keeping Table7DEL_FLAGFlagnvarchar10
TOPPosition Management
28WBITAssociation Item at Step Level33DEL_FLAGGlobal Trade Deletion Indicatornvarchar10
TOPProduct Lifecycle Management
29DIWPS_CACharacteristics for Work Package9DEL_FLAGGeneral Flagnvarchar10
30DIWPS_RV_CARevision: Characteristics for Work Package9DEL_FLAGGeneral Flagnvarchar10
TOPSales
31/CBAD/CONTRACT_HAdvanced Order Processing and Billing: Header Data6DEL_FLAGDeletednvarchar10
32/CBAD/CONTRACT_IAdvanced Order Processing and Billing: Item Data6DEL_FLAGDeletednvarchar10
33/CBAD/CON_DBSAdvanced Order Processing and Billing: DBS Item Data10DEL_FLAGDeletednvarchar10
34/CBAD/CON_FUND_HAdvanced Order Processing and Billing: Fund Header Data10DEL_FLAGDeletednvarchar10
TOPSAP Multiresource Scheduling
35/MRSS/C_POT_SLAPMRS: SLA Priority3DEL_FLAGSLA Priority: Delete Flagnvarchar10
TOPTrading Contract
36WBGTGlobal Trade: Generic Document Information27DEL_FLAGGlobal Trade Deletion Indicatornvarchar10
TOPTranslation Tools
37LXE_PC_FIPCheck Sum10DEL_FLAGSingle-Character Indicatornvarchar10
38LXE_PC_FIP_ONEChecksum for Single Object10DEL_FLAGSingle-Character Indicatornvarchar10
TOPTransport Management System
39LISPARAMSLIS: Additional Parameters for Systems12DEL_FLAGGeneral Flagnvarchar10
TOPVisual Business
40VBCD_CNTXTModel context13DEL_FLAGDeletion Flagnvarchar10
41VBCD_DATA_OBJData Objects14DEL_FLAGDeletion Flagnvarchar10
42VBCD_MESSAGE_OBJMessage Objects11DEL_FLAGDeletion Flagnvarchar10
43VBCD_VISUAL_OBJVisual Objects12DEL_FLAGDeletion Flagnvarchar10