C_InhRepairObjPgItem

DDL: C_INHREPAIROBJPGITEM Type: view_entity CONSUMPTION
59 Fields 1 Data Sources

In-House Service Object

C_InhRepairObjPgItem is a Consumption CDS View that provides data about "In-House Service Object" in SAP S/4HANA. It reads from 1 data source (I_InHouseRepairItemTP) and exposes 59 fields with key fields InHouseRepair, InHouseRepairItem.

Data Sources (1)

SourceAliasJoin Type
I_InHouseRepairItemTP I_InHouseRepairItemTP projection

Annotations (8)

NameValueLevelField
EndUserText.label In-House Service Object view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey InHouseRepairItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY InHouseRepair InHouseRepair
KEY InHouseRepairItem InHouseRepairItem
InHouseRepairItemUUID InHouseRepairItemUUID
InhRepairType InhRepairType
PostingDate PostingDate Posting Date for GR
InhRepairItemCategory InhRepairItemCategory
InhRepairItemStatus InhRepairItemStatus
InhRepairItemStatusNamelocalized
Product Product Product Sold
ProductNamelocalized
ParentInHouseRepairItem ParentInHouseRepairItem
InhRepairReferenceEquipment InhRepairReferenceEquipment
EquipmentNamelocalized
SerialNumber SerialNumber Serial Number
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
UnitOfMeasureNamelocalized
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechnicalObject TechnicalObject Technical Object
LastChangeDateTime LastChangeDateTime Timestamp
InhRepairItemObjectType InhRepairItemObjectType
InHouseRepairUUID InHouseRepairUUID
InhRepairItemIsOpen InhRepairItemIsOpen
InhRepairItemHasError InhRepairItemHasError
SitnNumberOfInstances _SitnInstceIndicator SitnNumberOfInstances
InhRepairItemAvailyStatus InhRepairItemAvailyStatus
CustRetMatlAuthzn _CustomerReturnsItemReference CustRetMatlAuthzn
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
StorageLocation StorageLocation StorageLocation
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
InhRepairItemSpecialStockType InhRepairItemSpecialStockType
InhReprItmSpecialStockTypeTextlocalized
InhReprItmInvtryUsabilityCode InhReprItmInvtryUsabilityCode
InhReprItmInvtryUsblyCodeTextlocalized
CompanyCode
_InHouseRepair _InHouseRepair
_InhRepairItemCategory _InhRepairItemCategory
_InhRepairItemStatus _InhRepairItemStatus
_InhRepairReferenceEquipment _InhRepairReferenceEquipment
_InhRepairReferenceEquipText _InhRepairReferenceEquipText
_Product _Product
_ProductText _ProductText
_InhRepairItemAvailyStatus _InhRepairItemAvailyStatus
_Plant _Plant
_StorageLocation _StorageLocation
_InhReprItemSpecialStockType _InhReprItemSpecialStockType
_InhReprItemSpecialStockTypeT _InhReprItemSpecialStockTypeT
_InhReprItmInvtryUsblyCode _InhReprItmInvtryUsblyCode
_InhReprItmInvtryUsblyCodeTxt _InhReprItmInvtryUsblyCodeTxt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_InhRepairObjPgItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_InhRepairObjPgItem AS
SELECT
  InHouseRepair,
  InHouseRepairItem,
  InHouseRepairItemUUID,
  InhRepairType,
  PostingDate,
  InhRepairItemCategory,
  InhRepairItemStatus,
  _InhRepairItemStatus._InhRepairItemStatusText.InhRepairItemStatusName : localized AS InhRepairItemStatusNamelocalized,
  Product,
  _ProductText.ProductName : localized AS ProductNamelocalized,
  ParentInHouseRepairItem,
  InhRepairReferenceEquipment,
  _InhRepairReferenceEquipText.EquipmentName : localized AS EquipmentNamelocalized,
  SerialNumber,
  Quantity,
  QuantityUnit,
  _QuantityUnitOfMeasure._Text.UnitOfMeasureName : localized AS UnitOfMeasureNamelocalized,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObject,
  LastChangeDateTime,
  InhRepairItemObjectType,
  InHouseRepairUUID,
  InhRepairItemIsOpen,
  InhRepairItemHasError,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  InhRepairItemAvailyStatus,
  _CustomerReturnsItemReference.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  RespEmployeeBusinessPartnerId,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  InhRepairItemSpecialStockType,
  _InhReprItemSpecialStockTypeT.InhReprItmSpecialStockTypeText : localized AS InhReprItmSpecialStockTypeTextlocalized,
  InhReprItmInvtryUsabilityCode,
  _InhReprItmInvtryUsblyCodeTxt.InhReprItmInvtryUsblyCodeText : localized AS InhReprItmInvtryUsblyCodeTextlocalized,
  _InHouseRepair._SalesOrganization.CompanyCode AS CompanyCode
FROM I_InHouseRepairItemTP
;

Learn More