Which tables does C_CreditLimitRequestTP use?

C_CreditLimitRequestTP reads from 1 data source(s): R_CreditLimitRequestTP.

How many fields does C_CreditLimitRequestTP have?

C_CreditLimitRequestTP has 97 fields. Key fields: CaseUUID.

C_CreditLimitRequestTP

DDL: C_CREDITLIMITREQUESTTP Type: view_entity CONSUMPTION

Credit Limit Change Requests

C_CreditLimitRequestTP is a Consumption CDS View that provides data about "Credit Limit Change Requests" in SAP S/4HANA. It reads from 1 data source (R_CreditLimitRequestTP) and exposes 97 fields with key field CaseUUID. It has 4 associations to related views. It is exposed through 2 OData services (UI_CRDTMGMTACCOUNT_MANAGE, UI_CREDITLIMITREQUEST_MANAGE). It is used in 1 Fiori application: Manage Credit Accounts.

Data Sources (1)

Source	Alias	Join Type
R_CreditLimitRequestTP	R_CreditLimitRequestTP	projection

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	C_CreditLimitRequestLog	_CreditLimitRequestLog	`$projection.CaseUUID = _CreditLimitRequestLog.CaseUUID`
[0..*]	C_CreditWorthinessScoreTrend	_CreditWorthinessScoreTrend	`$projection.BusinessPartner = _CreditWorthinessScoreTrend.ChangeDocObject`
[0..*]	C_CrdtMAcctAgingGrid	_AgingGrid	`$projection.BusinessPartner = _AgingGrid.BusinessPartner and $projection.CreditSegment = _AgingGrid.CreditSegment`
[0..*]	C_CreditLimitTrend	_CreditLimitTrend	`$projection.BusinessPartner = _CreditLimitTrend.ChangeDocObject and $projection.CreditSegment = _CreditLimitTrend.CreditSegment`

Annotations (8)

Name	Value	Level
EndUserText.label	Credit Limit Change Requests	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.representativeKey	CaseUUID	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view

OData Services (2)

Service	Binding	Version	Contract	Release
UI_CRDTMGMTACCOUNT_MANAGE	UI_CRDTMGMTACCOUNT_MANAGE	V2	C1	NOT_TO_BE_RELEASED_STABLE
UI_CREDITLIMITREQUEST_MANAGE	UI_CREDITLIMITREQUEST_MAN	V2	C1	NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App ID	App Name	Type	Description
F4596	Manage Credit Accounts	Transactional

Manage Credit Accounts

Business Role: Credit Controller

Use this app to display and update the credit data for business parters. Edit the credit data of business partners and update the scoring. On the global credit data page, you can see the credit profile for your business partners, as well as detailed information about blocked sales documents or credit limit requests. Find the credit exposure and credit limit utilization highlighted for each credit segment. Navigate to credit segment level to find further information about credit-relevant data, or details about the related sales documents.

Fields (97)

