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  | /SAPSLL/LCLIC
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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Global Trade Services :: Global Trade Services
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/SAPSLL/LCLIC562Legal Control: License HeaderGlobal Trade Services
SQL:  selectupdate insert create

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

SELECT MANDT, GUID_LCLIC, LGREG, LICTY, EXLIC, CUSTA, LCASS, DATAB, DATBI, GUID_LCLICA, ERNAM, CRTSP, AENAM, CHTSP, MCUSE, BPCCB, BPCNT, BPCMT, BPCNS, BPCDR, BPCNU, INDEI, LILOC, EXTNO, GAAC1, GAAC2, SNDSTA, AADAT, EODAT, EGDAT, SVDAT, SBDAT, ERDAT, INCOT, INCOLO, ANZTA, UMLKZ, AUTLF, ZUPVO, RPDYS, ECPLY, EQPRI, SPMTH, GLBPD, IPRTY, CLPPT, SPCAP, QUALD, QALDOC, PAPTY, PAPOF, FSMTH, BPMTH, FCPCP, LCAST, EPVPD FROM /SAPSLL/LCLIC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160RAWNo/SAPSLL/GUID_16
3LGREGLegal Regulationnvarchar50CHAR(N' ')Yes/SAPSLL/T606G/SAPSLL/LGREG Allow NULL? 
4LICTYLicense Typenvarchar50CHAR(N' ')Yes/SAPSLL/T606/SAPSLL/LICTY Allow NULL? 
5EXLICLicense Numbernvarchar400CHAR(N' ')Yes/SAPSLL/EXLIC Allow NULL? 
6CUSTAStatus for Licenses of a Legal Regulationnvarchar40CHAR(N' ')Yes/SAPSLL/T606S/SAPSLL/CUSTA Allow NULL? 
7LCASSSLL: License Is Assigned to Documentschar10CHAR(N' ')Yes/SAPSLL/LCASS Allow NULL? 
8DATABDefinitive Date (Valid-From Time)decimal150DEC((0))Yes/SAPSLL/RPTST
9DATBIDefinitive Date (Valid-To Date)decimal150DEC((0))Yes/SAPSLL/RPTET
10GUID_LCLICAPrimary Key as GUID in 'RAW' Formatvarbinary160RAWYes/SAPSLL/LCLICA/SAPSLL/GUID_16
11ERNAMName of User Who Created the Objectnvarchar120CHAR(N' ')YesUSR02/SAPSLL/ERNAM Allow NULL? 
12CRTSPUTC Time Stamp When Object Was Addeddecimal150DEC((0))Yes/SAPSLL/CRTSP
13AENAMName of User Who Changed the Objectnvarchar120CHAR(N' ')YesUSR02/SAPSLL/AENAM Allow NULL? 
14CHTSPUTC Time Stamp When Object Was Changeddecimal150DEC((0))Yes/SAPSLL/CHTSP
15MCUSEMilitary / Civilian Usage Indicatorchar10CHAR(N' ')Yes/SAPSLL/MCUSE Allow NULL? 
16BPCCBIndicator for Chemical/Biological Warfarechar10CHAR(N' ')Yes/SAPSLL/BPCCB Allow NULL? 
17BPCNTNuclear Nonproliferation Indicatorchar10CHAR(N' ')Yes/SAPSLL/BPCNT Allow NULL? 
18BPCMTIndicator for Missile Technologychar10CHAR(N' ')Yes/SAPSLL/BPCMT Allow NULL? 
19BPCNSIndicator for National Securitychar10CHAR(N' ')Yes/SAPSLL/BPCNS Allow NULL? 
20BPCDRIndicator for Drug Productschar10CHAR(N' ')Yes/SAPSLL/BPCDR Allow NULL? 
21BPCNUFlag: Operator of a Nuclear Facilitychar10CHAR(N' ')Yes/SAPSLL/BPCNU Allow NULL? 
22INDEIImport/Export Indicator (Inclusive)char10CHAR(N' ')Yes/SAPSLL/INDEI_INCL Allow NULL? 
23LILOCAuthorized Place of Transfer/Presentationnvarchar200CHAR(N' ')Yes/SAPSLL/LILOC Allow NULL? 
24EXTNOExternal License Numbernvarchar400CHAR(N' ')Yes/SAPSLL/EXTNO Allow NULL? 
25GAAC1Security - Administrative Code (Old)nvarchar200CHAR(N' ')Yes/SAPSLL/GAAC1 Allow NULL? 
26GAAC2Security - Administrative Code (New)nvarchar200CHAR(N' ')Yes/SAPSLL/GAAC2 Allow NULL? 
27SNDSTASend Statuschar10CHAR(N' ')Yes/SAPSLL/SNDSTA Allow NULL? 
28AADATRequest Datenvarchar80DATS(N'00000000')Yes/SAPSLL/AADAT Allow NULL? 
29EODATOpening Datenvarchar80DATS(N'00000000')Yes/SAPSLL/EODAT Allow NULL? 
30EGDATDate Receivednvarchar80DATS(N'00000000')Yes/SAPSLL/EGDAT Allow NULL? 
31SVDATLatest Shipping Datenvarchar80DATS(N'00000000')Yes/SAPSLL/SVDAT Allow NULL? 
32SBDATLatest Ocean Bill of Ladingnvarchar80DATS(N'00000000')Yes/SAPSLL/SBDAT Allow NULL? 
33ERDATDate on Which Documents Were Presentednvarchar80DATS(N'00000000')Yes/SAPSLL/ERDAT Allow NULL? 
34INCOTIncotermnvarchar30CHAR(N' ')Yes/SAPSLL/TCOINC/SAPSLL/INCOT Allow NULL? 
35INCOLOIncoterm Locationnvarchar400CHAR(N' ')Yes/SAPSLL/INCOLO Allow NULL? 
36ANZTANumber of Days to Presentation of Documentsnvarchar50NUMC(N'00000')Yes/SAPSLL/ANZTA Allow NULL? 
37UMLKZTransshipment Indicator in Letter of Credit Recordchar10CHAR(N' ')Yes/SAPSLL/UMLKZ Allow NULL? 
38AUTLFComplete Delivery per Order Requiredchar10CHAR(N' ')Yes/SAPSLL/AUTLF Allow NULL? 
39ZUPVOMixed-Packing Regulationchar10CHAR(N' ')Yes/SAPSLL/ZUPVO Allow NULL? 
40RPDYSRe-Import Period for Outward Processing in Daysnvarchar30NUMC(N'000')Yes/SAPSLL/RPDYS Allow NULL? 
41ECPLYType of Warehouse for Customs Procedure w/Economic Impactnvarchar20CHAR(N' ')Yes/SAPSLL/ECPLY Allow NULL? 
42EQPRIEquivalency Principle for Inward Processingchar10CHAR(N' ')Yes/SAPSLL/EQPRI Allow NULL? 
43SPMTHProcessing Period in Months for Special Customs Proceduresnvarchar30NUMC(N'000')Yes/SAPSLL/SPMTH Allow NULL? 
44GLBPDGlobalization Period for Special Customs Proced. in Monthsnvarchar30NUMC(N'000')Yes/SAPSLL/GLBPD Allow NULL? 
45IPRTYType of Inward Processingchar10CHAR(N' ')Yes/SAPSLL/IPRTY Allow NULL? 
46CLPPTDetermination Time of Closing Portions - IPchar10CHAR(N' ')Yes/SAPSLL/CLPPT Allow NULL? 
47SPCAPSettlement Period in Monthsnvarchar30NUMC(N'000')Yes/SAPSLL/SPCAP Allow NULL? 
48QUALDQualifier for Documentnvarchar60CHAR(N' ')Yes/SAPSLL/CUCPQU/SAPSLL/QUALD Allow NULL? 
49QALDOCCategory of Documentnvarchar40CHAR(N' ')Yes/SAPSLL/QALDOC Allow NULL? 
50PAPTYType of Documentnvarchar60CHAR(N' ')Yes/SAPSLL/CUCPAT/SAPSLL/PAPTY Allow NULL? 
51PAPOFIssuing Authority of Documentnvarchar100CHAR(N' ')Yes*/SAPSLL/PAPOF Allow NULL? 
52FSMTHPeriod for Completing Supplementary Customs Decl. in Monthsnvarchar30NUMC(N'000')Yes/SAPSLL/FSMTH Allow NULL? 
53BPMTHInstallation Period in Months for FC w/Prescribed End Usenvarchar30NUMC(N'000')Yes/SAPSLL/BPMTH Allow NULL? 
54FCPCPCreation Period for Installation Statement in Months (FCPEU)nvarchar30NUMC(N'000')Yes/SAPSLL/FCPCP Allow NULL? 
55LCASTCustoms Procedure-Specific Authorizationchar10CHAR(N' ')Yes/SAPSLL/LCAST Allow NULL? 
56EPVPDPeriod for Prior Exportation in Monthsnvarchar30NUMC(N'000')Yes/SAPSLL/EPVPD Allow NULL? 
NamePrimaryUniqueTypeColumns
/SAPSLL/LCLIC~0YesYesCLUSTEREDGUID_LCLIC, MANDT
/SAPSLL/LCLIC~SKNoYesNONCLUSTEREDEXLIC, LICTY, LGREG, 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