P_CREDITLIMITTREND

CDS View

P_CREDITLIMITTREND is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CreditLimitTrend view_entity projection CONSUMPTION Credit Limit Trend 
@AbapCatalog: { sqlViewName: 'PCRLIMTR',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #NOT_REQUIRED }
@VDM: { viewType:  #COMPOSITE,
        private:   true }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #A,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL } }
define root view P_CreditLimitTrend
  as select from I_ChangeDocument
    inner join   I_ChangeDocumentItem on  I_ChangeDocument.ChangeDocObjectClass = I_ChangeDocumentItem.ChangeDocObjectClass
                                      and I_ChangeDocument.ChangeDocObject      = I_ChangeDocumentItem.ChangeDocObject
                                      and I_ChangeDocument.ChangeDocument       = I_ChangeDocumentItem.ChangeDocument

  //VDM Associations

  //Credit Segment

  association [0..1] to I_CreditManagementSegment as _CreditManagementSegment on $projection.CreditSegment = _CreditManagementSegment.CreditSegment

{
      //VDM Fields

  key I_ChangeDocumentItem.ChangeDocObject,
  key I_ChangeDocumentItem.ChangeDocObjectClass,
  key I_ChangeDocumentItem.ChangeDocument,
  key I_ChangeDocumentItem.ChangeDocTableKey,
      I_ChangeDocument.CreationDate,
      I_ChangeDocument.CreationTime,
      I_ChangeDocumentItem.ChangeDocNewCurrency,
      I_ChangeDocumentItem.ChangeDocNewFieldValue,

      cast( dats_tims_to_tstmp( CreationDate,
                                CreationTime,
                                abap_system_timezone( $session.client,'NULL' ),
                                $session.client,
                               'NULL' ) as ukm_create_time )                                                   as CreationDateTime,

      cast( substring( I_ChangeDocumentItem.ChangeDocTableKey, 4, 10 )  as bu_partner preserving type )        as BusinessPartner,
      cast( substring( I_ChangeDocumentItem.ChangeDocTableKey, 14, 10 )  as ukm_credit_sgmnt preserving type ) as CreditSegment,

      //Exposed Associations

      _CreditManagementSegment
}

where
      I_ChangeDocument.ChangeDocObjectClass            = 'BUPA_UKM'
  and I_ChangeDocumentItem.DatabaseTable               = 'UKMBP_CMS_SGM'
  and I_ChangeDocumentItem.ChangeDocDatabaseTableField = 'CREDIT_LIMIT'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CREDITMANAGEMENTSEGMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More