Key	Field	Source Table	Source Field
KEY	CaseUUID		CaseUUID
	CaseID		CaseID
	BusinessPartner		BusinessPartner
	CreditSegment		CreditSegment
	CaseProcessor		CaseProcessor
	CaseResponsible		CaseResponsible
	CaseExternalReference		CaseExternalReference
	CaseTitle		CaseTitle
	CaseCreatedBy		CaseCreatedBy
	CreditCaseCreationDateTime		CreditCaseCreationDateTime
	CaseLastChangedBy		CaseLastChangedBy
	CreditCaseLastChangeDateTime		CreditCaseLastChangeDateTime
	CaseClosedBy		CaseClosedBy
	CreditCaseCloseDateTime		CreditCaseCloseDateTime
	CasePlannedCloseDate		CasePlannedCloseDate
	CaseReason		CaseReason
	CaseType		CaseType
	CaseStatusProfile		CaseStatusProfile
	CaseStatus		CaseStatus
	CaseSystemStatus		CaseSystemStatus
	CasePriority		CasePriority
	CaseAuthorizationLevel		CaseAuthorizationLevel
	CaseEscalationReason		CaseEscalationReason
	CaseCategory		CaseCategory
	CaseStatusObjectNumber		CaseStatusObjectNumber
	CaseSystemStatusName		CaseSystemStatusName
	CaseUserStatusName		CaseUserStatusName
	CreditLimitUtilizationPct
	BusinessPartnerRating
	CreditRiskClass
	CrdtMgmtBusinessPartnerGroup		CrdtMgmtBusinessPartnerGroup
	CreditSegmentCurrency		CreditSegmentCurrency
	CreditLimitRequestedAmount		CreditLimitRequestedAmount
	CreditLimitApprovedAmount		CreditLimitApprovedAmount
	ExpectedSalesAmount		ExpectedSalesAmount
	CustomerCreditExposureAmount		CustomerCreditExposureAmount
	CreditLimitAmount	_CreditManagementAccount	CreditLimitAmount
	CurrentCreditRiskClass	_CreditManagementBP	CreditRiskClass
	CaseAttributeProfile	_CaseTypes	CaseAttributeProfile
	CreditLimitValidityEndDate		CreditLimitValidityEndDate
	NumberOfCreditDecisionDocs	_BlockedCreditDecisionDocument	NumberOfCreditDecisionDocs
	NumberOfBrokenPromisesToPay	_BrokenPromisesToPay	NumberOfBrokenPromisesToPay
	DaysSalesOutstanding
	Last12MnthsMaxSlsAmtInSndrCrcy
	TotLast12MnthsSlsAmtInSndrCrcy
	CreditCoordinator		CreditCoordinator
	CreditAnalystName	_CreditAnalystContactCard	UserDescription
	CasePriorityNamelocalized
	CreditRiskClassNamelocalized
	CreditSegmentNamelocalized
	CaseEscalationReasonNamelocalized
	CaseStatusNamelocalized
	CaseCategoryNamelocalized
	CaseReasonNamelocalized
	CaseStatusProfileNamelocalized
	BusinessPartnerName	_BusinessPartner	BusinessPartnerName
	CaseCreatedByUserName	_CreatedByUserContactCard	UserDescription
	CaseLastChangedByUserName	_LastChangeUserContactCard	UserDescription
	CaseClosedByUserName	_ClosedByUserContactCard	UserDescription
	CaseResponsibleName	_PersonResponsibleUser	PersonFullName
	CaseProcessorName	_ProcessorUser	PersonFullName
	OrganizationBPName1	_BusinessPartner	OrganizationBPName1
	OrganizationBPName2	_BusinessPartner	OrganizationBPName2
	UICT_CoordinatorFirstName
	UICT_CoordinatorLastName
	UICT_ProcessorFirstName	_ProcessorUser	FirstName
	UICT_ProcessorLastName	_ProcessorUser	LastName
	UICT_ResponsibleFirstName	_PersonResponsibleUser	FirstName
	UICT_ResponsibleLastName	_PersonResponsibleUser	LastName
	UICT_CreatedByFirstName	_CreatedByUserContactCard	FirstName
	UICT_CreatedByLastName	_CreatedByUserContactCard	LastName
	UICT_ChangedByFirstName	_LastChangeUserContactCard	FirstName
	UICT_ChangedByLastName	_LastChangeUserContactCard	LastName
	UICT_ClosedByFirstName	_ClosedByUserContactCard	FirstName
	UICT_ClosedByLastName	_ClosedByUserContactCard	LastName
	virtualNoteTypeListTexttext200
	virtualPlannedCloseDateIsExceededboolean
	virtualPlannedCloseDateCriticalitychar1
	_BusinessPartner		_BusinessPartner
	_CaseSystemStatus		_CaseSystemStatus
	_CaseTypes		_CaseTypes
	_CrdtMBusPartnerGroup		_CrdtMBusPartnerGroup
	_CreditManagementBP		_CreditManagementBP
	_CreditManagementAccount		_CreditManagementAccount
	_CreditRiskClass		_CreditRiskClass
	_CreditSegment		_CreditSegment
	_Currency		_Currency
	_Escalation		_Escalation
	_Individual		_Individual
	_CaseCategory		_CaseCategory
	_Priority		_Priority
	_Reasons		_Reasons
	_StatProfile		_StatProfile
	_CreditLimitRequestLog		_CreditLimitRequestLog
	_CreditWorthinessScoreTrend		_CreditWorthinessScoreTrend
	_AgingGrid		_AgingGrid
	_CreditLimitTrend		_CreditLimitTrend

@EndUserText: { label: 'Credit Limit Change Requests' }
@AccessControl: { authorizationCheck: #CHECK,
                  privilegedAssociations: [ '_CreatedByUserContactCard',
                                            '_LastChangeUserContactCard',
                                            '_ClosedByUserContactCard',
                                            '_CaseProcessorContactCard',
                                            '_CaseResponsibleContactCard',
                                            '_CreditWorthinessScoreTrend',
                                            '_CreditLimitTrend',
                                            '_CreditAnalystContactCard' ] }

