I_CreditLimitRequest

@EndUserText.label: 'Credit Limit Request'
@AbapCatalog.sqlViewName: 'ICRDTLMTREQUEST'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
//@Metadata.allowExtensions:true

//@Analytics.internalName:#LOCAL

@Metadata.ignorePropagatedAnnotations:true
define view I_CreditLimitRequest
  as select from I_CreditLimitRequestAttribute as clrattr // ukmcaseattr00

    inner join   I_CaseAttribute               as caseattr on clrattr.CaseUUID = caseattr.CaseUniqueID
{
  key CaseUUID,
      caseattr.CaseID,
      clrattr.BusinessPartner                                               as BusinessPartner,
      clrattr.CreditSegment                                                 as CreditSegment,

      caseattr.CaseProcessor                                                as CaseProcessor,
      caseattr.CaseResponsible                                              as CaseResponsible,
      caseattr.CaseExternalReference                                        as CaseExternalReference,
      caseattr.CaseTitle                                                    as CaseTitle,
      caseattr.CaseCreatedBy                                                as CaseCreatedBy,
      cast( caseattr.CaseCreatedOn as ukm_create_time preserving type )     as CaseCreatedOn,
      caseattr.CaseLastChangedBy                                            as CaseLastChangedBy,
      cast( caseattr.CaseLastChangedOn as ukm_change_time preserving type ) as CaseLastChangedOn,
      caseattr.CaseClosedBy                                                 as CaseClosedBy,
      cast( caseattr.CaseClosedTime as ukm_close_time preserving type)      as CaseClosedTime,
      caseattr.CasePlannedCloseDate                                         as CasePlannedCloseDate,
      caseattr.CaseReason                                                   as CaseReason,
      caseattr.CaseType                                                     as CaseType,
      caseattr.CaseStatusProfile                                            as CaseStatusProfile,
      caseattr.CaseStatus                                                   as CaseStatus,
      caseattr.CaseSystemStatus                                             as CaseSystemStatus,
      caseattr.CasePriority                                                 as CasePriority,
      caseattr.CaseAuthorizationLevel                                       as CaseAuthorizationLevel,
      caseattr.CaseEscalationReason                                         as CaseEscalationReason,
      caseattr.CaseCategory                                                 as CaseCategory,
      caseattr.CaseStatusObjectNumber                                       as CaseStatusObjectNumber,
      caseattr.CaseSystemStatusName                                         as CaseSystemStatusName,
      caseattr.CaseUserStatusName                                           as CaseUserStatusName,

      clrattr.CreditLimitUtilizationPct                                     as CreditLimitUtilizationPct,
      clrattr.BusinessPartnerRating                                         as BusinessPartnerRating,
      clrattr.CreditRiskClass                                               as CreditRiskClass,
      clrattr.CrdtMgmtBusinessPartnerGroup                                  as CrdtMgmtBusinessPartnerGroup,

      //      @ObjectModel.foreignKey.association: '_Currency'

      CreditSegmentCurrency,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'CreditSegmentCurrency'
      CreditLimitAmount,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'CreditSegmentCurrency'
      CreditLimitRequestedAmount,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'CreditSegmentCurrency'
      CreditLimitApprovedAmount,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'CreditSegmentCurrency'
      ExpectedSalesAmount,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'CreditSegmentCurrency'
      CustomerCreditExposureAmount,
      
      clrattr.CreditLimitValidityEndDate,

      _BusinessPartner,
      _CreditManagementBP,
      _CreditSegment,
      _Currency,
      _CaseTypes,
      _CreditRiskClass,
      _Priority,
      _CaseSystemStatus,
      _StatProfile,
      _Individual,
      _Catego as _CaseCategory,
      _Escalation,
      _Reasons,
      _CrdtMBusPartnerGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASEATTRIBUTE",
"I_CREDITLIMITREQUESTATTRIBUTE"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CASECATEGORY",
"I_CASEESCALATIONREASON",
"I_CASEINDIVIDUALSTATUS",
"I_CASEPRIORITY",
"I_CASEREASONS",
"I_CASESTATUSPROFILE",
"I_CASESYSTEMSTATUS",
"I_CASETYPES",
"I_CRDTMBUSPARTNERGROUP",
"I_CREDITMANAGEMENTBP",
"I_CREDITMANAGEMENTSEGMENT",
"I_CREDITRISKCLASS",
"I_CURRENCY"
],
"BASE":
[
"I_CASEATTRIBUTE",
"I_CREDITLIMITREQUESTATTRIBUTE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/