I_TechnicalobjectTP

DDL: I_TECHNICALOBJECTTP SQL: ITECHNICALO000TP Type: view TRANSACTIONAL

Technical Object with Draft

I_TechnicalobjectTP is a Transactional CDS View that provides data about "Technical Object with Draft" in SAP S/4HANA. It reads from 1 data source (I_TechnicalObject) and exposes 74 fields with key fields TechnicalObject, TechObjIsEquipOrFuncnlLoc. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TechnicalObject I_TechnicalObject from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_FunctionalLocation _FunctionalLocationExtension _FunctionalLocationExtension.FunctionalLocation = $projection.FunctionalLocation
[0..1] E_Equipment _EquipmentExtension _EquipmentExtension.Equipment = $projection.Equipment
[0..1] I_TechObjCustWrntyAssgmt _CustWrntyObjAssgmt _CustWrntyObjAssgmt.ObjectInternalID = $projection.MaintObjectInternalID
[0..1] I_TechObjVndrWrntyAssgmt _VndrWrntyObjAssgmt _VndrWrntyObjAssgmt.ObjectInternalID = $projection.MaintObjectInternalID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ITECHNICALO000TP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Technical Object with Draft view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence TECHNICALOBJEC_D view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObject I_TechnicalObject TechnicalObject
KEY TechObjIsEquipOrFuncnlLoc I_TechnicalObject TechObjIsEquipOrFuncnlLoc
TechnicalObjectLabel I_TechnicalObject TechnicalObjectLabel
IsEquipOrFuncnlLocForEdit I_TechnicalObject TechObjIsEquipOrFuncnlLoc
TechnicalObjectForEdit I_TechnicalObject TechnicalObject
TechnicalObjectCategory I_TechnicalObject TechnicalObjectCategory
Equipment I_TechnicalObject Equipment
FunctionalLocation I_TechnicalObject FunctionalLocation
TechnicalObjectType I_TechnicalObject TechnicalObjectType
CreatedByUser I_TechnicalObject CreatedByUser
CreationDate I_TechnicalObject CreationDate
LastChangedByUser I_TechnicalObject LastChangedByUser
LastChangeDate I_TechnicalObject LastChangeDate
AssetManufacturerName I_TechnicalObject AssetManufacturerName
ManufacturerPartTypeName I_TechnicalObject ManufacturerPartTypeName
MaintenancePlanningPlant I_TechnicalObject MaintenancePlanningPlant
MaintenancePlannerGroup I_TechnicalObject MaintenancePlannerGroup
CatalogProfile I_TechnicalObject CatalogProfile
AuthorizationGroup I_TechnicalObject AuthorizationGroup
WorkCenterInternalID I_TechnicalObject WorkCenterInternalID
WorkCenterTypeCode I_TechnicalObject WorkCenterTypeCode
MaintObjectLocAcctAssgmtNmbr I_TechnicalObject MaintObjectLocAcctAssgmtNmbr
ManufacturerCountry I_TechnicalObject ManufacturerCountry
ConstructionYear I_TechnicalObject ConstructionYear
ConstructionMonth I_TechnicalObject ConstructionMonth
AcquisitionDate I_TechnicalObject AcquisitionDate
Currency I_TechnicalObject Currency
AcquisitionValue I_TechnicalObject AcquisitionValue
TechnicalObjectSortCode I_TechnicalObject TechnicalObjectSortCode
MaintObjectInternalID I_TechnicalObject MaintObjectInternalID
IsDeleted I_TechnicalObject IsDeleted
SizeOrDimensionText I_TechnicalObject SizeOrDimensionText
InventoryNumber I_TechnicalObject InventoryNumber
GrossWeight I_TechnicalObject GrossWeight
GrossWeightUnit I_TechnicalObject GrossWeightUnit
ManufacturerPartNmbr I_TechnicalObject ManufacturerPartNmbr
ManufacturerSerialNumber I_TechnicalObject ManufacturerSerialNumber
TechnicalObjectDescription I_TechnicalObject TechnicalObjectDescription
TechnicalObjectHasLongText I_TechnicalObject TechnicalObjectHasLongText
SuperiorTechnicalObject I_TechnicalObject SuperiorTechnicalObject
SuperiorTechnicalObjectLabel I_TechnicalObject SuperiorTechnicalObjectLabel
SuperiorTechnicalObjectName I_TechnicalObject SuperiorTechnicalObjectName
SuperiorObjIsEquipOrFuncnlLoc I_TechnicalObject SuperiorObjIsEquipOrFuncnlLoc
TechObjCustomerMasterWarranty _CustWrntyObjAssgmt TechObjCustomerMasterWarranty
TechObjCustWarrantyStartDate _CustWrntyObjAssgmt TechObjCustWarrantyStartDate
TechObjCustWarrantyEndDate _CustWrntyObjAssgmt TechObjCustWarrantyEndDate
TechObjIsCustWarrantyPassedOn _CustWrntyObjAssgmt TechObjIsCustWarrantyPassedOn
TechObjIsCustWarrantyInherited _CustWrntyObjAssgmt TechObjIsCustWarrantyInherited
TechObjSupplierMasterWarranty _VndrWrntyObjAssgmt TechObjSupplierMasterWarranty
TechObjSuplrWarrantyStartDate _VndrWrntyObjAssgmt TechObjSuplrWarrantyStartDate
TechObjSuplrWarrantyEndDate _VndrWrntyObjAssgmt TechObjSuplrWarrantyEndDate
TechObjIsSuplrWarrantyPassedOn _VndrWrntyObjAssgmt TechObjIsSuplrWarrantyPassedOn
TechObjIsSuplrWrntyInherited _VndrWrntyObjAssgmt TechObjIsSuplrWrntyInherited
_CreatedByUser I_TechnicalObject _CreatedByUser
_LastChangedByUser I_TechnicalObject _LastChangedByUser
_WorkCenterType I_TechnicalObject _WorkCenterType
_WorkCenter I_TechnicalObject _WorkCenter
_LocationAccountAssignment I_TechnicalObject _LocationAccountAssignment
_TechnicalObjectType I_TechnicalObject _TechnicalObjectType
_Equipment I_TechnicalObject _Equipment
_FunctionalLocation I_TechnicalObject _FunctionalLocation
_FunctionalLocationLabel I_TechnicalObject _FunctionalLocationLabel
_MaintenancePlanningPlant I_TechnicalObject _MaintenancePlanningPlant
_TechObjIsEquipOrFuncnlLoc I_TechnicalObject _TechObjIsEquipOrFuncnlLoc
_TechnicalObjectText I_TechnicalObject _TechnicalObjectText
_TechnicalObjectCategory I_TechnicalObject _TechnicalObjectCategory
_MaintenancePlannerGroup I_TechnicalObject _MaintenancePlannerGroup
_ManufacturerCountry I_TechnicalObject _ManufacturerCountry
_Currency I_TechnicalObject _Currency
_TechnicalObjectHierarchy I_TechnicalObject _TechnicalObjectHierarchy
_IsDeleted I_TechnicalObject _IsDeleted
_StatusObjectActiveStatus I_TechnicalObject _StatusObjectActiveStatus
_CustWrntyObjAssgmt _CustWrntyObjAssgmt
_VndrWrntyObjAssgmt _VndrWrntyObjAssgmt
@AbapCatalog.sqlViewName: 'ITECHNICALO000TP'
@AbapCatalog.compiler.compareFilter:true
@EndUserText.label: 'Technical Object with Draft'
@ObjectModel.compositionRoot: true
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.draftEnabled: true
@ObjectModel.writeDraftPersistence: 'TECHNICALOBJEC_D'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API //It is necessary for eliminating ATC

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.createEnabled: true //It is necessary for mass change.

