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  | CMS_MOVABLES
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
Financial Services :: Collateral Management System :: Master Data :: Movables
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CMS_MOVABLES672Movable Details - Vehicles, Devices & AircraftMovables
SQL:  selectupdate insert create

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

SELECT MANDT, MOV_GUID, MOV_CATEGORY, MOV_TYP, MOV_ID, MOV_DESC, MOV_IDT_ACC, MOV_MODEL_NAM, MOV_MANUFACTURER, MOV_MANU_DAT, ADDR_ID, MOV_LOC_DESC, MOV_LOC_DE_RMRK, MOV_IDEN_TYP, MOV_DESC_COL_MAT, MOV_DOP, MOV_IDENT, MOV_UOB, MOV_MANU_CNTRY, MOV_TYPE_FEAT, EXT_ITM_NO, EXT_REFERENCE, IS_TEMPLATE, TEMPLATE_ID, DEV_COUNTRY_KEY, DEV_MAC_NO, ACR_DELVDAT, ACR_REG, ACR_REGC, ACR_REGM, ACR_RC, ACR_EMAN, ACR_EMOD, ACR_EPOOL, ACR_EPRMK, ACR_NOE, ACR_NAME, ACR_MTOW, ACR_MTOW_UNT, ACR_NOB, ACR_MSNNO, ACR_RATCLS, ACR_RATD, PERM_WGHT, PERM_WGHT_UNT, PLACE_LIC, VEH_REG_NO, OFF_IDENT, CHAIS_NO, IDEN_ACC, BILL_NO, UNIT_PRICE, UNIT_PRICE_CURR, TYPE_STK_EXCH, STK_EXCH_ID, RATE_FIX_DAT, DET_PRICE, DET_CURR, STOCK_QUANTITY, STOCK_UOM, ADMIN_ORG_UNIT, BANKAREA, CREATED_BY, CREATED_AT, CHANGED_BY, CHANGED_AT, SOURCEOFENTRY FROM CMS_MOVABLES
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2MOV_GUIDGUID for CMS_MOVABLESvarbinary160RAWNoCMS_DTE_MOV_GUID
3MOV_CATEGORYObject Categorynvarchar60CHAR(N' ')YesTCMS_MOV_TYPCMS_DTE_OMS_OBJ_CAT Allow NULL? 
4MOV_TYPMovable typesnvarchar60CHAR(N' ')YesTCMS_MOV_TYPCMS_DTE_MOV_TYP Allow NULL? 
5MOV_IDIdentification Numbernvarchar400CHAR(N' ')YesCMS_DTE_MOV_ID Allow NULL? 
6MOV_DESCDescription of the objectnvarchar300CHAR(N' ')YesCMS_DTE_MOV_DESC Allow NULL? 
7MOV_IDT_ACCIdentification accessorieschar10CHAR(N' ')YesCMS_DTE_MOV_IDT_ACC Allow NULL? 
8MOV_MODEL_NAMTechnical Category/Category term/Descriptionnvarchar300CHAR(N' ')YesCMS_DTE_MOV_MODEL_NAM Allow NULL? 
9MOV_MANUFACTURERObject Manufacturer Buildernvarchar300CHAR(N' ')YesCMS_DTE_MOV_MANUFACTURER Allow NULL? 
10MOV_MANU_DATDate of the Manufacture/Purchasenvarchar80DATS(N'00000000')YesCMS_DTE_MOV_MANU_DAT Allow NULL? 
11ADDR_IDLocation / Addressnvarchar100CHAR(N' ')Yes*CMS_DTE_MOV_LOCATION Allow NULL? 
12MOV_LOC_DESCLocation Descriptionnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_MOV_LOC_DESC Allow NULL? 
13MOV_LOC_DE_RMRKRemark Field for Location Descriptionnvarchar300CHAR(N' ')YesCMS_DTE_MOV_LOC_DESC_RMRK Allow NULL? 
14MOV_IDEN_TYPType of identification / Marking of the collateral materialnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_MOV_TYPE_IDENT Allow NULL? 
15MOV_DESC_COL_MATBank's Own Identifcationnvarchar300CHAR(N' ')YesCMS_DTE_OMS_DESC_IDENT_COL_MAT Allow NULL? 
16MOV_DOPDate of Purchasenvarchar80DATS(N'00000000')YesCMS_DTE_MOV_DOP Allow NULL? 
17MOV_IDENTCommercial usagenvarchar20CHAR(N' ')YesCMS_DTE_MOV_IDENT Allow NULL? 
18MOV_UOBUse of the objectnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_MOV_UOB Allow NULL? 
19MOV_MANU_CNTRYManufacturing Countrynvarchar30CHAR(N' ')YesT005CMS_DTE_MOV_MANU_CNTRY Allow NULL? 
20MOV_TYPE_FEATClassificationnvarchar60CHAR(N' ')YesTCMS_OMS_FEATCMS_DTE_MOV_TYPE_FEAT Allow NULL? 
21EXT_ITM_NOExt. Item no / Number for identification of the objectsnvarchar400CHAR(N' ')YesCMS_DTE_OMS_EXT_ITM_NO Allow NULL? 
22EXT_REFERENCEReference number for the legacy systemnvarchar320CHAR(N' ')YesCMS_DTE_OMS_REF_ID Allow NULL? 
23IS_TEMPLATEType to be used as templatechar10CHAR(N' ')YesCMS_DTE_MOV_FLG_TEMPLATE Allow NULL? 
24TEMPLATE_IDTemplate IDvarbinary160RAWYesCMS_DTE_MOV_TEMPLATE_ID
25DEV_COUNTRY_KEYCountry Keynvarchar30CHAR(N' ')YesT005CMS_DTE_MOV_COUNTRY_KEY Allow NULL? 
26DEV_MAC_NOExternal Item Number - Machine numbernvarchar400CHAR(N' ')YesCMS_DTE_MOV_MACHINE_NO Allow NULL? 
27ACR_DELVDATDelivery Datenvarchar80DATS(N'00000000')YesCMS_DTE_MOV_DELVDAT Allow NULL? 
28ACR_REGRegisteredchar10CHAR(N' ')YesCMS_DTE_MOV_REG Allow NULL? 
29ACR_REGCRegistration Countrynvarchar30CHAR(N' ')YesT005CMS_DTE_MOV_REGC Allow NULL? 
30ACR_REGMRegistration Marknvarchar60CHAR(N' ')YesCMS_DTE_MOV_REGM Allow NULL? 
31ACR_RCRegistration Commentsnvarchar300CHAR(N' ')YesCMS_DTE_MOV_RC Allow NULL? 
32ACR_EMANEngine Manufacturernvarchar300CHAR(N' ')YesCMS_DTE_MOV_EMAN Allow NULL? 
33ACR_EMODEngine Modelnvarchar120CHAR(N' ')YesCMS_DTE_MOV_EMOD Allow NULL? 
34ACR_EPOOLEngine poolingnvarchar100CHAR(N' ')YesCMS_DTE_MOV_EPOOL Allow NULL? 
35ACR_EPRMKEngine pooling remarksnvarchar300CHAR(N' ')YesCMS_DTE_MOV_EPRMK Allow NULL? 
36ACR_NOENumber of Enginesint100INT4((0))YesCMS_DTE_MOV_NOE Allow NULL? 
37ACR_NAMEObject namenvarchar300CHAR(N' ')YesCMS_DTE_MOV_OM Allow NULL? 
38ACR_MTOWMaximum take-off weightdecimal133QUAN((0))YesCMS_DTE_MOV_MTOW
39ACR_MTOW_UNTMaximum take off weight (Unit)nvarchar30UNIT(N' ')YesT006CMS_DTE_MOV_MTOW_UNT Allow NULL? 
40ACR_NOBNumber of objectstinyint30INT1((0))YesCMS_DTE_MOV_NOB
41ACR_MSNNOMSN Numbernvarchar100CHAR(N' ')YesCMS_DTE_MOV_MSNNO Allow NULL? 
42ACR_RATCLSRating Classnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_MOV_RATCLS Allow NULL? 
43ACR_RATDRating Datenvarchar80DATS(N'00000000')YesCMS_DTE_MOV_RATD Allow NULL? 
44PERM_WGHTMaximum Permissible Weightdecimal133QUAN((0))YesCMS_DTE_MOV_PERM_WGHT
45PERM_WGHT_UNTUnit of the quantitynvarchar30UNIT(N' ')YesT006CMS_DTE_MOV_PERM_WGHT_UNT Allow NULL? 
46PLACE_LICPlace of Registrationnvarchar300CHAR(N' ')YesCMS_DTE_MOV_PLACE_LIC Allow NULL? 
47VEH_REG_NOVehicle registration marknvarchar300CHAR(N' ')YesCMS_DTE_MOV_REG_NO Allow NULL? 
48OFF_IDENTIdentification of the registration certificatenvarchar300CHAR(N' ')YesCMS_DTE_MOV_OFF_IDENT Allow NULL? 
49CHAIS_NOChassis Numbernvarchar300CHAR(N' ')YesCMS_DTE_MOV_CHASIS_NO Allow NULL? 
50IDEN_ACCIdentification land accessorieschar10CHAR(N' ')YesCMS_DTE_INV_IDEN_ACC Allow NULL? 
51BILL_NOBill number of the inventorynvarchar200CHAR(N' ')YesCMS_DTE_INV_BILL_NO Allow NULL? 
52UNIT_PRICEUnit Pricedecimal172CURR((0))YesCMS_DTE_INV_UNIT_PRICE
53UNIT_PRICE_CURRCurrency for unit pricenvarchar50CUKY(N' ')YesTCURCCMS_DTE_INV_UNIT_CURR Allow NULL? 
54TYPE_STK_EXCHType of stock exchangenvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_INV_TYPE_STK_EXCH Allow NULL? 
55STK_EXCH_IDPlace of stock exchangenvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_INV_STK_EXCH_ID Allow NULL? 
56RATE_FIX_DATDate of previous quotationnvarchar80DATS(N'00000000')YesCMS_DTE_INV_RATE_FIX_DAT Allow NULL? 
57DET_PRICEDetermined pricedecimal172CURR((0))YesCMS_DTE_INV_DET_PRICE
58DET_CURRCurrency for determined pricenvarchar50CUKY(N' ')YesTCURCCMS_DTE_INV_DET_CURR Allow NULL? 
59STOCK_QUANTITYQuantity of inventorydecimal133QUAN((0))YesCMS_DTE_INV_QTY
60STOCK_UOMUnit of Measure of Quantitynvarchar30UNIT(N' ')YesT006CMS_DTE_UNIT Allow NULL? 
61ADMIN_ORG_UNITAdministration Organizational Unitnvarchar120CHAR(N' ')YesCMS_DTE_ADMINORG Allow NULL? 
62BANKAREABank Area in Collateral Managementnvarchar40CHAR(N' ')Yes*CMS_DTE_BANKAREA Allow NULL? 
63CREATED_BYLogin ID of the User who created the Recordnvarchar120CHAR(N' ')YesCMS_DTE_USER Allow NULL? 
64CREATED_ATCreation Timestampdecimal150DEC((0))YesCMS_DTE_CREATED_AT
65CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')YesCMS_DTE_LAST_CHNG_USER Allow NULL? 
66CHANGED_ATChange Timestampdecimal150DEC((0))YesCMS_DTE_CHANGED_AT
67SOURCEOFENTRYSource of Entrynvarchar320CHAR(N' ')YesCMS_DTE_SOURCE_OF_ENTRY Allow NULL? 
NamePrimaryUniqueTypeColumns
CMS_MOVABLES~0YesYesCLUSTEREDMOV_GUID, MANDT
CMS_MOVABLES~SKYNoNoNONCLUSTEREDMOV_ID, MOV_TYP, MOV_CATEGORY, 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