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/LEGTPR
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/LEGTPR643SLL: Customs Document: Shipment ProcedureGlobal Trade Services
SQL:  selectupdate insert create

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

SELECT MANDT, GUID_LEGTPR, POBJT, GUID_POBJ, LGREG, PGESU, PLLSU, PLSTA, FLEVE, FLCNF, MOTBC, VIDBC, VCOBC, VTXBC, MOTDP, VIDDP, VCODP, VIDAR, VCOAR, MOTCP, VIDCP, VCOCP, VTXCP, LULOC, LOLOC, COLOC, MTBRC, MTRDO, FLFGR, FGRTX, PYTYP, FLITX, STAST, STALO, EXART, FLCVD, CUCRS, ITMSU, CUSEE, CSSTA, FLRPR, UCTYP, REGAR, FLDV1, CUBED, CULID, CUFWS, CULIM, NODDP, NODAR, LILOC, FLPRP, GEOGR, DCSTA, DCVAR, SPCIR, PYTRP, SUMFL, CANRE, CCNGA, VYGNO, WECMB, MOBJT, GUID_MOBJ FROM /SAPSLL/LEGTPR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GUID_LEGTPRPrimary Key as GUID in 'RAW' Formatvarbinary160RAWNo/SAPSLL/GUID_16
3POBJTType of Preceding Objectnvarchar20CHAR(N' ')Yes/SAPSLL/POBJT Allow NULL? 
4GUID_POBJPrimary Key of Preceding Objectvarbinary160RAWYes/SAPSLL/POBJ_GUID_16
5LGREGLegal Regulationnvarchar50CHAR(N' ')Yes/SAPSLL/T606G/SAPSLL/LGREG Allow NULL? 
6PGESUNumber of Packagesint100INT4((0))Yes/SAPSLL/PGESU Allow NULL? 
7PLLSUNo.Loading Listssmallint50INT2((0))Yes/SAPSLL/PLLSU
8PLSTAStatus of Sealschar10CHAR(N' ')Yes/SAPSLL/PLSTA Allow NULL? 
9FLEVEEvent Indicatorchar10CHAR(N' ')Yes/SAPSLL/FLEVE Allow NULL? 
10FLCNFConformity Indicatorchar10CHAR(N' ')Yes/SAPSLL/FLCNF Allow NULL? 
11MOTBCType of Means of Transport Crossing Bordernvarchar30CHAR(N' ')Yes/SAPSLL/CUCMOT/SAPSLL/MOTBC Allow NULL? 
12VIDBCIndicator: MoT at Bordernvarchar350CHAR(N' ')Yes/SAPSLL/VIDBC Allow NULL? 
13VCOBCMoT Country at Bordernvarchar30CHAR(N' ')YesT005/SAPSLL/VCOBC Allow NULL? 
14VTXBCDescription of Means of Transport Crossing Bordernvarchar200CHAR(N' ')Yes/SAPSLL/VTXBC Allow NULL? 
15MOTDPType of Means of Transport at Departurenvarchar30CHAR(N' ')Yes*/SAPSLL/MOTDP Allow NULL? 
16VIDDPIndicator: MoT at Departurenvarchar350CHAR(N' ')Yes/SAPSLL/VIDDP Allow NULL? 
17VCODPCountry of Means of Transport at Departurenvarchar30CHAR(N' ')YesT005/SAPSLL/VCODP Allow NULL? 
18VIDARIndicator: MoT at Arrivalnvarchar350CHAR(N' ')Yes/SAPSLL/VIDAR Allow NULL? 
19VCOARMoT Country at Arrivalnvarchar30CHAR(N' ')YesT005/SAPSLL/VCOAR Allow NULL? 
20MOTCPType of Means of Transport: Presentationnvarchar30CHAR(N' ')Yes*/SAPSLL/MOTCP Allow NULL? 
21VIDCPIndicator: MoT at Customs Presentationnvarchar350CHAR(N' ')Yes/SAPSLL/VIDCP Allow NULL? 
22VCOCPoT Country at Customs Presentationnvarchar30CHAR(N' ')Yes*/SAPSLL/VCOCP Allow NULL? 
23VTXCPDescription: MoT at Customs Presentationnvarchar200CHAR(N' ')Yes/SAPSLL/VTXCP Allow NULL? 
24LULOCPlace of Unloadingnvarchar350CHAR(N' ')Yes/SAPSLL/LULOC Allow NULL? 
25LOLOCPlace of Loadingnvarchar350CHAR(N' ')Yes/SAPSLL/LOLOC Allow NULL? 
26COLOCLocation of Goods / Place of Introductionnvarchar350CHAR(N' ')Yes/SAPSLL/COLOC Allow NULL? 
27MTBRCMode of Transport at Bordernvarchar20CHAR(N' ')Yes/SAPSLL/CUCMTR/SAPSLL/MTRBC Allow NULL? 
28MTRDOInland Mode of Transportnvarchar20CHAR(N' ')Yes/SAPSLL/CUCMTR/SAPSLL/MTRDO Allow NULL? 
29FLFGRIndicator: Mandatory Transport Routechar10CHAR(N' ')Yes/SAPSLL/FLFGR Allow NULL? 
30FGRTXBinding Route of Transportnvarchar700CHAR(N' ')Yes/SAPSLL/FGRTX Allow NULL? 
31PYTYPPayment Methodchar10CHAR(N' ')Yes/SAPSLL/CUCPYT/SAPSLL/PYTYP Allow NULL? 
32FLITXInput Tax Deduction Indicatorchar10CHAR(N' ')Yes/SAPSLL/FLITX Allow NULL? 
33STASTStatistics Statusnvarchar20CHAR(N' ')Yes*/SAPSLL/STAST Allow NULL? 
34STALOImporter HQnvarchar20CHAR(N' ')Yes/SAPSLL/LEGSLT/SAPSLL/STALO Allow NULL? 
35EXARTCustoms Business Transaction Typenvarchar20CHAR(N' ')Yes*/SAPSLL/EXART Allow NULL? 
36FLCVDIndicator: Customs Value Datachar10CHAR(N' ')Yes/SAPSLL/FLCVD Allow NULL? 
37CUCRSCustoms Control Resultnvarchar40CHAR(N' ')Yes/SAPSLL/CUCRES/SAPSLL/CUCRS Allow NULL? 
38ITMSUNumber of Itemssmallint50INT2((0))Yes/SAPSLL/ITMSU
39CUSEESea Traffic Indicatorchar10CHAR(N' ')Yes/SAPSLL/CUSEE Allow NULL? 
40CSSTACustoms Status of Goodnvarchar30CHAR(N' ')Yes*/SAPSLL/CSSTA Allow NULL? 
41FLRPRIndicator: Substitution Relationshipchar10CHAR(N' ')Yes/SAPSLL/FLRPR Allow NULL? 
42UCTYPType of Ultimate Consigneechar10CHAR(N' ')Yes/SAPSLL/CUCIND/SAPSLL/UCTYP Allow NULL? 
43REGARRegion of Destinationnvarchar30CHAR(N' ')Yes*/SAPSLL/REGAR Allow NULL? 
44FLDV1Value Declaration - Representative Capacitychar10CHAR(N' ')Yes/SAPSLL/FLDV1 Allow NULL? 
45CUBEDIndicator: Conditions and Serviceschar10CHAR(N' ')Yes/SAPSLL/CUBED Allow NULL? 
46CULIDIndicator: License Feeschar10CHAR(N' ')Yes/SAPSLL/CULID Allow NULL? 
47CUFWSIndicator: Resaleschar10CHAR(N' ')Yes/SAPSLL/CUFWS Allow NULL? 
48CULIMIndicator: Restrictionschar10CHAR(N' ')Yes/SAPSLL/CULIM Allow NULL? 
49NODDPIdentification of Connection Point at Departurenvarchar200CHAR(N' ')Yes*/SAPSLL/NODDP Allow NULL? 
50NODARIdentification of Connection Point at Destinationnvarchar200CHAR(N' ')Yes*/SAPSLL/NODAR Allow NULL? 
51LILOCAuthorized Place of Transfer/Presentationnvarchar200CHAR(N' ')Yes/SAPSLL/LILOC Allow NULL? 
52FLPRPIndicator for Prepayment (Prefinancing)char10CHAR(N' ')Yes/SAPSLL/FLPRP Allow NULL? 
53GEOGRGeographical Groupnvarchar100CHAR(N' ')Yes*/SAPSLL/GEOGR Allow NULL? 
54DCSTACustoms Status/Declarationnvarchar100CHAR(N' ')Yes*/SAPSLL/DCSTA Allow NULL? 
55DCVAREntry Typechar10CHAR(N' ')Yes*/SAPSLL/DCVAR Allow NULL? 
56SPCIRSpecial Circumstanceschar10CHAR(N' ')Yes*/SAPSLL/SPCIR Allow NULL? 
57PYTRPPayment Method for Transport Costschar10CHAR(N' ')Yes*/SAPSLL/PYTRP Allow NULL? 
58SUMFLSecurity Flag (Advance Declaration)char10CHAR(N' ')Yes/SAPSLL/SUMFL Allow NULL? 
59CANREReason for Cancellationchar10CHAR(N' ')Yes/SAPSLL/CUCCNR/SAPSLL/CANRE Allow NULL? 
60CCNGARange of Goodsnvarchar20CHAR(N' ')Yes*/SAPSLL/CCNGA Allow NULL? 
61VYGNOCross-Border Number of Transportationnvarchar350CHAR(N' ')Yes/SAPSLL/VYGNO Allow NULL? 
62WECMBConstellation of Consigneechar10CHAR(N' ')Yes/SAPSLL/WECMB Allow NULL? 
63MOBJTType of Main Objectchar10CHAR(N' ')Yes/SAPSLL/MOBJT Allow NULL? 
64GUID_MOBJPrimary Key of Main Objectvarbinary160RAWYes/SAPSLL/MOBJ_GUID_16
NamePrimaryUniqueTypeColumns
/SAPSLL/LEGTPR~0YesYesCLUSTEREDGUID_LEGTPR, MANDT
/SAPSLL/LEGTPR~HDNoNoNONCLUSTEREDGUID_MOBJ, MOBJT, MANDT
/SAPSLL/LEGTPR~SKNoYesNONCLUSTEREDLGREG, GUID_POBJ, POBJT, 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