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

44 columns | Print definition?ERP 6.0  | LOCKED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/ANALYSISSLOAP analysis data10LOCKEDSLOAS Lockednvarchar10
2/SLOAP/PLATTFORMSLOAP Plattfom lock against generation2LOCKEDSLOAS Lockednvarchar10
3CNVCMIS_A_1_COMPRepository information about 'components of 'CLAS'14LOCKEDIndicator is locked and cannot be changednvarchar10
4CNVCMIS_A_1_COSUsub compunents for clas30LOCKEDIndicator is locked and cannot be changednvarchar10
5CNVLTHCM_MIGSCENLT HCM: Migration Scenario5LOCKEDModifier of control datanvarchar400
6CNVLTHCM_RCVINFOLT HCM: Information about Receiver System6LOCKEDModifier of control datanvarchar400
7CNVMBTDESTinfo.about dest. of sender/receiver/central system8LOCKEDnvarchar10
8GRACROLERole14LOCKEDIndicatornvarchar10
9GRACUSERATTEMPTNumber of Attempt4LOCKEDActive indicatornvarchar10
10PPHMRPPPLOGMRP Live Postprocessing Log Header11LOCKEDnvarchar10
11SRM_USR01Internet User Data9LOCKEDGeneral Flagnvarchar10
12ZSKSYSUSERuser in den IDES-Systemen9LOCKEDnvarchar10
13ZSKUSERID3user im id3 fuers training4LOCKEDEinstelliges Kennzeichennvarchar10
14ZTARGET_PARTNERGSystem Landscapes: Header Data11LOCKEDLog-on Status for Landscapenvarchar10
TOPAccounting - General
15TFC_INST_ITEMAdministration of a Job (Report/Transaction or Workflow)20LOCKEDTask Completednvarchar10
16TFC_INST_ORGOrganizational Structure: Fast Close10LOCKEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
17TFC_TEMPL_ITEMAdministration of a Job (Report/Transaction or Workflow)20LOCKEDTask Completednvarchar10
18TFC_TEMPL_ORGOrganizational Structure: Fast Close10LOCKEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPAssortment
19WRF_APC_PLASPurchasing List Assigned Quantities9LOCKEDIndicates that the Assignment Cannot Be Modifiednvarchar10
20WRF_APC_PPCMPPlanned Article Prepack Components6LOCKEDIndicates that the Prepack Component Cannot Be Modifiednvarchar10
TOPClass Builder
21SEOCOMPODFDefinition class/interface component9LOCKEDIndicator is locked and cannot be changednvarchar10
22SEOSUBCODFDefinition class/interface subcomponent6LOCKEDIndicator is locked and cannot be changednvarchar10
TOPContract Accounts Receivable and Payable
23IST_TDATATelco Object Data for Contract A/R & A/P10LOCKEDLocked Indicatornvarchar10
TOPCross-Application Components
24FRE_IF_CONTRACTInterface Table for Contracts Data24LOCKEDItem Lockednvarchar10
TOPDistribution Unit Distribution Packet
25DELIVERYReplication Table9LOCKEDCheckboxnvarchar10
26UPSHDRALE Distribution Unit: Header Data17LOCKEDALE Distribution Package: Change Locknvarchar10
TOPFunds Management
27FM01UDSettings for revenues increasing the budget48LOCKEDRevenues Increasing the Budget are Blockednvarchar10
TOPMove-InOut
28ECAMIOPRHEADIS-U: Parked Document: Header Data6LOCKEDIndicator: Parked Document is Lockednvarchar10
TOPOLAP Technology
29RSDDTZA_ACT_RUNBWA Action Currently Executed from BWA Monitor1LOCKEDLock Type for BWA Actionsnvarchar10
30RSDDTZA_LOCKLock Table for BWA Actions1LOCKEDLock Type for BWA Actionsnvarchar10
TOPOrganizational Management
31HRP1217Infotype 1217 DB Table19LOCKEDLock Indicator: Locked for Instantiationnvarchar10
TOPPatient Management
32NPGZIS-H: Assignment of Patient to Business Partner12LOCKEDIS-H: Block Physician-to-Patient Assignmentnvarchar10
TOPRevenues and Earnings
33VPKDLISales Pricing Dynamic Items4LOCKEDElement locked or notnvarchar10
TOPSAP Records Management
34SRMSTATUSSRM Status10LOCKEDSRM: Object Lockednvarchar10
TOPSAP Utilities
35EUFASSAllocation of Usage Factor to any BOR Objects9LOCKEDLocked or inactivenvarchar10
36EUFASS_HISTTable of Usage Factor Applied to a Load Profile (History)8LOCKEDLocked or inactivenvarchar10
TOPService Data Download
37/SDF/CLI_TRCTable for storing BusinessTransaction.xml4LOCKEDSingle-Character Indicatornvarchar10
TOPSolution Directory
38SDTSRULEDTS: Recurrence Rules for Downtimes4LOCKEDGeneral Flagnvarchar10
TOPSyntax, Compiler, Runtime
39ICONIcons table10LOCKEDLocked iconsnvarchar10
TOPTest Organizer
40TNODE02ATest Organizer, Test Catalog, Plan, Package Attributes13LOCKEDFlag with values ' ' and 'X'nvarchar10
TOPTranslation Tools
41INDPROTShort Text Conversion: Log8LOCKEDSingle-Character Indicatornvarchar10
42LXE_INEWS(LXE) SE63 InfoNews Control Table8LOCKEDnvarchar10
TOPTransportation Planning
43/DSD/RP_TOPTour Master, Item Data12LOCKEDTour Blockednvarchar10
TOPWeb Service Tools - ABAP
44VEPHEADERVirtual End Point Definition: Administrative Data11LOCKEDSingle-Character Indicatornvarchar10