Which tables does C_CAClearingLockAnalysis use?

C_CAClearingLockAnalysis reads from 1 data source(s): R_CADocBPItemBusLockSnapshotTP.

How many fields does C_CAClearingLockAnalysis have?

C_CAClearingLockAnalysis has 6 fields.

C_CAClearingLockAnalysis

DDL: C_CACLEARINGLOCKANALYSIS Type: view_entity CONSUMPTION Package: ODATA_O2C_FICA_CLEARINGLOCK_AN

Analyze Clearing Locks Version2

C_CAClearingLockAnalysis is a Consumption CDS View that provides data about "Analyze Clearing Locks Version2" in SAP S/4HANA. It reads from 1 data source (R_CADocBPItemBusLockSnapshotTP) and exposes 6 fields. It has 2 associations to related views. It is exposed through 1 OData service (UI_CACLEARINGLOCK_ANALYSIS). It is used in 1 Fiori application: Analyze Clearing Locks (Version 2). Part of development package ODATA_O2C_FICA_CLEARINGLOCK_AN.

Data Sources (1)

Source	Alias	Join Type
R_CADocBPItemBusLockSnapshotTP	R_CADocBPItemBusLockSnapshotTP	from

Parameters (1)

Name	Type	Default
P_DisplayCurrency	waers_kk

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_CABusinessLockReasonEnhanced	_CABusinessLockReason	`$projection.CABusinessLockReasonEnhanced = _CABusinessLockReason.CABusinessLockReasonEnhanced and $projection.CABusinessProcess = _CABusinessLockReason.CABusinessProcess`
[0..1]	I_CAProviderContractHeader	_ProviderContract	`$projection.CASubApplication = 'P' and $projection.CAContract = _ProviderContract.CAProviderContract`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
OData.entitySet.name	C_CAClearingLockAnalysis	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_CACLEARINGLOCK_ANALYSIS	UI_CACLEARINGLOCK_ANALYSIS	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F1653A	Analyze Clearing Locks (Version 2)	Transactional, Analytical	An application to analyze clearing locks based on a snapshot of the locked open business partner items.

Analyze Clearing Locks (Version 2)

Business Role: Accounts Payable and Receivable Manager (FI-CA)

With the Analyze Clearing Locks app, you display existing clearing locks for receivables and payables. Using the app, you can display the amounts related to the selected locks in different currencies.As data volume in Contract Accounting can be very high, to improve performance, a new version of the app evaluates a system snapshot of receivables and payables instead of the current live data.

Fields (6)

Key	Field	Source Table	Source Field	Description
	CalendarMonthShortName			Start Date in Months
	ltrimCABusLockValidFromDateYear0
	CalendarMonthShortName			Expiration Date in Months
	ltrimCABusLockValidToDateYear0
	CalendarMonthShortName			Created On in Months
	ltrimLastChangeDateYear0

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@OData.entitySet.name: 'C_CAClearingLockAnalysis'

@ObjectModel: {
  usageType.serviceQuality: #D,
  usageType.sizeCategory: #XXL,
  usageType.dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]

@Metadata.allowExtensions: true

