I_CADisputeCaseFllwUpPostingTP

DDL: I_CADISPUTECASEFLLWUPPOSTINGTP SQL: ICADCFLLWUPTP Type: view TRANSACTIONAL Package: ODATA_O2C_FICA_DISPUTE_MANAGE

Dispute Case Follow-up Posting

I_CADisputeCaseFllwUpPostingTP is a Transactional CDS View that provides data about "Dispute Case Follow-up Posting" in SAP S/4HANA. It reads from 1 data source (I_CADisputeCaseFllwUpPosting) and exposes 26 fields with key fields CADocumentNumber, CaseUniqueID, CADisputedAmountType. It has 2 associations to related views. Part of development package ODATA_O2C_FICA_DISPUTE_MANAGE.

Data Sources (1)

SourceAliasJoin Type
I_CADisputeCaseFllwUpPosting I_CADisputeCaseFllwUpPosting from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_ContractAccountPartner _ContractAccount $projection.ContractAccount = _ContractAccount.ContractAccount and $projection.BusinessPartner = _ContractAccount.BusinessPartner association[1..1] to I_CADisputeCaseTP as _CADisputeCaseTP on $projection.CaseUniqueID = _CADisputeCaseTP.CaseUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICADCFLLWUPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Dispute Case Follow-up Posting view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence CADISPFLLWUP_D view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY CaseUniqueID CaseUniqueID
KEY CADisputedAmountType CADisputedAmountType
ObjectType ObjectType Type
ObjectKey ObjectKey Object Key
RelationshipNumber RelationshipNumber BP Rel. Number
RelationToLinkedObject RelationToLinkedObject
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CADocumentOriginCodeName CADocumentOriginCodeName
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
TransactionCurrency TransactionCurrency Transaction Currency
CreatedByUser CreatedByUser User Name
CADocumentOriginCode CADocumentOriginCode Document Origin
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAMainTransactionName CAMainTransactionName Main Transactn
CASubTransactionName CASubTransactionName Subtransaction
CADisputedAmountTypeName CADisputedAmountTypeName
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
_BusinessPartner _BusinessPartner
_ContractAccount _ContractAccount
_CADisputeCaseTP _CADisputeCaseTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CADisputeCaseFllwUpPostingTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICADCFLLWUPTP

CREATE VIEW I_CADisputeCaseFllwUpPostingTP AS
SELECT
  CADocumentNumber,
  CaseUniqueID,
  CADisputedAmountType,
  ObjectType,
  ObjectKey,
  RelationshipNumber,
  RelationToLinkedObject,
  CreationDate,
  CreationTime,
  CADocumentOriginCodeName,
  CAAmountInTransactionCurrency,
  TransactionCurrency,
  CreatedByUser,
  CADocumentOriginCode,
  CAMainTransaction,
  CASubTransaction,
  CAMainTransactionName,
  CASubTransactionName,
  CADisputedAmountTypeName,
  CAReversalDocumentNumber,
  CAReversedDocumentNumber,
  BusinessPartner,
  ContractAccount
FROM I_CADisputeCaseFllwUpPosting
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount AND BusinessPartner = _ContractAccount.BusinessPartner association[1..1] to I_CADisputeCaseTP as _CADisputeCaseTP on CaseUniqueID = _CADisputeCaseTP.CaseUUID  -- association [1..1]
;