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_PRTREQ_HDR
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_PRTREQ_HDR4811EHS: Print Request Header Table
SQL:  selectupdate insert create

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

SELECT MANDT, PRTREQ_ID, PRTREQ_ID_REF, TYPE, STATE, GENWARNING, CRDAT, CRNAM, CRTIM, UPDDAT, UPDNAM, UPDTIM, SCENID, SBGVID, LABELTYPE, STNID, PRNID, SUBID, REPLANGU, ECOUNT, FLGPRIMM, LSID, DELDELAY, PRELABEL, POSTLABEL, MATNR, SCNGRP, SYSTEMNAME, CLNT, EXTNUMBER, TRIGORDID, PLANT, WORKPLACE, WORKLIST, ORDER1, ORDER2, ORDER3, ORDER4, ORDER5, ORDER6, ORDER7, ORDER8, ORDER9, ORDER10, DOKAR, DOKNR, DOKVR, DOKTL FROM CCGLT_PRTREQ_HDR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PRTREQ_IDPrint Requestnvarchar120NUMC(N'000000000000')NoCBGLE_ORDID Allow NULL? 
3PRTREQ_ID_REFPrint Request Bodynvarchar120NUMC(N'000000000000')YesCBGLE_PRBID Allow NULL? 
4TYPEPrint Request Typenvarchar120CHAR(N' ')YesCBGLE_PRTREQ_TYPE Allow NULL? 
5STATEPrint Request Statusnvarchar120CHAR(N' ')YesCBGLE_PRTREQ_STATUS Allow NULL? 
6GENWARNINGWarnings During Label Generationchar10NUMC(N'0')YesCBGLE_PRTREQ_GENWARNING Allow NULL? 
7CRDATCreated Onnvarchar80DATS(N'00000000')YesCBGLE_CRDAT Allow NULL? 
8CRNAMCreated Bynvarchar120CHAR(N' ')YesCBGLE_CRNAM Allow NULL? 
9CRTIMCreation Time of Print Requestnvarchar60TIMS(N'000000')YesCBGLE_CRTIM Allow NULL? 
10UPDDATChanged Onnvarchar80DATS(N'00000000')YesESEUPDDAT Allow NULL? 
11UPDNAMLast Changed Bynvarchar120CHAR(N' ')YesESEUPDNAM Allow NULL? 
12UPDTIMPrint Request Change Date/Timenvarchar60TIMS(N'000000')YesCBGLE_UPDTIM Allow NULL? 
13SCENIDLabeling Scenarionvarchar300CHAR(N' ')YesCCGLC_SCENCBGLE_SCENID Allow NULL? 
14SBGVIDReport Generation Variantnvarchar100CHAR(N' ')YesESELDEPID Allow NULL? 
15LABELTYPELabel Categorynvarchar100CHAR(N' ')Yes*CBGLE_LTYP Allow NULL? 
16STNIDPrint Stationnvarchar120CHAR(N' ')Yes*CBGLE_STNID Allow NULL? 
17PRNIDPrinter on Print Stationnvarchar120CHAR(N' ')Yes*CBGLE_PRNID Allow NULL? 
18SUBIDSpecificationnvarchar120CHAR(N' ')YesESESUBID Allow NULL? 
19REPLANGULanguage Keychar10LANG(N' ')Yes*LANGU Allow NULL? 
20ECOUNTNumber of Printed Copiesdecimal60DEC((0))YesCBGLE_NUM
21FLGPRIMMPrint Immediatelychar10CHAR(N' ')YesCBGLE_FLGPRIMM Allow NULL? 
22LSIDLabel Stocknvarchar120CHAR(N' ')YesCBGLE_LSID Allow NULL? 
23DELDELAYValidity in Daysint100INT4((0))YesCBGLE_DELETEDELAY Allow NULL? 
24PRELABELNumber of Preliminary Leg Labelsnvarchar40NUMC(N'0000')YesCBGLE_COUNT_PRE Allow NULL? 
25POSTLABELNumber of Subsequent Leg Labelsnvarchar40NUMC(N'0000')YesCBGLE_COUNT_POS Allow NULL? 
26MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
27SCNGRPLabeling Scenario Groupnvarchar300CHAR(N' ')YesCCGLC_SCENGRPCBGLE_SCENGRP Allow NULL? 
28SYSTEMNAMEName of SAP Systemnvarchar80CHAR(N' ')YesCBGLE_SYSNAME Allow NULL? 
29CLNTClientnvarchar30NUMC(N'000')YesCBGLE_CLIENT Allow NULL? 
30EXTNUMBERApplication Log: External IDnvarchar1000CHAR(N' ')YesBALNREXT Allow NULL? 
31TRIGORDIDObject Key for Print Requestnvarchar1280CHAR(N' ')YesCBGLE_TRIGORDID Allow NULL? 
32PLANTPlant or Shipping Pointnvarchar40CHAR(N' ')YesCBGLE_PLANT Allow NULL? 
33WORKPLACEWork Centernvarchar80CHAR(N' ')YesCCGLC_ARBPLCBGLE_ARBPL Allow NULL? 
34WORKLISTWorklist for Print Requestchar10CHAR(N' ')YesCBGLE_WORKLIST Allow NULL? 
35ORDER1Print Request Description 01nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC1 Allow NULL? 
36ORDER2Print Request Description 02nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC2 Allow NULL? 
37ORDER3Print Request Description 03nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC3 Allow NULL? 
38ORDER4Print Request Description 04nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC4 Allow NULL? 
39ORDER5Print Request Description 05nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC5 Allow NULL? 
40ORDER6Print Request Description 06nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC6 Allow NULL? 
41ORDER7Print Request Description 07nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC7 Allow NULL? 
42ORDER8Print Request Description 08nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC8 Allow NULL? 
43ORDER9Print Request Description 09nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC9 Allow NULL? 
44ORDER10Print Request Description 10nvarchar1280CHAR(N' ')YesCBGLE_PRTREQ_DESC10 Allow NULL? 
45DOKARDocument Typenvarchar30CHAR(N' ')YesTDWADOKAR Allow NULL? 
46DOKNRDocument numbernvarchar250CHAR(N' ')YesESD_DRAWDOKNR Allow NULL? 
47DOKVRDocument Versionnvarchar20CHAR(N' ')YesESD_DRAWDOKVR Allow NULL? 
48DOKTLDocument Partnvarchar30CHAR(N' ')YesDOKTL_D Allow NULL? 
NamePrimaryUniqueTypeColumns
CCGLT_PRTREQ_HDR01NoNoNONCLUSTEREDSTATE, TYPE
CCGLT_PRTREQ_HDR02NoNoNONCLUSTEREDSTNID
CCGLT_PRTREQ_HDR03NoNoNONCLUSTEREDCRDAT
CCGLT_PRTREQ_HDR04NoNoNONCLUSTEREDMATNR
CCGLT_PRTREQ_HDR05NoNoNONCLUSTEREDTRIGORDID
CCGLT_PRTREQ_HDR06NoNoNONCLUSTEREDORDER1
CCGLT_PRTREQ_HDR07NoNoNONCLUSTEREDORDER2
CCGLT_PRTREQ_HDR08NoNoNONCLUSTEREDORDER3
CCGLT_PRTREQ_HDR09NoNoNONCLUSTEREDORDER4
CCGLT_PRTREQ_HDR10NoNoNONCLUSTEREDORDER5
CCGLT_PRTREQ_HDR~0YesYesCLUSTEREDPRTREQ_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