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/LCLICA
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
Global Trade Services :: Global Trade Services
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/SAPSLL/LCLICA1071Legal Control: Other License AttributesGlobal Trade Services
SQL:  selectupdate insert create

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

SELECT MANDT, GUID_LCLICA, REGTY, INDEI, TZNST, TZNEN, KSAEX, TXTSCHEMA, LCCLA, LTIND, VALSP, VABAS, VPRAC, VPRIC, QUASP, QUBAS, QPRAC, QPRIC, PROSP, IMPSP, STASP, CCLSP, SHCCO, COUSP, CUPSP, DOCSP, PARSP, ADITI, TRMCO, EXASP, FTOSP, VBSSP, MULIC, PACHG, CUSTA, CMPCT, CGRSP, MONSP, SAFSP, GCOSP, INCSP, PRJSP, HMLIC, PRORT, CCLRT, SHCRT, IMPRT, STWRT, COURT, CUPRT, DOCRT, PARRT, TRMRT, EXART, FTORT, VBSRT, CSORT, CGRRT, PRFRT, TENRT, MONRT, PRJRT, MCUSE, BPCCB, BPCNT, BPCMT, BPCNS, BPCDR, BPCNU, CLCUS, PGCUS, CLCCL, PGCCL, LCNRN, ACFFL, PGFCT, CTTCP, ACT4E, VALCH, QUACH, VADPL, QUDPL, AGRLT, DPRGR, LTPPF, ECMSG, ECMRG, PAPTY, LTCAT, DOCFL, SMVAL, MUCTY, PGCTY, KURTY, AGRRQ, SVAGR, QALDOC, PAPOF, LCEAC, FISCD, PGCHS, LTDSP, STCTS_IMPCN, STCTS_STAWN, STCTS_CCCL, STCTS_CUPRO, STCTS_MOWNR FROM /SAPSLL/LCLICA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GUID_LCLICAPrimary Key as GUID in 'RAW' Formatvarbinary160RAWNo/SAPSLL/GUID_16
3REGTYType of Underlying Legal Codenvarchar20CHAR(N' ')Yes/SAPSLL/REGTY Allow NULL? 
4INDEIImport/Export Indicator (Inclusive)char10CHAR(N' ')Yes/SAPSLL/INDEI_INCL Allow NULL? 
5TZNSTFrom-Time Zonenvarchar60CHAR(N' ')YesTTZZ/SAPSLL/TZNST Allow NULL? 
6TZNENTo-Time Zonenvarchar60CHAR(N' ')YesTTZZ/SAPSLL/TZNEN Allow NULL? 
7KSAEXOfficial Identification of License Type by Goverment Agencynvarchar200CHAR(N' ')Yes/SAPSLL/KSAEX Allow NULL? 
8TXTSCHEMAText Determination Procedurenvarchar100CHAR(N' ')Yes/SAPSLL/TCO310/SAPSLL/TXTSCHEMA Allow NULL? 
9LCCLACategory of License Typechar10CHAR(N' ')Yes/SAPSLL/LCCLA Allow NULL? 
10LTINDImport/Export Indicator (Inclusive)char10CHAR(N' ')Yes/SAPSLL/INDEI_INCL Allow NULL? 
11VALSPIndicator: Maximum Value Specified for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/VALSP Allow NULL? 
12VABASBasis for Value Update for Legal Controlnvarchar60CHAR(N' ')Yes*/SAPSLL/VABAS Allow NULL? 
13VPRACExtent to Which Max. Value Is Exceeded (%) for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/VPRAC Allow NULL? 
14VPRICExtent to Which Max. Value Is Not Reached (%) for Leg. Cntrlchar10CHAR(N' ')Yes/SAPSLL/VPRIC Allow NULL? 
15QUASPIndicator: Maximum Quantity Specified for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/QUASP Allow NULL? 
16QUBASBasis for Quantity Update for Legal Controlnvarchar60CHAR(N' ')Yes*/SAPSLL/QUBAS Allow NULL? 
17QPRACExtent to Which Max. Qty Is Exceeded (in %) for LCchar10CHAR(N' ')Yes/SAPSLL/QPRAC Allow NULL? 
18QPRICIndicator: Extent of Max. Qty Shortfall (in %) for LCchar10CHAR(N' ')Yes/SAPSLL/QPRIC Allow NULL? 
19PROSPIndicator: Product Number-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/PROSP Allow NULL? 
20IMPSPFlag: Import Tariff Number-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/IMPSP Allow NULL? 
21STASPIndicator: Commodity Code Specified for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/STASP Allow NULL? 
22CCLSPIndicator: Control Class-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/CCLSP Allow NULL? 
23SHCCOIndicator: Peculiarity Code-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/SHCCO Allow NULL? 
24COUSPFlag: Specific to Country of Dept./Dest. for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/COUSP Allow NULL? 
25CUPSPFlag: Customs Procedure-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/CUPSP Allow NULL? 
26DOCSPFlag: Document Number-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/DOCSP Allow NULL? 
27PARSPIndicator: Business Partner-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/PARSP Allow NULL? 
28ADITIInd.: Partner Function Specified for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/ADITI Allow NULL? 
29TRMCOIndicator: Term of Payment-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/TRMCO Allow NULL? 
30EXASPFlag: Business Transaction Type-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/EXASP Allow NULL? 
31FTOSPFlag: Foreign Trade Organization-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/FTOSP Allow NULL? 
32VBSSPIndicator: Legal Unit-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/VBSSP Allow NULL? 
33MULICSeveral Licenses per License Typechar10CHAR(N' ')Yes/SAPSLL/MULIC Allow NULL? 
34PACHGIndicator: Consider Changes to Partner Address Datachar10CHAR(N' ')Yes/SAPSLL/PACHG Allow NULL? 
35CUSTAStatus for Licenses of a Legal Regulationnvarchar40CHAR(N' ')Yes*/SAPSLL/CUSTA Allow NULL? 
36CMPCTRule Set for Comparing Addresses for Partner-Spec. Licensesnvarchar50CHAR(N' ')Yes/SAPSLL/TCOCMP/SAPSLL/CMPCT_LIC Allow NULL? 
37CGRSPInd.: Country-Group Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/CGRSP Allow NULL? 
38MONSPIndicator: CAP-Number-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/MONSP Allow NULL? 
39SAFSPIndicator: Security Required for Export Licensechar10CHAR(N' ')Yes/SAPSLL/SAFSP Allow NULL? 
40GCOSPIndicator: Use of Access/Administrative Codeschar10CHAR(N' ')Yes/SAPSLL/GCOSP Allow NULL? 
41INCSPIndicator: Incoterm Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/INCSP Allow NULL? 
42PRJSPFlag: Project-Specific for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/PRJSP Allow NULL? 
43HMLICHarmonized Depreciationchar10CHAR(N' ')Yes/SAPSLL/HMLIC Allow NULL? 
44PRORTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
45CCLRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
46SHCRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
47IMPRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
48STWRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
49COURTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
50CUPRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
51DOCRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
52PARRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
53TRMRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
54EXARTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
55FTORTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
56VBSRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
57CSORTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
58CGRRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
59PRFRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
60TENRTCompetitive Bidding Procedure Activechar10CHAR(N' ')Yes/SAPSLL/TENRT Allow NULL? 
61MONRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
62PRJRTNumber of Possible Attributes for Legal Controlchar10CHAR(N' ')Yes/SAPSLL/RATYP Allow NULL? 
63MCUSEMilitary / Civilian Usage Indicatorchar10CHAR(N' ')Yes/SAPSLL/MCUSE Allow NULL? 
64BPCCBIndicator for Chemical/Biological Warfarechar10CHAR(N' ')Yes/SAPSLL/BPCCB Allow NULL? 
65BPCNTNuclear Nonproliferation Indicatorchar10CHAR(N' ')Yes/SAPSLL/BPCNT Allow NULL? 
66BPCMTIndicator for Missile Technologychar10CHAR(N' ')Yes/SAPSLL/BPCMT Allow NULL? 
67BPCNSIndicator for National Securitychar10CHAR(N' ')Yes/SAPSLL/BPCNS Allow NULL? 
68BPCDRIndicator for Drug Productschar10CHAR(N' ')Yes/SAPSLL/BPCDR Allow NULL? 
69BPCNUFlag: Operator of a Nuclear Facilitychar10CHAR(N' ')Yes/SAPSLL/BPCNU Allow NULL? 
70CLCUSCheck Level for Business Partner Usagechar10CHAR(N' ')Yes/SAPSLL/CLCUS Allow NULL? 
71PGCUSCheck for Business Partner Use in Partner Groupnvarchar60CHAR(N' ')Yes/SAPSLL/TPAGR/SAPSLL/PGCUS Allow NULL? 
72CLCCLCheck Level for Business Partner Classificationchar10CHAR(N' ')Yes/SAPSLL/CLCCL Allow NULL? 
73PGCCLCheck Business Partner Classification in Partner Groupnvarchar60CHAR(N' ')Yes/SAPSLL/TPAGR/SAPSLL/PGCCL Allow NULL? 
74LCNRNNumber of Number Range for Licensesnvarchar20CHAR(N' ')YesNRIV/SAPSLL/LCNRN Allow NULL? 
75ACFFLUnique Prefixation Periodchar10CHAR(N' ')Yes/SAPSLL/ACFFL Allow NULL? 
76PGFCTPartner Group: Partner Function Check in Licensenvarchar60CHAR(N' ')Yes/SAPSLL/TPAGR/SAPSLL/PGFCT Allow NULL? 
77CTTCPText Type for Customs Tariff Systemchar10CHAR(N' ')Yes/SAPSLL/CTSTT_CAP Allow NULL? 
78ACT4EActivate Dual Control Principlechar10CHAR(N' ')Yes/SAPSLL/ACT4E Allow NULL? 
79VALCHSubsequent Value Change in License Allowedchar10CHAR(N' ')Yes/SAPSLL/VALCH Allow NULL? 
80QUACHSubsequent Quantity Change in License Allowedchar10CHAR(N' ')Yes/SAPSLL/QUACH Allow NULL? 
81VADPLAssignment Level of Maximum Value per Licensechar10CHAR(N' ')Yes/SAPSLL/VADPL Allow NULL? 
82QUDPLAssignment Level of Maximum Quantity per Licensechar10CHAR(N' ')Yes/SAPSLL/QUDPL Allow NULL? 
83AGRLTType of Agreement for Legal Controlnvarchar50CHAR(N' ')Yes/SAPSLL/T606/SAPSLL/AGRLT Allow NULL? 
84DPRGRDepreciation Groupnvarchar60CHAR(N' ')Yes/SAPSLL/TLEDPG/SAPSLL/DPRGR Allow NULL? 
85LTPPFName of Action Profile of License Typenvarchar300CHAR(N' ')YesPPFTCONDE/SAPSLL/LTPPF Allow NULL? 
86ECMSGSender for Generated E-Mailnvarchar120CHAR(N' ')YesUSR02/SAPSLL/ECMSG Allow NULL? 
87ECMRGUser Group for E-Mail Receiptnvarchar120CHAR(N' ')YesUSGRP/SAPSLL/ECMRG Allow NULL? 
88PAPTYType of Documentnvarchar60CHAR(N' ')Yes/SAPSLL/CUCPAT/SAPSLL/PAPTY Allow NULL? 
89LTCATCategory of License Typenvarchar20CHAR(N' ')Yes/SAPSLL/TLLTC/SAPSLL/LTCAT Allow NULL? 
90DOCFLCheck of First Document in Document Flowchar10CHAR(N' ')Yes/SAPSLL/DOCFL Allow NULL? 
91SMVALLow Value Check Active for License Typechar10CHAR(N' ')Yes/SAPSLL/SMVAL Allow NULL? 
92MUCTYCheck of Multiple Partner Countries during License Determ.char10CHAR(N' ')Yes/SAPSLL/MUCTY Allow NULL? 
93PGCTYPartner Grouping: Check Partner Countriesnvarchar60CHAR(N' ')Yes/SAPSLL/TPAGR/SAPSLL/PGCTY Allow NULL? 
94KURTYExchange Rate Typenvarchar40CHAR(N' ')YesTCURV/SAPSLL/KURTY Allow NULL? 
95AGRRQAgreement Required for Licensechar10CHAR(N' ')Yes/SAPSLL/AGRRQ Allow NULL? 
96SVAGRAggregation Rule for Small Value Exemptionchar10CHAR(N' ')Yes/SAPSLL/SVAGR Allow NULL? 
97QALDOCCategory of Documentnvarchar40CHAR(N' ')Yes/SAPSLL/QALDOC Allow NULL? 
98PAPOFIssuing Authority of Documentnvarchar100CHAR(N' ')Yes*/SAPSLL/PAPOF Allow NULL? 
99LCEACEnhanced Authorization Checkchar10CHAR(N' ')Yes/SAPSLL/LCEAC Allow NULL? 
100FISCDFlag: Completion Period for Supplementary Customs Decl.char10CHAR(N' ')Yes/SAPSLL/FISCD Allow NULL? 
101PGCHSScope of Check for Partner Functionschar10CHAR(N' ')Yes/SAPSLL/PGCHS Allow NULL? 
102LTDSPDelivery Split Allowed in SAP Extended Warehouse Managementchar10CHAR(N' ')Yes/SAPSLL/LTDSP Allow NULL? 
103STCTS_IMPCNNumbering Scheme for Customs Tariff Systemnvarchar100CHAR(N' ')Yes*/SAPSLL/STCTS Allow NULL? 
104STCTS_STAWNNumbering Scheme for Customs Tariff Systemnvarchar100CHAR(N' ')Yes*/SAPSLL/STCTS Allow NULL? 
105STCTS_CCCLNumbering Scheme for Customs Tariff Systemnvarchar100CHAR(N' ')Yes*/SAPSLL/STCTS Allow NULL? 
106STCTS_CUPRONumbering Scheme for Customs Tariff Systemnvarchar100CHAR(N' ')Yes*/SAPSLL/STCTS Allow NULL? 
107STCTS_MOWNRNumbering Scheme for Customs Tariff Systemnvarchar100CHAR(N' ')Yes*/SAPSLL/STCTS Allow NULL? 
NamePrimaryUniqueTypeColumns
/SAPSLL/LCLICA~0YesYesCLUSTEREDGUID_LCLICA, 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