@ObjectModel.updateEnabled: true //It is necessary for mass change.

@ObjectModel.deleteEnabled: false
@ObjectModel.semanticKey: ['TechnicalObject', 'TechObjIsEquipOrFuncnlLoc']
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

define view I_TechnicalobjectTP
  as select from I_TechnicalObject

  -- Extensions, do not expose as association:
  association [0..1] to E_FunctionalLocation     as _FunctionalLocationExtension on _FunctionalLocationExtension.FunctionalLocation = $projection.FunctionalLocation
  association [0..1] to E_Equipment              as _EquipmentExtension          on _EquipmentExtension.Equipment = $projection.Equipment

  association [0..1] to I_TechObjCustWrntyAssgmt as _CustWrntyObjAssgmt          on _CustWrntyObjAssgmt.ObjectInternalID = $projection.MaintObjectInternalID
  association [0..1] to I_TechObjVndrWrntyAssgmt as _VndrWrntyObjAssgmt          on _VndrWrntyObjAssgmt.ObjectInternalID = $projection.MaintObjectInternalID

{

  key I_TechnicalObject.TechnicalObject,

  key I_TechnicalObject.TechObjIsEquipOrFuncnlLoc,

      I_TechnicalObject.TechnicalObjectLabel,

      I_TechnicalObject.TechObjIsEquipOrFuncnlLoc        as IsEquipOrFuncnlLocForEdit,

      I_TechnicalObject.TechnicalObject                  as TechnicalObjectForEdit,

      I_TechnicalObject.TechnicalObjectCategory,

      I_TechnicalObject.Equipment,

      I_TechnicalObject.FunctionalLocation,

      I_TechnicalObject.TechnicalObjectType,

      I_TechnicalObject.CreatedByUser,

      I_TechnicalObject.CreationDate,

      I_TechnicalObject.LastChangedByUser,

      I_TechnicalObject.LastChangeDate,

      I_TechnicalObject.AssetManufacturerName,

      I_TechnicalObject.ManufacturerPartTypeName,

      I_TechnicalObject.MaintenancePlanningPlant,

      I_TechnicalObject.MaintenancePlannerGroup,

      I_TechnicalObject.CatalogProfile,

      I_TechnicalObject.AuthorizationGroup,

      I_TechnicalObject.WorkCenterInternalID,

      I_TechnicalObject.WorkCenterTypeCode,

      I_TechnicalObject.MaintObjectLocAcctAssgmtNmbr,

      I_TechnicalObject.ManufacturerCountry,

      I_TechnicalObject.ConstructionYear,

      I_TechnicalObject.ConstructionMonth,

      I_TechnicalObject.AcquisitionDate,

      I_TechnicalObject.Currency,

      I_TechnicalObject.AcquisitionValue,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      I_TechnicalObject.TechnicalObjectSortCode,

      I_TechnicalObject.MaintObjectInternalID,

      I_TechnicalObject.IsDeleted,

      I_TechnicalObject.SizeOrDimensionText,

      I_TechnicalObject.InventoryNumber,

      I_TechnicalObject.GrossWeight,

      I_TechnicalObject.GrossWeightUnit,

      I_TechnicalObject.ManufacturerPartNmbr,

      I_TechnicalObject.ManufacturerSerialNumber,

      I_TechnicalObject.TechnicalObjectDescription,

      I_TechnicalObject.TechnicalObjectHasLongText,

      I_TechnicalObject.SuperiorTechnicalObject,

      I_TechnicalObject.SuperiorTechnicalObjectLabel,

      I_TechnicalObject.SuperiorTechnicalObjectName,

      I_TechnicalObject.SuperiorObjIsEquipOrFuncnlLoc,

      //warranty related fields

      //Customer Warranty related fields

      _CustWrntyObjAssgmt.TechObjCustomerMasterWarranty  as TechObjCustomerMasterWarranty,
      _CustWrntyObjAssgmt.TechObjCustWarrantyStartDate   as TechObjCustWarrantyStartDate,
      _CustWrntyObjAssgmt.TechObjCustWarrantyEndDate     as TechObjCustWarrantyEndDate,
      _CustWrntyObjAssgmt.TechObjIsCustWarrantyPassedOn  as TechObjIsCustWarrantyPassedOn,
      _CustWrntyObjAssgmt.TechObjIsCustWarrantyInherited as TechObjIsCustWarrantyInherited,

      //Vendor Warranty realted fields

      _VndrWrntyObjAssgmt.TechObjSupplierMasterWarranty  as TechObjSupplierMasterWarranty,
      _VndrWrntyObjAssgmt.TechObjSuplrWarrantyStartDate  as TechObjSuplrWarrantyStartDate,
      _VndrWrntyObjAssgmt.TechObjSuplrWarrantyEndDate    as TechObjSuplrWarrantyEndDate,
      _VndrWrntyObjAssgmt.TechObjIsSuplrWarrantyPassedOn as TechObjIsSuplrWarrantyPassedOn,
      _VndrWrntyObjAssgmt.TechObjIsSuplrWrntyInherited   as TechObjIsSuplrWrntyInherited,

      I_TechnicalObject._CreatedByUser,

      I_TechnicalObject._LastChangedByUser,

      I_TechnicalObject._WorkCenterType,

      I_TechnicalObject._WorkCenter,

      I_TechnicalObject._LocationAccountAssignment,

      I_TechnicalObject._TechnicalObjectType,

      I_TechnicalObject._Equipment,

      I_TechnicalObject._FunctionalLocation,

      I_TechnicalObject._FunctionalLocationLabel,

      I_TechnicalObject._MaintenancePlanningPlant,

      I_TechnicalObject._TechObjIsEquipOrFuncnlLoc,

      I_TechnicalObject._TechnicalObjectText,

      I_TechnicalObject._TechnicalObjectCategory,

      I_TechnicalObject._MaintenancePlannerGroup,

      I_TechnicalObject._ManufacturerCountry,

      I_TechnicalObject._Currency,

      I_TechnicalObject._TechnicalObjectHierarchy,

      I_TechnicalObject._IsDeleted,

      I_TechnicalObject._StatusObjectActiveStatus,

      _CustWrntyObjAssgmt,
      _VndrWrntyObjAssgmt


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TECHNICALOBJECT",
"I_TECHOBJCUSTWRNTYASSGMT",
"I_TECHOBJVNDRWRNTYASSGMT"
],
"ASSOCIATED":
[
"E_EQUIPMENT",
"E_FUNCTIONALLOCATION",
"I_COUNTRY",
"I_CURRENCY",
"I_EQUIPMENT",
"I_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCATIONLABEL",
"I_INDICATOR",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEPLANNERGROUP",
"I_PLANT",
"I_STATUSOBJECTACTIVESTATUS",
"I_TECHNICALOBJECTCATEGORY",
"I_TECHNICALOBJECTHIERARCHY",
"I_TECHNICALOBJECTTEXT",
"I_TECHNICALOBJECTTYPE",
"I_TECHOBJCUSTWRNTYASSGMT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_TECHOBJVNDRWRNTYASSGMT",
"I_USER",
"I_WORKCENTER",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_TECHNICALOBJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/