@ObjectModel: { usageType: { serviceQuality: #D,
                             sizeCategory:   #XL,
                             dataClass:      #MIXED },
                semanticKey: [ 'CaseID' ],
                representativeKey: 'CaseUUID' }
@VDM: { viewType: #CONSUMPTION,
        usage:    { type: [ #TRANSACTIONAL_PROCESSING_SERVICE ] } }
@Metadata: { allowExtensions: true }

define root view entity C_CreditLimitRequestTP
  provider contract transactional_query
  as projection on R_CreditLimitRequestTP as CreditLimitRequest

  // VDM Associations

  // Log

  association [0..*] to C_CreditLimitRequestLog      as _CreditLimitRequestLog      on  $projection.CaseUUID = _CreditLimitRequestLog.CaseUUID

  // Score Trend

  association [0..*] to C_CreditWorthinessScoreTrend as _CreditWorthinessScoreTrend on  $projection.BusinessPartner = _CreditWorthinessScoreTrend.ChangeDocObject

  // Aging Grid

  association [0..*] to C_CrdtMAcctAgingGrid         as _AgingGrid                  on  $projection.BusinessPartner = _AgingGrid.BusinessPartner
                                                                                    and $projection.CreditSegment   = _AgingGrid.CreditSegment

  // Credit Limit Trend

  association [0..*] to C_CreditLimitTrend           as _CreditLimitTrend           on  $projection.BusinessPartner = _CreditLimitTrend.ChangeDocObject
                                                                                    and $projection.CreditSegment   = _CreditLimitTrend.CreditSegment

{
                // VDM Fields

  key           CaseUUID,
                CaseID,

                @ObjectModel: { text: { element: [ 'BusinessPartnerName' ] } }
                BusinessPartner,

                @ObjectModel: { text: { element: [ 'CreditSegmentName' ] } }
                CreditSegment,

                @ObjectModel: { text: { element: [ 'CaseProcessorName' ] } }
                CaseProcessor,

                @ObjectModel: { text: { element: [ 'CaseResponsibleName' ] } }
                CaseResponsible,

                CaseExternalReference,
                CaseTitle,

                @ObjectModel: { text: { element: [ 'CaseCreatedByUserName' ] } }
                CaseCreatedBy,

                CreditCaseCreationDateTime,

                @ObjectModel: { text: { element: [ 'CaseLastChangedByUserName' ] } }
                CaseLastChangedBy,

                CreditCaseLastChangeDateTime,

                @ObjectModel: { text: { element: [ 'CaseClosedByUserName' ] } }
                CaseClosedBy,

                CreditCaseCloseDateTime,
                CasePlannedCloseDate,

                @ObjectModel: { text: { element: [ 'CaseReasonName' ] } }
                CaseReason,

                CaseType,

                @ObjectModel: { text: { element: [ 'CaseStatusProfileName' ] } }
                CaseStatusProfile,

                @ObjectModel: { text: { element: [ 'CaseStatusName' ] } }
                CaseStatus,

                CaseSystemStatus,

                @ObjectModel: { text: { element: [ 'CasePriorityName' ] } }
                CasePriority,

                CaseAuthorizationLevel,

                @ObjectModel: { text: { element: [ 'CaseEscalationReasonName' ] } }
                CaseEscalationReason,

                @ObjectModel: { text: { element: [ 'CaseCategoryName' ] } }
                CaseCategory,

                CaseStatusObjectNumber,
                CaseSystemStatusName,
                CaseUserStatusName,
                cast( CreditLimitUtilizationPct as ukm_clcr_credit_us32 preserving type ) as CreditLimitUtilizationPct,
                cast( BusinessPartnerRating as ukm_clcr_own_rating preserving type )      as BusinessPartnerRating,

                @ObjectModel: { text: { element: [ 'CreditRiskClassName' ] } }
                cast( CreditRiskClass as ukm_clcr_risk_class preserving type )            as CreditRiskClass,

                CrdtMgmtBusinessPartnerGroup,
                CreditSegmentCurrency,
//                CreditLimitAmount,

                CreditLimitRequestedAmount,
                CreditLimitApprovedAmount,
                ExpectedSalesAmount,
                CustomerCreditExposureAmount,

                @Semantics: { amount: { currencyCode: 'CreditSegmentCurrency' } }
                _CreditManagementAccount.CreditLimitAmount                                as CreditLimitAmount,

                @ObjectModel: { text: { element: [ 'CurrentCreditRiskClassName'] } }
                _CreditManagementBP.CreditRiskClass                                       as CurrentCreditRiskClass,

                _CaseTypes.CaseAttributeProfile,

                CreditLimitValidityEndDate,

                _BlockedCreditDecisionDocument.NumberOfCreditDecisionDocs,
                _BrokenPromisesToPay.NumberOfBrokenPromisesToPay,

                _CreditManagementAccount._CrdtMAcctPaytBehaviorTP.DaysSalesOutstanding,

                @Semantics: { amount: { currencyCode: 'CreditSegmentCurrency' } }
                _CreditManagementAccount._CrdtMAcctPaytBehaviorTP.Last12MnthsMaxSlsAmtInSndrCrcy,

                @Semantics: { amount: { currencyCode: 'CreditSegmentCurrency' } }
                _CreditManagementAccount._CrdtMAcctPaytBehaviorTP.TotLast12MnthsSlsAmtInSndrCrcy,

                @ObjectModel: { text: { element: [ 'CreditAnalystName' ] } }
                CreditCoordinator,

                _CreditAnalystContactCard.UserDescription                                 as CreditAnalystName,


                //Text Fields

                @Semantics: { text: true }
                _Priority._Text.CasePriorityName                                                                        : localized,

                @Semantics: { text: true }
                _CreditRiskClass._Text.CreditRiskClassName                                                              : localized,

                @Semantics: { text: true }
                _CreditSegment._Text.CreditSegmentName                                                                  : localized,

                @Semantics: { text: true }
                _Escalation._Text.CaseEscalationReasonName                                                              : localized,

                @Semantics: { text: true }
                _Individual._Text.CaseStatusName                                                                        : localized,

                @Semantics: { text: true }
                _CaseCategory._Text.CaseCategoryName                                                                    : localized,

                @Semantics: { text: true }
                _Reasons._Text.CaseReasonName                                                                           : localized,

                @Semantics: { text: true }
                _StatProfile._Text.CaseStatusProfileName                                                                : localized,

                @Semantics: { text: true }
                _BusinessPartner.BusinessPartnerName,

                @Semantics: { text: true }
                _CreditManagementBP._CreditRiskClass._Text.CreditRiskClassName            as CurrentCreditRiskClassName : localized,

                @Semantics: { text: true }
                _CreatedByUserContactCard.UserDescription                                 as CaseCreatedByUserName,

                @Semantics: { text: true }
                _LastChangeUserContactCard.UserDescription                                as CaseLastChangedByUserName,

                @Semantics: { text: true }
                _ClosedByUserContactCard.UserDescription                                  as CaseClosedByUserName,

                @Semantics: { text: true }
                _PersonResponsibleUser.PersonFullName                                     as CaseResponsibleName,

                @Semantics: { text: true }
                _ProcessorUser.PersonFullName                                             as CaseProcessorName,

                // Elements for Free Search

                _BusinessPartner.OrganizationBPName1,
                _BusinessPartner.OrganizationBPName2,
                _CreditAnalyst._BusinessUser.FirstName                                    as UICT_CoordinatorFirstName,
                _CreditAnalyst._BusinessUser.LastName                                     as UICT_CoordinatorLastName,
                _ProcessorUser.FirstName                                                  as UICT_ProcessorFirstName,
                _ProcessorUser.LastName                                                   as UICT_ProcessorLastName,
                _PersonResponsibleUser.FirstName                                          as UICT_ResponsibleFirstName,
                _PersonResponsibleUser.LastName                                           as UICT_ResponsibleLastName,
                _CreatedByUserContactCard.FirstName                                       as UICT_CreatedByFirstName,
                _CreatedByUserContactCard.LastName                                        as UICT_CreatedByLastName,
                _LastChangeUserContactCard.FirstName                                      as UICT_ChangedByFirstName,
                _LastChangeUserContactCard.LastName                                       as UICT_ChangedByLastName,
                _ClosedByUserContactCard.FirstName                                        as UICT_ClosedByFirstName,
                _ClosedByUserContactCard.LastName                                         as UICT_ClosedByLastName,

                // Virtual Elements

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_CLR_VE' }
  virtual       NoteTypeListText               : text200,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_DCD_VE' }
  virtual       PlannedCloseDateIsExceeded     : boolean,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_DCD_VE' }
  virtual       PlannedCloseDateCriticality    : char1,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_DCD_VE' }
  virtual       PlannedCloseDateIsNotExceeded  : boolean,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_DCD_VE' }
  virtual       NrOfDaysUntilPlannedClose      : dispute_days_till_plnd_cls_dt,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_DCD_VE' }
  virtual       NrOfDaysSincePlannedClose      : dispute_days_since_plnd_cls_dt,

                @Semantics: { amount: { currencyCode: 'CreditSegmentCurrency' } }
                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_ACCOUNT_VE',
                                text: { element: [ 'DynamicCreditExposurePercent' ] } }
                @EndUserText: { label:     'Dynamic Credit Exposure',
                                quickInfo: 'Credit Exposure (within horizon)' }
  virtual       DynamicCreditExposureAmount    : ukm_dynamic_exposure_amount,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_ACCOUNT_VE' }
                @EndUserText: { label:     'Dynamic Utiliztation %',
                                quickInfo: 'Dynamic Credit Limit Utiliztation in % (within horizon)' }
  virtual       DynamicCreditExposurePercent   : ukm_credlimit_used_dynamic,

                @Semantics: { amount: { currencyCode: 'CreditSegmentCurrency' } }
                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_ACCOUNT_VE',
                                text: { element: [ 'StaticCreditExposurePercent' ] } }
                @EndUserText: { label:     'Static Credit Exposure',
                                quickInfo: 'Credit Exposure (total)' }
  virtual       StaticCreditExposureAmount     : ukm_static_exposure_amount,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_ACCOUNT_VE' }
                @EndUserText: { label:     'Static Utiliztation %',
                                quickInfo: 'Static Credit Limit Utiliztation in % (total)' }
  virtual       StaticCreditExposurePercent    : ukm_credlimit_used_static,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_ACCOUNT_VE' }
  virtual       StaticCrdtExposureCriticality  : ukm_limit_utilzn_criticality,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_ACCOUNT_VE' }
  virtual       DynamicCrdtExposureCriticality : ukm_limit_utilzn_criticality,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_ACCOUNT_VE' }
  virtual       UICT_DynamicCrdtExposureAmount : xfeld,

                @ObjectModel: { virtualElementCalculatedBy: 'ABAP:CL_UKM_DCD_VE' }
  virtual       CreditLimitChangeReqDraftUUID  : sych_bdl_draft_admin_uuid,

                @ObjectModel: { virtualElement: true,
                                virtualElementCalculatedBy: 'ABAP:CL_UKM_CLR_VE' }
  virtual       CrdtLmtChgReqCurrentApprvlLvl  : ukm_clr_current_approval_level,

                @ObjectModel: { virtualElement: true,
                                virtualElementCalculatedBy: 'ABAP:CL_UKM_CLR_VE' }
  virtual       CrdtLmtChgReqUsrInvlmntText    : ukm_clr_user_involvement_text,

                @ObjectModel: { virtualElement: true,
                                virtualElementCalculatedBy: 'ABAP:CL_UKM_CLR_VE',
                                filter: { enabled: true,
                                          transformedBy: 'ABAP:CL_UKM_CLR_VE' } }
                @Consumption: { filter: { selectionType: #SINGLE } }
  virtual       CrdtLmtChgReqUsrIsInvld        : ukm_clr_user_is_involved,


                // Exposed associations

                _BusinessPartner,
                _CaseSystemStatus,
                _CaseTypes,
                _CrdtMBusPartnerGroup,
                _CreditManagementBP,
                _CreditManagementAccount,
                _CreditRiskClass,
                _CreditSegment,
                _Currency,
                _Escalation,
                _Individual,
                _CaseCategory,
                _Priority,
                _Reasons,
                _StatProfile,
                _CreatedByUserContactCard   : redirected to C_RblsMgmtUserContactCard,
                _LastChangeUserContactCard  : redirected to C_RblsMgmtUserContactCard,
                _ClosedByUserContactCard    : redirected to C_RblsMgmtUserContactCard,
                _CaseResponsibleContactCard : redirected to C_RblsMgmtUserContactCard,
                _CaseProcessorContactCard   : redirected to C_RblsMgmtUserContactCard,

                @ObjectModel: { filter: { enabled: false } }
                _CreditLimitRequestLog,

                @ObjectModel: { filter: { enabled: false } }
                _CreditWorthinessScoreTrend,

                @ObjectModel: { filter: { enabled: false } }
                _CreditAnalyst              : redirected to C_CrdtMAccountMainAnalyst,

                @ObjectModel: { filter: { enabled: false } }
                _AgingGrid,

                @ObjectModel: { filter: { enabled: false } }
                _CreditLimitTrend,

                @ObjectModel: { filter: { enabled: false } }
                _CreditAnalystContactCard   : redirected to C_RblsMgmtUserContactCard,

                @ObjectModel: { sort: { enabled: false },
                                filter: { enabled: false } }
                _QuickView                  : redirected to C_CrdtMgmtBPQuickViewTP,

                _ApprovalHierarchy          : redirected to composition child C_CrdtLmtChgReqApprvlHierTP

}

Depth:

C_CreditLimitRequestTP view_entity

R_CreditLimitRequestTP view_entity