C_InhRepairProcFlowInformation

DDL: C_INHREPAIRPROCFLOWINFORMATION Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

In-House Service Attributes in Process Flow

C_InhRepairProcFlowInformation is a Consumption CDS View that provides data about "In-House Service Attributes in Process Flow" in SAP S/4HANA. It reads from 1 data source (I_InHouseRepair) and exposes 19 fields with key fields CustMgmtObjectType, InHouseRepair. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InHouseRepair ihr from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_InhReprProcFlowNodeTitleText _NodeTitleText _NodeTitleText.InHouseRepairIsIntercompany = ihr.InHouseRepairIsIntercompany and _NodeTitleText.Language = $session.system_language

Annotations (11)

NameValueLevelField
EndUserText.label In-House Service Attributes in Process Flow view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CINHRPRPRCFLWINF view
AbapCatalog.compiler.compareFilter true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CustMgmtObjectType I_InHouseRepair CustMgmtObjectType Trans. Cat.
KEY InHouseRepair I_InHouseRepair InHouseRepair
InHouseRepairUUID I_InHouseRepair InHouseRepairUUID Unique Identifier
InhRepairType I_InHouseRepair InhRepairType Type of Data
PostingDate I_InHouseRepair PostingDate Posting Date for GR
CompanyCode _SalesOrganization CompanyCode Receiver Company Code
CompanyCodeName
InHouseRepairIsIntercompany I_InHouseRepair InHouseRepairIsIntercompany
ProcessFlowNodeTitle _NodeTitleText ProcessFlowNodeTitle
RespEmployeeBusinessPartnerId I_InHouseRepair ResponsibleEmployee Employee Resp.
SalesOrganization I_InHouseRepair SalesOrganization Sales Organization
SalesOffice I_InHouseRepair SalesOffice Sales Office
SalesGroup I_InHouseRepair SalesGroup Sales Group
SalesOrganizationOrgUnitID I_InHouseRepair SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_InHouseRepair SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID I_InHouseRepair SalesGroupOrgUnitID Sales Group
DistributionChannel I_InHouseRepair DistributionChannel RefDistCh-Cust/Mat.
Division I_InHouseRepair Division Internal Division ID
SrvcMgmtObjectStatus _SrvcMgmtObjectStatus SrvcMgmtObjectStatus

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_InhRepairProcFlowInformation.
-- 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_InhRepairProcFlowInformation AS
SELECT
  ihr.CustMgmtObjectType AS CustMgmtObjectType,
  ihr.InHouseRepair AS InHouseRepair,
  ihr.InHouseRepairUUID AS InHouseRepairUUID,
  ihr.InhRepairType AS InhRepairType,
  ihr.PostingDate AS PostingDate,
  _SalesOrganization.CompanyCode AS CompanyCode,
  _SalesOrganization._CompanyCode.CompanyCodeName AS CompanyCodeName,
  ihr.InHouseRepairIsIntercompany AS InHouseRepairIsIntercompany,
  _NodeTitleText.ProcessFlowNodeTitle AS ProcessFlowNodeTitle,
  ihr.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ihr.SalesOrganization AS SalesOrganization,
  ihr.SalesOffice AS SalesOffice,
  ihr.SalesGroup AS SalesGroup,
  ihr.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ihr.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ihr.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ihr.DistributionChannel AS DistributionChannel,
  ihr.Division AS Division,
  _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus AS SrvcMgmtObjectStatus
FROM I_InHouseRepair AS ihr
LEFT OUTER JOIN I_InhReprProcFlowNodeTitleText AS _NodeTitleText ON _NodeTitleText.InHouseRepairIsIntercompany = ihr.InHouseRepairIsIntercompany AND _NodeTitleText.Language = $session.system_language  -- association [0..1]
;

Learn More