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/T606
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
Global Trade Services :: Global Trade Services
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/SAPSLL/T606991License TypesGlobal Trade Services
SQL:  selectupdate insert create

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

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