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  | /LIME/COLL_FIN
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)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Application Platform :: AP-LIM Logistics Inventory Management Engine
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/LIME/COLL_FIN1184Collection for Financial SystemAP-LIM Logistics Inventory Management Engine
SQL:  selectupdate insert create

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

SELECT MANDT, GUID_COLL, GUID_DISPATCH, DISPATCH_TIME, GUID_PN, EXT_DOC, PROCESS_TYPE, ID, ID_PARENT, ID_GROUP, DIRECTION, REVERSE_MODE, ISSUE_ALL, TIMESTAMP, TIMESTAMP_END, NOTE, REASON, EXT_VALUE, EXT_VALUE_CURR, VSI, IC_DESCRIP, EEW_DUMMY, ACTION_TYPE, TARGET, IDX_LOC, GUID_LOC, WERKS, LGORT, GLN, DUNS4, LOCID, APO_LOCNO, PARTNER, PARTNER_ROLE, MOTID, MOTSCODE, /SAPSLL/ECPID, IDX_STOCK, GUID_STOCK, MATNR, CHARG, OWNER, OWNER_ROLE, GTIN, GTIN_VARIANT, CAT, STOCK_USAGE, SALES_ORD_STOCK, S_ORD_ITEM_STOCK, WBS_STOCK, VRSIOID, PRDID, APO_MATNR, /SAPSLL/LOGSYS, /SAPSLL/GUID_PR, /SAPSLL/COO, /SAPSLL/IDGDS, /SAPSLL/LOCID, /SAPSLL/GUID_ITM, /SAPSLL/FIFO, IDX_HU, GUID_HU, SSCC, QUAN, QUAN_PREV, PREV_IND, UNIT, STOCKUNIT, NOCALC, SERIALUNIT, VALUATIONUNIT, PO_NUMBER, PO_ITEM, PO_COMPLETE, ORDER_NUMBER, ORDER_ITEM, ORDER_COMPLETE, DELIVERY, DELIVERY_ITEM, DELIV_COMPLETE, MAT_DOC, MAT_DOC_YEAR, MAT_DOC_ITEM, RESERV_NO, RES_ITEM, RES_TYPE, RES_COMPLETE, TOP_LEVEL, GUID_COLL_GROUP, COSTCENTER, ORDERID, ORDER_ITNO, WBS_ELEMENT, NETWORK, SALES_ORD, SCHED_LINE, S_ORD_ITEM, ACTIVITY, CMMT_ITEM, ASSETMAINNO, ASSETSUBNO, FUNDS_CTR, GEBER, FUNC_AREA, ACTTYPE, GRANT_NBR, APO_MATNR_T, OWNER_T, OWNER_ROLE_T, CAT_T, APO_LOCNO_T, BUS_TRANS_TYPE, DOC_ID_1, DOC_TYPE_1, DOC_LOGSYS_1, DOC_ID_2, DOC_TYPE_2, DOC_LOGSYS_2 FROM /LIME/COLL_FIN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUID_COLLGUID LIME Collectionvarbinary160RAWNo/LIME/GUID_COLL
3GUID_DISPATCHGUID LIME Dispatcher Runvarbinary160RAWYes/LIME/GUID_DISPATCH
4DISPATCH_TIMEDispatcher Record Processed (Time Stamp)decimal217DEC((0))Yes/LIME/DISPATCH_TIME
5GUID_PNLIME GUID for Prima Notavarbinary160RAWYes/LIME/GUID_PN
6EXT_DOCNumber of LIME Documentnvarchar350CHAR(N' ')Yes/LIME/EXT_DOC Allow NULL? 
7PROCESS_TYPEApplicationnvarchar40CHAR(N' ')Yes/LIME/PROCESS_TYPE Allow NULL? 
8IDItemnvarchar60NUMC(N'000000')Yes/LIME/LINE_ITEM_ID Allow NULL? 
9ID_PARENTReference to Higher-Level Itemnvarchar60NUMC(N'000000')Yes/LIME/LINE_ITEM_ID_PARENT Allow NULL? 
10ID_GROUPItem Groupnvarchar60NUMC(N'000000')Yes/LIME/LINE_ITEM_GROUP Allow NULL? 
11DIRECTIONDirection of Movement (In/Out/Transfer)char10CHAR(N' ')Yes/LIME/DIRECTION Allow NULL? 
12REVERSE_MODEReversal Indicatorchar10CHAR(N' ')Yes/LIME/REVERSE_MODE Allow NULL? 
13ISSUE_ALLMove Total Stockchar10CHAR(N' ')Yes/LIME/ISSUE_ALL Allow NULL? 
14TIMESTAMPUTC Time Stamp (YYYYMMDDhhmmss,mmmuuun)decimal217DEC((0))Yes/LIME/TIMESTAMP_EXT
15TIMESTAMP_ENDUTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operationdecimal217DEC((0))Yes/LIME/TIMESTAMP_EXT_END
16NOTENotesnvarchar500CHAR(N' ')Yes/LIME/NOTE Allow NULL? 
17REASONReason for Movementnvarchar40CHAR(N' ')Yes/LIME/REASON Allow NULL? 
18EXT_VALUEExternal Valuedecimal132CURR((0))Yes/LIME/EXT_VALUE
19EXT_VALUE_CURRCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
20VSIVirtual Stock Indicatorchar10CHAR(N' ')Yes/LIME/VSI Allow NULL? 
21IC_DESCRIPDescription of Stock Changenvarchar100CHAR(N' ')Yes/LIME/IC_DESCRIP Allow NULL? 
22EEW_DUMMYDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
23ACTION_TYPELIME-Line Category (Internal)nvarchar20CHAR(N' ')Yes/LIME/ACTION_TYPE Allow NULL? 
24TARGETDescribes Whether It Is Source or Target Data Recordchar10CHAR(N' ')Yes/LIME/TARGET Allow NULL? 
25IDX_LOCCurrent Nummer of Key Tablenvarchar30CHAR(N' ')Yes/LIME/KEY_INDEX Allow NULL? 
26GUID_LOCLocation GUIDvarbinary160RAWYes/LIME/GUID_LOC
27WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
28LGORTStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
29GLNGlobal Location Numbernvarchar130NUMC(N'0000000000000')Yes/LIME/GLN Allow NULL? 
30DUNS4D-U-N-S+4 Numbernvarchar130NUMC(N'0000000000000')Yes/LIME/DUNS4 Allow NULL? 
31LOCIDGUID for Locationvarbinary160RAWYes/LIME/MDL_LOCID
32APO_LOCNOAPO Locationnvarchar200CHAR(N' ')Yes/LIME/APO_LOCNO Allow NULL? 
33PARTNERPartnernvarchar100CHAR(N' ')Yes*/LIME/PARTNER Allow NULL? 
34PARTNER_ROLEPartner Rolenvarchar20CHAR(N' ')Yes/LIME/PARTNER_ROLE Allow NULL? 
35MOTIDMeans of Transport Identifiernvarchar350CHAR(N' ')Yes/LIME/MDL_MOTID Allow NULL? 
36MOTSCODEStandard Code Means of Transport Acc.To UN/EDIFACT 8179nvarchar40CHAR(N' ')Yes/LIME/MDL_MOTSCODE Allow NULL? 
37/SAPSLL/ECPIDCustoms ID for Customs Procedure with Economic Significancenvarchar100CHAR(N' ')Yes*/SAPSLL/ECPID_SPI Allow NULL? 
38IDX_STOCKCurrent Nummer of Key Tablenvarchar30CHAR(N' ')Yes/LIME/KEY_INDEX Allow NULL? 
39GUID_STOCKGUID Stock Itemvarbinary160RAWYes/LIME/GUID_STOCK
40MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
41CHARGBatch Numbernvarchar100CHAR(N' ')Yes*CHARG_D Allow NULL? 
42OWNEROwnernvarchar100CHAR(N' ')Yes*/LIME/OWNER Allow NULL? 
43OWNER_ROLEPartner Role of Ownernvarchar20CHAR(N' ')Yes/LIME/OWNER_ROLE Allow NULL? 
44GTINGlobal Trade Item Number (GTIN)nvarchar140NUMC(N'00000000000000')Yes/LIME/GTIN Allow NULL? 
45GTIN_VARIANTGlobal Trade Item Number (GTIN) Variantnvarchar20NUMC(N'00')Yes/LIME/GTIN_VARIANT Allow NULL? 
46CATStock Typenvarchar20CHAR(N' ')Yes/LIME/STOCK_CATEGORY Allow NULL? 
47STOCK_USAGEStock Usagechar10CHAR(N' ')Yes/LIME/STOCK_USAGE Allow NULL? 
48SALES_ORD_STOCKSales Order for Stocknvarchar100CHAR(N' ')Yes*/LIME/SALES_ORD_STOCK Allow NULL? 
49S_ORD_ITEM_STOCKSales Order Item for Stocknvarchar60NUMC(N'000000')Yes/LIME/S_ORD_ITEM_STOCK Allow NULL? 
50WBS_STOCKWBS Element for Stocknvarchar240CHAR(N' ')Yes/LIME/WBS_STOCK Allow NULL? 
51VRSIOIDGUID for Planning Versionvarbinary160RAWYes/LIME/MDL_VRSIOID
52PRDIDGUID for Productvarbinary160RAWYes/LIME/MDL_PRDID
53APO_MATNRAPO Material Numbernvarchar400CHAR(N' ')Yes/LIME/APO_MATNR Allow NULL? 
54/SAPSLL/LOGSYSLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
55/SAPSLL/GUID_PRProduct GUID im 'RAW' Formatvarbinary160RAWYes/SAPSLL/IVM_GUID_PRODUCT
56/SAPSLL/COOProduct's Country of Originnvarchar30CHAR(N' ')Yes*/SAPSLL/IVM_COO Allow NULL? 
57/SAPSLL/IDGDSAdditional ID for Stock Separation in CWH, IP, PUCCnvarchar200CHAR(N' ')Yes/SAPSLL/IDGDS Allow NULL? 
58/SAPSLL/LOCIDLocation IDnvarchar30CHAR(N' ')Yes/SAPSLL/IVM_LOCID Allow NULL? 
59/SAPSLL/GUID_ITMItem GUID in 'RAW' Formatvarbinary160RAWYes/SAPSLL/IVM_GUID_DOC_ITEM
60/SAPSLL/FIFODate of Release for FIFOnvarchar80DATS(N'00000000')Yes/SAPSLL/IVM_FIFO_DATE Allow NULL? 
61IDX_HUCurrent Nummer of Key Tablenvarchar30CHAR(N' ')Yes/LIME/KEY_INDEX Allow NULL? 
62GUID_HUGUID Handling Unitvarbinary160RAWYes/LIME/GUID_HU
63SSCCSerial Shipping Container Code (NVE, Number Package)nvarchar180NUMC(N'000000000000000000')Yes/LIME/SSCC Allow NULL? 
64QUANStock Quantitydecimal3114QUAN((0))Yes/LIME/QUANTITY
65QUAN_PREVStock Quantitydecimal3114QUAN((0))Yes/LIME/QUANTITY
66PREV_INDCheck Previous Stock Quantity if = 'X'char10CHAR(N' ')Yes/LIME/PREV_IND Allow NULL? 
67UNITStock Unit of Measurenvarchar30UNIT(N' ')Yes*/LIME/UNIT Allow NULL? 
68STOCKUNITIndicator for Inventory-Managed Quantitieschar10CHAR(N' ')Yes/LIME/STOCKUNIT Allow NULL? 
69NOCALCIndicator to Control Quantity Calculationchar10CHAR(N' ')Yes/LIME/NOCALC Allow NULL? 
70SERIALUNITSerial-Number-Relevant Unit of Measurechar10CHAR(N' ')Yes/LIME/SERIALUNIT Allow NULL? 
71VALUATIONUNITUnit is Relevant for Valuationchar10CHAR(N' ')Yes/LIME/VALUATIONUNIT Allow NULL? 
72PO_NUMBERPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
73PO_ITEMItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
74PO_COMPLETEObsolete With SCM4.1char10CHAR(N' ')Yes/LIME/OBSOLET_PO_COMPLETE Allow NULL? 
75ORDER_NUMBEROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
76ORDER_ITEMOrder Item Numbernvarchar40NUMC(N'0000')YesCO_POSNR Allow NULL? 
77ORDER_COMPLETEObsolete With SCM4.1char10CHAR(N' ')Yes/LIME/OBSOLET_ORDER_COMPLETE Allow NULL? 
78DELIVERYSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
79DELIVERY_ITEMItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
80DELIV_COMPLETEObsolete With SCM4.1char10CHAR(N' ')Yes/LIME/OBSOLET_DELIV_COMPLETE Allow NULL? 
81MAT_DOCR/3 Material Documentnvarchar100CHAR(N' ')Yes/LIME/MAT_DOC Allow NULL? 
82MAT_DOC_YEARMaterial Document Yearnvarchar40NUMC(N'0000')Yes/LIME/MAT_DOC_YEAR Allow NULL? 
83MAT_DOC_ITEMItem in Material Documentnvarchar40NUMC(N'0000')Yes/LIME/MAT_DOC_ITEM Allow NULL? 
84RESERV_NONumber of Reservation/Dependent Requirementnvarchar100NUMC(N'0000000000')Yes*RSNUM Allow NULL? 
85RES_ITEMItem Number of Reservation/Dependent Requirementnvarchar40NUMC(N'0000')YesRSPOS Allow NULL? 
86RES_TYPERecord typechar10CHAR(N' ')YesRSART Allow NULL? 
87RES_COMPLETEObsolete With SCM4.1char10CHAR(N' ')Yes/LIME/OBSOLET_KZEAR Allow NULL? 
88TOP_LEVELLocation at Highest Hierarchy Levelchar10CHAR(N' ')Yes/LIME/TOP_LEVEL Allow NULL? 
89GUID_COLL_GROUPGUID for Collection Groupingvarbinary160RAWYes/LIME/GUID_COLL_GROUP
90COSTCENTERCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
91ORDERIDOrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
92ORDER_ITNOOrder Item Numbernvarchar40NUMC(N'0000')YesCO_POSNR Allow NULL? 
93WBS_ELEMENTWork Breakdown Structure Element (WBS Element)nvarchar240CHAR(N' ')YesPS_POSID Allow NULL? 
94NETWORKNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
95SALES_ORDSales Order Numbernvarchar100CHAR(N' ')Yes*KDAUF Allow NULL? 
96SCHED_LINEDelivery Schedule for Sales Ordernvarchar40NUMC(N'0000')YesKDEIN Allow NULL? 
97S_ORD_ITEMItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
98ACTIVITYOperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
99CMMT_ITEMCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
100ASSETMAINNOMain Asset Numbernvarchar120CHAR(N' ')YesBF_ANLN1 Allow NULL? 
101ASSETSUBNOAsset Subnumbernvarchar40CHAR(N' ')YesBF_ANLN2 Allow NULL? 
102FUNDS_CTRFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
103GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
104FUNC_AREAFunctional Areanvarchar40CHAR(N' ')YesFKBER_SHORT Allow NULL? 
105ACTTYPEActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
106GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
107APO_MATNR_TAPO Material Numbernvarchar400CHAR(N' ')Yes/LIME/APO_MATNR Allow NULL? 
108OWNER_TOwnernvarchar100CHAR(N' ')Yes*/LIME/OWNER Allow NULL? 
109OWNER_ROLE_TPartner Role of Ownernvarchar20CHAR(N' ')Yes/LIME/OWNER_ROLE Allow NULL? 
110CAT_TStock Typenvarchar20CHAR(N' ')Yes/LIME/STOCK_CATEGORY Allow NULL? 
111APO_LOCNO_TAPO Locationnvarchar200CHAR(N' ')Yes/LIME/APO_LOCNO Allow NULL? 
112BUS_TRANS_TYPENot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40CHAR(N' ')YesCHAR4 Allow NULL? 
113DOC_ID_1Document ID of Reference Documentnvarchar700CHAR(N' ')Yes/LIME/REF_DOC_ID Allow NULL? 
114DOC_TYPE_1Document Type of Reference Documentnvarchar100CHAR(N' ')Yes/LIME/REF_DOC_TYPE Allow NULL? 
115DOC_LOGSYS_1Logical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
116DOC_ID_2Document ID of Reference Documentnvarchar700CHAR(N' ')Yes/LIME/REF_DOC_ID Allow NULL? 
117DOC_TYPE_2Document Type of Reference Documentnvarchar100CHAR(N' ')Yes/LIME/REF_DOC_TYPE Allow NULL? 
118DOC_LOGSYS_2Logical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
NamePrimaryUniqueTypeColumns
/LIME/COLL_FIN~0YesYesCLUSTEREDGUID_COLL, MANDT
/LIME/COLL_FIN~ANoNoNONCLUSTEREDGUID_PN, MANDT
/LIME/COLL_FIN~BNoNoNONCLUSTEREDDISPATCH_TIME, GUID_DISPATCH, MANDT
/LIME/COLL_FIN~CNoNoNONCLUSTEREDGUID_DISPATCH, MATNR, WERKS, 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