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  | CCGLT_PR_HDR_UT2
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
1ERP EHP76.0CCGLT_PR_HDR_UT2501EHS: Print Request Header Table Test Data for Unit Test
SQL:  selectupdate insert create

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

SELECT MANDT, OBSOLETE_ID, TESTCASE, TESTCASE_NO, DIRECTION, PRTREQ_ID, PRTREQ_ID_REF, TYPE, STATE, GENWARNING, CRDAT, CRNAM, CRTIM, UPDDAT, UPDNAM, UPDTIM, SCENID, SBGVID, STNID, PRNID, SUBID, REPLANGU, ECOUNT, FLGPRIMM, LSID, DELDELAY, TRAYNAME, PRELABEL, POSTLABEL, MATNR, SCNGRP, SYSTEMNAME, EXTNUMBER, TRIGORDID, WERK, WORKLIST, ORDER1, ORDER2, ORDER3, ORDER4, ORDER5, ORDER6, ORDER7, ORDER8, ORDER9, ORDER10, DOKAR, DOKNR, DOKVR, DOKTL FROM CCGLT_PR_HDR_UT2
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2OBSOLETE_IDCharacter Field Length = 10nvarchar100CHAR(N' ')NoCHAR10 Allow NULL? 
3TESTCASECommentnvarchar500CHAR(N' ')NoCHAR50 Allow NULL? 
4TESTCASE_NOTwo digit numbernvarchar20NUMC(N'00')NoNUMC2 Allow NULL? 
5DIRECTION30 Charactersnvarchar300CHAR(N' ')YesCHAR30 Allow NULL? 
6PRTREQ_IDPrint Requestnvarchar120NUMC(N'000000000000')YesCBGLE_ORDID Allow NULL? 
7PRTREQ_ID_REFPrint Request Bodynvarchar120NUMC(N'000000000000')YesCBGLE_PRBID Allow NULL? 
8TYPEPrint Request Typenvarchar120CHAR(N' ')YesCBGLE_PRTREQ_TYPE Allow NULL? 
9STATEPrint Request Statusnvarchar120CHAR(N' ')YesCBGLE_PRTREQ_STATUS Allow NULL? 
10GENWARNINGWarnings During Label Generationchar10NUMC(N'0')YesCBGLE_PRTREQ_GENWARNING Allow NULL? 
11CRDATCreated Onnvarchar80DATS(N'00000000')YesCBGLE_CRDAT Allow NULL? 
12CRNAMCreated Bynvarchar120CHAR(N' ')YesCBGLE_CRNAM Allow NULL? 
13CRTIMCreation Time of Print Requestnvarchar60TIMS(N'000000')YesCBGLE_CRTIM Allow NULL? 
14UPDDATChanged Onnvarchar80DATS(N'00000000')YesESEUPDDAT Allow NULL? 
15UPDNAMLast Changed Bynvarchar120CHAR(N' ')YesESEUPDNAM Allow NULL? 
16UPDTIMPrint Request Change Date/Timenvarchar60TIMS(N'000000')YesCBGLE_UPDTIM Allow NULL? 
17SCENIDLabeling Scenarionvarchar300CHAR(N' ')YesCCGLC_SCENCBGLE_SCENID Allow NULL? 
18SBGVIDReport Generation Variantnvarchar100CHAR(N' ')YesESELDEPID Allow NULL? 
19STNIDPrint Stationnvarchar120CHAR(N' ')Yes*CBGLE_STNID Allow NULL? 
20PRNIDPrinter on Print Stationnvarchar120CHAR(N' ')Yes*CBGLE_PRNID Allow NULL? 
21SUBIDSpecificationnvarchar120CHAR(N' ')YesESESUBID Allow NULL? 
22REPLANGULanguage Keychar10LANG(N' ')Yes*LANGU Allow NULL? 
23ECOUNTNumber of Printed Copiesdecimal60DEC((0))YesCBGLE_NUM
24FLGPRIMMPrint Immediatelychar10CHAR(N' ')YesCBGLE_FLGPRIMM Allow NULL? 
25LSIDLabel Stocknvarchar120CHAR(N' ')YesCBGLE_LSID Allow NULL? 
26DELDELAYValidity in Daysint100INT4((0))YesCBGLE_DELETEDELAY Allow NULL? 
27TRAYNAMEPrinter Output Traynvarchar1280CHAR(N' ')YesCBGLE_PRNTRAY Allow NULL? 
28PRELABELNumber of Preliminary Leg Labelsnvarchar40NUMC(N'0000')YesCBGLE_COUNT_PRE Allow NULL? 
29POSTLABELNumber of Subsequent Leg Labelsnvarchar40NUMC(N'0000')YesCBGLE_COUNT_POS Allow NULL? 
30MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
31SCNGRPLabeling Scenario Groupnvarchar300CHAR(N' ')YesCBGLE_SCNGRP Allow NULL? 
32SYSTEMNAMEName of SAP Systemnvarchar80CHAR(N' ')YesSYSYSID Allow NULL? 
33EXTNUMBERApplication Log: External IDnvarchar1000CHAR(N' ')YesBALNREXT Allow NULL? 
34TRIGORDIDObject Key for Print Requestnvarchar1280CHAR(N' ')YesCBGLE_TRIGORDID Allow NULL? 
35WERKPlant or Shipping Pointnvarchar40CHAR(N' ')YesCBGLE_PLANT Allow NULL? 
36WORKLISTWorklist for Print Requestchar10CHAR(N' ')YesCBGLE_WORKLIST Allow NULL? 
37ORDER1Print Request Description 01nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC1 Allow NULL? 
38ORDER2Print Request Description 02nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC2 Allow NULL? 
39ORDER3Print Request Description 03nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC3 Allow NULL? 
40ORDER4Print Request Description 04nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC4 Allow NULL? 
41ORDER5Print Request Description 05nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC5 Allow NULL? 
42ORDER6Print Request Description 06nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC6 Allow NULL? 
43ORDER7Print Request Description 07nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC7 Allow NULL? 
44ORDER8Print Request Description 08nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC8 Allow NULL? 
45ORDER9Print Request Description 09nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC9 Allow NULL? 
46ORDER10Print Request Description 10nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC10 Allow NULL? 
47DOKARDocument Typenvarchar30CHAR(N' ')YesTDWADOKAR Allow NULL? 
48DOKNRDocument numbernvarchar250CHAR(N' ')YesESD_DRAWDOKNR Allow NULL? 
49DOKVRDocument Versionnvarchar20CHAR(N' ')YesESD_DRAWDOKVR Allow NULL? 
50DOKTLDocument Partnvarchar30CHAR(N' ')YesDOKTL_D Allow NULL? 
NamePrimaryUniqueTypeColumns
CCGLT_PR_HDR_UT2~0YesYesCLUSTEREDTESTCASE_NO, TESTCASE, OBSOLETE_ID, MANDT

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