I_MovableObjectMasterData

Movable Object Details | view: IMOVOBJMDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_MOVABLES
Column Name Description
MovableObjectUUID GUID for CMS_MOVABLES
Column Name Description
💲 Currency for unit price (InventoryObjectUnitCurrency):
InventoryObjectUnitAmount Unit Price
💲 Currency for determined price (InventoryObjectDeterminedCrcy):
InventoryObjectDeterminedAmt Determined price
Column Name Description
📏 Maximum take off weight (Unit) (AircraftObjMaxTakeoffWgtUnit):
AircraftObjectMaxTakeoffWeight Maximum take-off weight
📏 Unit of the quantity (VehObjMaxPermissibleWgtUnit):
VehicleObjMaxPermissibleWeight Maximum Permissible Weight
📏 Unit of Measure of Quantity (InventoryObjStockUnitMeasure):
InventoryObjectStockQuantity Quantity of inventory
Column Name Description
MovableObjectManufactureDate Date of the Manufacture/Purchase
MovableObjectPurchaseDate Date of Purchase
AircraftObjectDeliveryDate Delivery Date
AircraftObjectRatingDate Rating Date
InventoryObjPrevQuotationDate Date of previous quotation
Column Name Description
MovableObjectIsAccessory Identification accessories Show values
MovableObjectCommercialUsage Commercial usage Show values
AircraftObjectIsRegistered Registered Show values
Column Name Description Domain name
MovableObjectID Identification Number CMS_MOV_ID
MovableObjectDescription Description of the object CMS_MOV_DESC
MovableObjectModelName Technical Category/Category term/Description CMS_MOV_MODEL_NAM
MovableObjectManufacturerName Object Manufacturer Builder CMS_MOV_MANUFACTURER
MovableObjectAddressID Location / Address AD_ADDRNUM
MovableObjectLocationComment Remark Field for Location Description CMS_MOV_LOC_DESC_RMRK
MovableObjectBankIdnDesc Bank's Own Identifcation CMS_OMS_DESC_COL_MAT
MovableObjectExtRefNumber Ext. Item no / Number for identification of the objects CMS_OMS_ID
DeviceObjectMachineNumber External Item Number - Machine number CMS_MOV_ID
AircraftObjectRegistrationMark Registration Mark CMS_MOV_REGM
AircraftObjectRegnCmnt Registration Comments CMS_MOV_RC
AircraftObjectEngnMfrName Engine Manufacturer CMS_MOV_EMAN
AircraftObjectEngineModelName Engine Model CMS_MOV_EMOD
AircraftObjEngnPoolingTtl Engine pooling CMS_MOV_EPOOL
AircraftObjEngnPoolingCmnt Engine pooling remarks CMS_MOV_EPRMK
AircraftObjectNumberOfEngines Number of Engines CMS_MOV_NOE
AircraftObjectName Object name CMS_MOV_OM
AircraftObjectMfrSerialNmbr MSN Number CMS_MOV_MSNNO
VehicleObjectRegnLocDesc Place of Registration CMS_PLACE_LIC
VehicleObjectRegistrationMark Vehicle registration mark CMS_REG_NO
VehicleObjectRegistrationDocID Identification of the registration certificate CMS_VEH_OFF_IDENT
VehicleObjectChassisNumber Chassis Number CMS_MOV_DESC
InventoryObjectBillNumber Bill number of the inventory CMS_INV_BILL_NO
CollateralAdminOrgUnit Administration Organizational Unit TEXT12
MovableObjectCreatedDateTime Creation Timestamp TZNTSTMPS
MovableObjLastChangedDateTime Change Timestamp TZNTSTMPS
Master Data Relations Join Conditions
Rating Class
  • Rating Class
  • Client
  • ?
  • I_MOVABLEOBJECTMASTERDATA.AIRCRAFTOBJECTRATINGCLASS == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_MOVABLEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
Registration Country/Region
  • Client
  • Registration Country/Region
  • I_MOVABLEOBJECTMASTERDATA.MANDT == T005.MANDT
  • I_MOVABLEOBJECTMASTERDATA.AIRCRAFTOBJECTREGNCNTRY == T005.LAND1
Maximum take off weight (Unit)
  • Maximum take off weight (Unit)
  • Client
  • I_MOVABLEOBJECTMASTERDATA.AIRCRAFTOBJMAXTAKEOFFWGTUNIT == T006.MSEHI
  • I_MOVABLEOBJECTMASTERDATA.MANDT == T006.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_MOVABLEOBJECTMASTERDATA.MANDT == T005.MANDT
  • I_MOVABLEOBJECTMASTERDATA.DEVICEOBJECTCOUNTRYKEY == T005.LAND1
Currency for determined price
  • Currency for determined price
  • Client
  • I_MOVABLEOBJECTMASTERDATA.INVENTORYOBJECTDETERMINEDCRCY == TCURC.WAERS
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCURC.MANDT
Currency for unit price
  • Currency for unit price
  • Client
  • I_MOVABLEOBJECTMASTERDATA.INVENTORYOBJECTUNITCURRENCY == TCURC.WAERS
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCURC.MANDT
Place of stock exchange
  • Client
  • Place of stock exchange
  • ?
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_MOVABLEOBJECTMASTERDATA.INVENTORYOBJSTOCKEXCHANGEPLACE == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_MOVABLEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
Type of stock exchange
  • Client
  • ?
  • Type of stock exchange
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_MOVABLEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_MOVABLEOBJECTMASTERDATA.INVENTORYOBJSTOCKEXCHANGETYPE == TCMS_ATT_ID_TY.INDICATOR_TYPE
Unit of Measure of Quantity
  • Client
  • Unit of Measure of Quantity
  • I_MOVABLEOBJECTMASTERDATA.MANDT == T006.MANDT
  • I_MOVABLEOBJECTMASTERDATA.INVENTORYOBJSTOCKUNITMEASURE == T006.MSEHI
Type of identification / Marking of the collateral material
  • Client
  • Type of identification / Marking of the collateral material
  • ?
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTBANKIDNTYPE == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_MOVABLEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
Object Category
  • Client
  • Movable types
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_MOV_TYP.MANDT
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTTYPE == TCMS_MOV_TYP.MOV_CATEGORY
Classification
  • Classification
  • Client
  • Object Category
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTCLASSIFICATION == TCMS_OMS_FEAT.TYPE_FEAT
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_OMS_FEAT.MANDT
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTCATEGORY == TCMS_OMS_FEAT.CATEGORYID
Location Description
  • Client
  • Location Description
  • ?
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTLOCATION == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_MOVABLEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
Manufacturing Country/Region
  • Client
  • Manufacturing Country/Region
  • I_MOVABLEOBJECTMASTERDATA.MANDT == T005.MANDT
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTMFGCNTRY == T005.LAND1
Movable types
  • Client
  • Movable types
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_MOV_TYP.MANDT
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTTYPE == TCMS_MOV_TYP.MOV_CATEGORY
Use of the object
  • Client
  • ?
  • Use of the object
  • I_MOVABLEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_MOVABLEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_MOVABLEOBJECTMASTERDATA.MOVABLEOBJECTUSE == TCMS_ATT_ID_TY.INDICATOR_TYPE
Unit of the quantity
  • Client
  • Unit of the quantity
  • I_MOVABLEOBJECTMASTERDATA.MANDT == T006.MANDT
  • I_MOVABLEOBJECTMASTERDATA.VEHOBJMAXPERMISSIBLEWGTUNIT == T006.MSEHI