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

Home | ERP 6.0  | QAM_L_BCV_I
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
1ERP EHP76.0QAM_L_BCV_I631QIM: Temporary Storage Issues for Business Context Viewer
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CLIENT, USERNAME, BCV_QI_ID, QI_ID, CATEGORY, LOGSYS, CATEG_LOGSYS, CATEGORY_TEXT, MATERIAL, CUSTOMER, VENDOR, QI_TYPE, CODE, CODE_TEXT, START_DATE, END_DATE, PARENT_QI_ID, QI_PARENT_UUID, QI_UUID, STATUS, PERSON_RESPONSIBLE, CREATED_ON, CREATED_BY, DIGSIG_STATUS, PARTNER_ROLE, PARTNER, USER_STATUS_01, RESPONSIBLE_TEXT, ISSUE_TEXT, ISSUE_LTEXT_IND, VALUATE_ISSUE, TRAF_LIGHT_CNTRL, TRAF_LIGHT_INDEX, DIGSIG_STAT_ICON, DIGSIG_BUS_TRANS, LOCAL_QI_TYPE_ID_IND, QI_TYPE_TEXT, OPEN_ACTS, LOCAL_QI_CODE_ID_IND, LOCAL_MATERIAL_ID_IND, MATERIAL_TEXT, MORE_THAN_ONE_MAT_IND, LOCAL_CUSTOMER_ID_IND, CUSTOMER_TEXT, MORE_THAN_ONE_CUST_IND, LOCAL_VENDOR_ID_IND, VENDOR_TEXT, MORE_THAN_ONE_VEND_IND, PLANT, PLANT_TEXT, COMPLAINT_QUAN, COMPLAINT_QUNIT, PRIORITY, PRIORITY_TEXT, LOCAL_EQUIPMENT_ID_IND, EQUIPMENT, EQUIPMENT_TEXT, FUNC_LOCATION, FUNC_LOCATION_TEXT, LOCAL_FUNCTLOCATION_IND, WBS_ELEMENT, WBS_TEXT, USER_STATUS_COMBINED_DESCR FROM QAM_L_BCV_I
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CLIENTClientnvarchar30 Allow NULL? 
2USERNAMEUser Namenvarchar120 Allow NULL? 
3BCV_QI_IDBCV Entry IDnvarchar240 Allow NULL? 
4QI_IDQuality Issue IDnvarchar240 Allow NULL? 
5CATEGORYObject Categorynvarchar100 Allow NULL? 
6LOGSYSLogical Systemnvarchar100 Allow NULL? 
7CATEG_LOGSYSCombination of Category and Source Systemnvarchar210 Allow NULL? 
8CATEGORY_TEXTCategory Textnvarchar400 Allow NULL? 
9MATERIALMaterialnvarchar400 Allow NULL? 
10CUSTOMERCustomernvarchar100 Allow NULL? 
11VENDORVendornvarchar100 Allow NULL? 
12QI_TYPEQuality Issue Typenvarchar30 Allow NULL? 
13CODEQuality Issue Codenvarchar150 Allow NULL? 
14CODE_TEXTCode Textnvarchar800 Allow NULL? 
15START_DATERequested Start Datenvarchar80 Allow NULL? 
16END_DATERequested End Datenvarchar80 Allow NULL? 
17PARENT_QI_IDID of Parent Quality Issuenvarchar240 Allow NULL? 
18QI_PARENT_UUIDUUID for ID of Parent Quality Issuevarbinary160
19QI_UUIDUUID for Issue/Activity IDvarbinary160
20STATUSIssue Statusnvarchar30 Allow NULL? 
21PERSON_RESPONSIBLEPerson Responsiblenvarchar120 Allow NULL? 
22CREATED_ONCreated Onnvarchar80 Allow NULL? 
23CREATED_BYCreated Bynvarchar120 Allow NULL? 
24DIGSIG_STATUSStatus Text for Digital Signaturenvarchar20 Allow NULL? 
25PARTNER_ROLEPartner Rolenvarchar80 Allow NULL? 
26PARTNERPartnernvarchar120 Allow NULL? 
27USER_STATUS_01User Status 1 for Issuenvarchar20 Allow NULL? 
28RESPONSIBLE_TEXTName of Person Responsiblenvarchar800 Allow NULL? 
29ISSUE_TEXTQuality Issue Textnvarchar400 Allow NULL? 
30ISSUE_LTEXT_INDDetailed Description Available Indicatorchar10 Allow NULL? 
31VALUATE_ISSUEFilter for Monitoring Control of Issuesnvarchar30 Allow NULL? 
32TRAF_LIGHT_CNTRLTraffic Lightnvarchar200 Allow NULL? 
33TRAF_LIGHT_INDEXSort Number for Traffic Light Controlnvarchar40 Allow NULL? 
34DIGSIG_STAT_ICONStatus Icon for Digital Signaturenvarchar240 Allow NULL? 
35DIGSIG_BUS_TRANSBusiness Transaction for Digital Signaturenvarchar400 Allow NULL? 
36LOCAL_QI_TYPE_ID_INDIssue Type ID from Source Systemchar10 Allow NULL? 
37QI_TYPE_TEXTQuality Issue Type Textnvarchar400 Allow NULL? 
38OPEN_ACTSOpen Tasks and Activities Existchar10 Allow NULL? 
39LOCAL_QI_CODE_ID_INDCode ID from Source Systemchar10 Allow NULL? 
40LOCAL_MATERIAL_ID_INDMaterial ID from Source Systemchar10 Allow NULL? 
41MATERIAL_TEXTMaterial Textnvarchar400 Allow NULL? 
42MORE_THAN_ONE_MAT_INDMore Than One Material Existschar10 Allow NULL? 
43LOCAL_CUSTOMER_ID_INDCustomer ID from Source Systemchar10 Allow NULL? 
44CUSTOMER_TEXTCustomer Namenvarchar400 Allow NULL? 
45MORE_THAN_ONE_CUST_INDMore Than One Customer Existschar10 Allow NULL? 
46LOCAL_VENDOR_ID_INDVendor ID from Source Systemchar10 Allow NULL? 
47VENDOR_TEXTVendor Namenvarchar400 Allow NULL? 
48MORE_THAN_ONE_VEND_INDMore Than One Vendor Existschar10 Allow NULL? 
49PLANTPlantnvarchar40 Allow NULL? 
50PLANT_TEXTPlant Descriptionnvarchar400 Allow NULL? 
51COMPLAINT_QUANComplaint Quantitydecimal133
52COMPLAINT_QUNITUnit of Measure from Source Systemnvarchar30 Allow NULL? 
53PRIORITYPrioritynvarchar20 Allow NULL? 
54PRIORITY_TEXTPriority Textnvarchar400 Allow NULL? 
55LOCAL_EQUIPMENT_ID_INDEquipment ID from Source Systemchar10 Allow NULL? 
56EQUIPMENTEquipmentnvarchar180 Allow NULL? 
57EQUIPMENT_TEXTEquipment Descriptionnvarchar400 Allow NULL? 
58FUNC_LOCATIONFunctional Locationnvarchar400 Allow NULL? 
59FUNC_LOCATION_TEXTFunctional Location Descriptionnvarchar400 Allow NULL? 
60LOCAL_FUNCTLOCATION_INDFunctional Location ID from Source Systemchar10 Allow NULL? 
61WBS_ELEMENTWork Breakdown Structure Element (WBS Element)nvarchar240 Allow NULL? 
62WBS_TEXTWBS Element Textnvarchar400 Allow NULL? 
63USER_STATUS_COMBINED_DESCRTexts for All User Statusesnvarchar1550 Allow NULL? 
NamePrimaryUniqueTypeColumns
QAM_L_BCV_I~0YesYesCLUSTEREDBCV_QI_ID, USERNAME, CLIENT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy