I_CADisputeCaseFllwUpPosting

DDL: I_CADISPUTECASEFLLWUPPOSTING SQL: ICADCFLLWUP Type: view COMPOSITE Package: ODATA_O2C_FICA_DISPUTE_MANAGE

Disputed Follow Up Posting Document

I_CADisputeCaseFllwUpPosting is a Composite CDS View that provides data about "Disputed Follow Up Posting Document" in SAP S/4HANA. It reads from 5 data sources (I_CADocument, I_CADisputeCase, I_CADisputedObject, I_CADisputedPaymentInfo, I_CADisputeCaseAmountChange) and exposes 25 fields with key fields CADocumentNumber, CaseUniqueID, CADisputedAmountType. Part of development package ODATA_O2C_FICA_DISPUTE_MANAGE.

5 data source(s) 25 fields

Data Sources (5)

SourceAliasJoin Type
I_CADocument _CADocumentHeader left_outer
I_CADisputeCase _Case inner
I_CADisputedObject _DisputedObject inner
I_CADisputedPaymentInfo _DisputedPaymentInfo inner
I_CADisputeCaseAmountChange I_CADisputeCaseAmountChange from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICADCFLLWUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Disputed Follow Up Posting Document view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocument CADocumentNumber
KEY CaseUniqueID I_CADisputedObject CaseUniqueID
KEY CADisputedAmountType I_CADisputeCaseAmountChange CADisputedAmountType
ObjectType I_CADisputedObject ObjectType
ObjectKey I_CADisputedObject ObjectKey
RelationshipNumber I_CADisputedObject RelationshipNumber
RelationToLinkedObject I_CADisputedObject RelationToLinkedObject
CreationDate
CreationTime
CADocumentOriginCodeName
CAAmountInTransactionCurrency CADisputeAmount
TransactionCurrency I_CADisputeCaseAmountChange TransactionCurrency
CreatedByUser I_CADocument CreatedByUser
CADocumentOriginCode I_CADocument CADocumentOriginCode
CAMainTransaction
CASubTransaction
CAMainTransactionName
CASubTransactionName
CADisputedAmountTypeName CADisputedAmountTypeName
CAReversalDocumentNumber I_CADocument CAReversalDocumentNumber
CAReversedDocumentNumber I_CADocument CAReversedDocumentNumber
CADisputeType I_CADisputeCase CADisputeType
BusinessPartner I_CADisputedObject BusinessPartner
ContractAccount I_CADisputedObject ContractAccount
ObjectClassification I_CADisputedPaymentInfo ObjectClassification 
@AbapCatalog.sqlViewName: 'ICADCFLLWUP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Disputed Follow Up Posting Document'
define view I_CADisputeCaseFllwUpPosting as select from I_CADisputeCaseAmountChange
  left outer join I_CADocument  as _CADocumentHeader on I_CADisputeCaseAmountChange.CADocumentNumber = _CADocumentHeader.CADocumentNumber
  inner join I_CADisputeCase    as _Case             on _Case.CaseUUID = I_CADisputeCaseAmountChange.CaseUUID
  inner join I_CADisputedObject as _DisputedObject   on I_CADisputeCaseAmountChange.CaseUUID = _DisputedObject.CaseUniqueID
                                                      and I_CADisputeCaseAmountChange.CADocumentNumber = _DisputedObject.CADocumentNumber
  inner join I_CADisputedPaymentInfo as _DisputedPaymentInfo   on I_CADisputeCaseAmountChange.CaseUUID = _DisputedPaymentInfo.CaseUniqueID
                                                      and I_CADisputeCaseAmountChange.CADocumentNumber = _DisputedPaymentInfo.ObjectKey
                                                      and _DisputedObject.ObjectType = _DisputedPaymentInfo.ObjectType
                                                                                        
{
  key _CADocumentHeader.CADocumentNumber,
  key _DisputedObject.CaseUniqueID,
  key I_CADisputeCaseAmountChange.CADisputedAmountType,
  
  _DisputedObject.ObjectType,
  _DisputedObject.ObjectKey,
  _DisputedObject.RelationshipNumber,
  _DisputedObject.RelationToLinkedObject,
  cast(_CADocumentHeader.CreationDate as erdat preserving type ) as CreationDate,
  cast(_CADocumentHeader.CreationTime as crtime_kk preserving type ) as CreationTime, 
  _CADocumentHeader._CADocumentOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName,
  CADisputeAmount as CAAmountInTransactionCurrency,
  I_CADisputeCaseAmountChange.TransactionCurrency,
  _CADocumentHeader.CreatedByUser,
  _CADocumentHeader.CADocumentOriginCode,
  cast('' as hvorg_kk ) as CAMainTransaction,
  cast('' as tvorg_gfn_kk ) as CASubTransaction,
  cast('' as hvorg_txt ) as CAMainTransactionName,
  cast('' as tvorg_txt ) as CASubTransactionName,  
  CADisputedAmountTypeName,
  _CADocumentHeader.CAReversalDocumentNumber,
  _CADocumentHeader.CAReversedDocumentNumber,
  _Case.CADisputeType,
  _DisputedObject.BusinessPartner,
  _DisputedObject.ContractAccount,
  _DisputedPaymentInfo.ObjectClassification
}
 where 
   not ( _DisputedObject.ObjectType = 'CA_DOC' and _DisputedPaymentInfo.ObjectClassification = 'DISP_DOC' ) //no disputed doc 

   and
    (
       I_CADisputeCaseAmountChange.CADisputedAmountType = '01'
    or I_CADisputeCaseAmountChange.CADisputedAmountType = '02'
    or I_CADisputeCaseAmountChange.CADisputedAmountType = '03'
    or I_CADisputeCaseAmountChange.CADisputedAmountType = '04'
    or I_CADisputeCaseAmountChange.CADisputedAmountType = '06'
    or I_CADisputeCaseAmountChange.CADisputedAmountType = '07'
    or I_CADisputeCaseAmountChange.CADisputedAmountType = '08'
    )

Learn More