define view entity C_CAClearingLockAnalysis
  with parameters
    @EndUserText.label: 'Display Currency'
    @Consumption.valueHelpDefinition: [{entity: { name: 'I_CurrencyStdVH', element: 'Currency' }}]
    P_DisplayCurrency : waers_kk
  as select from R_CADocBPItemBusLockSnapshotTP( P_DisplayCurrency:$parameters.P_DisplayCurrency)
    association [1..1] to I_CABusinessLockReasonEnhanced as _CABusinessLockReason      on  $projection.CABusinessLockReasonEnhanced = _CABusinessLockReason.CABusinessLockReasonEnhanced
                                                                                     and $projection.CABusinessProcess    = _CABusinessLockReason.CABusinessProcess
    association [0..1] to I_CAProviderContractHeader     as _ProviderContract          on  $projection.CASubApplication = 'P'
                                                                                      and $projection.CAContract       = _ProviderContract.CAProviderContract
{

  key CAFioriApplication,
  key CABusinessLockSnapshotDateTime,
  key CADocumentNumber,
  key CARepetitionItemNumber,
  key CABPItemNumber,
  key CASubItemNumber,

      @Aggregation.default: #SUM
      @EndUserText.label: 'Number of Items'
      NumberOfCABusLockSnpshtBPItems,

      // Payable or Receivable

      @EndUserText.label: 'Variant'
      @Consumption.filter.mandatory: true
      @Consumption.filter.selectionType: #SINGLE
      @Consumption.valueHelpDefinition: [{entity: { name: 'I_CAPayableReceivableCodeVH', element: 'CADocumentBPItemPyblRblCode' }}]
      CADocumentBPItemPyblRblCode,

      //field for snapshot KPI

      @Semantics.durationInDays: true
      cast(DifferenceInDays as abap.int4)      as CABusinessLockSnapshotStatus,
      
      @EndUserText.label: 'Lock Reason'
      @ObjectModel: { text.element:  [ 'CABusinessLockReasonName' ]}
      CABusinessLockReasonEnhanced,

     @Semantics.text: true
      _CABusinessLockReason._Text[1:Language = $session.system_language].CABusinessLockReasonName,

      @EndUserText.label: 'Business Partner'
      @ObjectModel: { text.element:  [ 'BusinessPartnerFullName' ]}
      @Semantics:   { contact.type: #PERSON }
      BusinessPartner,

      @Semantics.text: true
      BusinessPartnerFullName,

      @EndUserText.label: 'Created On'
      CreationDate,

      @EndUserText.label: 'Total Duration in Days'
      CABusinessLockDuration,

      @EndUserText.label: 'Expiration Date'
      CABusinessLockValidToDate,

      @EndUserText.label: 'Start Date'
      CABusinessLockValidFromDate,

      @EndUserText.label: 'Lock Category'
      @ObjectModel: { text.element:  [ 'CABusinessLockObjectCatName' ]}
      CABusinessLockObjectCategory,

      CAApplicationArea,

      CABusinessLockObject,

      @ObjectModel: { text.element:  [ 'CABusinessLockObjectLevelText' ]}
      CABusinessLockObjectLevel,

      @ObjectModel: { text.element:  [ 'CABusinessProcessName' ]}
      CABusinessProcess,

      @Semantics.text: true
      CABusinessProcessName,

      @ObjectModel: { text.element:  [ 'ContractAccountName' ]}
      @EndUserText.label: 'Contract Account'
      ContractAccount,

      @Semantics.text: true
      ContractAccountName,

      @ObjectModel.text.element: [ 'CAProviderContractName' ]
      CAContract,
      
      @Semantics.text: true
      cast(_ProviderContract.CAProviderContractName as vtref_text_gfn_kk preserving type )   as CAProviderContractName,

      CAProviderContractItemNumber,

      CAProviderContractItemUUID,

      @ObjectModel: { text: { element: ['CASubApplicationText'] } }
      CASubApplication,

      @Semantics.text: true
      cast(CASubApplicationText as subap_text_gfn_kk preserving type ) as CASubApplicationText,

      @EndUserText.label: 'Contract Account Category'
      @ObjectModel: { text.element:  [ 'ContractAccountCategoryName' ]}
      ContractAccountCategory,

      @Semantics.text: true
      CABusinessLockObjectCatName,

      @Semantics.text: true
      CABusinessLockObjectLevelText,

      @EndUserText.label: 'Number of Extensions'
      CABusLockNumberOfExtensions,

      @ObjectModel: { text.element:  [ 'CompanyCodeName' ]}
      CompanyCode,
      
      BusinessArea,
      
      Segment,

      Division,

      @ObjectModel: { text.element:  [ 'CAMainTransactionName' ]}
      CAMainTransaction,

      @ObjectModel: { text.element:  [ 'CASubTransactionName' ]}
      CASubTransaction,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,

      TransactionCurrency,

      DisplayCurrency,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      @EndUserText.label: 'Amount'
      @ObjectModel:{text.element:['DisplayCurrency']}
      AmountInDisplayCurrency,

      // Start Date

      @EndUserText.label: 'Start Date in Years'
      CABusLockValidFromDateYear,

      @EndUserText.label: 'Start Date in Quaters'
      @ObjectModel.text.element: ['CABusLockValFrmDteYearQtrName']
      CABusLockValidFromDateYearQtr,

      @Semantics.text: true
      concat(
        concat(
          right(CABusLockValidFromDateYearQtr,1),
          '/'),
        ltrim(CABusLockValidFromDateYear,'0')) as CABusLockValFrmDteYearQtrName,

      @EndUserText.label: 'Start Date in Months'
      @ObjectModel.text.element: ['CABusLockValFrmDteYearMnthName']
      CABusLockValidFromDateYearMnth,

      @Semantics.text: true
      concat_with_space(
        _ValidFromMonth._ShortText[1:Language = $session.system_language].CalendarMonthShortName,
        ltrim(CABusLockValidFromDateYear,'0'),
        1)                                     as CABusLockValFrmDteYearMnthName,

      @EndUserText.label: 'Start Date in Weeks'
      @ObjectModel.text.element: ['CABusLockValFrmDteYearWeekName']
      CABusLockValidFromDateYearWeek,

      @Semantics.text: true
      concat(
        concat(
          right(CABusLockValidFromDateYearWeek,2),
          '/'),
        ltrim(CABusLockValidFromDateYear,'0')) as CABusLockValFrmDteYearWeekName,

      //Expiration Date

      @EndUserText.label: 'Expiration Date in Years'
      CABusLockValidToDateYear,

      @EndUserText.label: 'Expiration Date in Quaters'
      @ObjectModel.text.element: ['CABusLockValToDteYearQtrName']
      CABusLockValidToDateYearQtr,

      @Semantics.text: true
      concat(
        concat(
          right(CABusLockValidToDateYearQtr,1),
          '/'),
        ltrim(CABusLockValidToDateYear,'0'))   as CABusLockValToDteYearQtrName,

      @EndUserText.label: 'Expiration Date in Months'
      @ObjectModel.text.element: ['CABusLockValToDteYearMnthName']
      CABusLockValidToDateYearMonth,

      @Semantics.text: true
      concat_with_space(
        _ValidToMonth._ShortText[1:Language = $session.system_language].CalendarMonthShortName,
        ltrim(CABusLockValidToDateYear,'0'),
        1)                                     as CABusLockValToDteYearMnthName,

      @EndUserText.label: 'Expiration Date in Weeks'
      @ObjectModel.text.element: ['CABusLockValToDteYearWeekName']
      CABusLockValidToDateYearWeek,

      @Semantics.text: true
      concat(
        concat(
          right(CABusLockValidToDateYearWeek,2),
          '/'),
        ltrim(CABusLockValidToDateYear,'0'))   as CABusLockValToDteYearWeekName,

      //Created On

      @EndUserText.label: 'Created On in Years'
      LastChangeDateYear,

      @EndUserText.label: 'Created On in Quaters'
      @ObjectModel.text.element: ['LastChangeDateYearQuarterName']
      LastChangeDateYearQuarter,

      @Semantics.text: true
      concat(
        concat(
          right(LastChangeDateYearQuarter,1),
          '/'),
        ltrim(LastChangeDateYear,'0'))         as LastChangeDateYearQuarterName,

      @EndUserText.label: 'Created On in Months'
      @ObjectModel.text.element: ['LastChangeDateYearMonthName']
      LastChangeDateYearMonth,

      @Semantics.text: true
      concat_with_space(
        _LastChangeMonth._ShortText[1:Language = $session.system_language].CalendarMonthShortName,
        ltrim(LastChangeDateYear,'0'),
        1)                                     as LastChangeDateYearMonthName,

      @EndUserText.label: 'Created On in Weeks'
      @ObjectModel.text.element: ['LastChangeDateYearWeekName']
      LastChangeDateYearWeek,

      @Semantics.text: true
      concat(
        concat(
          right(LastChangeDateYearWeek,2),
          '/'),
        ltrim(LastChangeDateYear,'0'))         as LastChangeDateYearWeekName,
      
      //Duration

      CABusinessLockDurationInYears,

      CABusinessLockDurationInQtrs,

      CABusinessLockDurationInMonths,

      CABusinessLockDurationInWeeks,
      
      CAProviderContractAuthznGroup,
      
      @Semantics.text: true
      CAMainTransactionName,

      @Semantics.text: true
      CASubTransactionName,

      @Semantics.text: true
      ContractAccountCategoryName,

      @Semantics.text: true
      CompanyCodeName,

      //Total Amounts

      @Semantics.amount.currencyCode: 'DisplayCurrency'
      @EndUserText.label: 'Credit Amount'
      BPCreditAmountInDC,

      @Semantics.amount.currencyCode: 'DisplayCurrency'
      @EndUserText.label: 'Debit Amount'
      BPDebitAmountInDC,

      @Semantics.amount.currencyCode: 'DisplayCurrency'
      @EndUserText.label: 'Current Balance'
      BPBalanceAmountInDC,



      @EndUserText.label: 'Last Worklist Item Status'
      @EndUserText.quickInfo: ''
      @ObjectModel.text.element: ['CAClrfctnStatusName']
      _LastWorklistItem.CAClrfctnStatus,

      @Semantics.text: true
      _LastWorklistItem._Status._Text[1:Language = $session.system_language].CAClrfctnStatusName,

      @EndUserText.label: 'Last Worklist Item Created At'
      @EndUserText.quickInfo: ''
      @Semantics.dateTime: true
      _LastWorklistItem.CreationDateTime       as CAWorklistItemCreationDateTime,

      _BusinessPartner,
      _CABusinessLockObjCategory,
      _CABusinessLockReason,
      _ContractAccountCategory,
      _CABusinessProcess,
      _CAPartner,
      _CASubApplication,
      _CAMainTransaction,
      _SubTransaction,
      _CompCode,
      _LastWorklistItem._Status                as _WorklistStatus,
      _CABusinessLockObjectLevel

}

where
  (
    CAFioriApplication = 'F1653A'
  )

Depth:

C_CAClearingLockAnalysis view_entity

R_CADocBPItemBusLockSnapshotTP view_entity