I_CADisputedPaymentDoc

DDL: I_CADISPUTEDPAYMENTDOC SQL: ICADSPMTDOC Type: view COMPOSITE
11 Fields 2 Data Sources

FICA Payment Document

I_CADisputedPaymentDoc is a Composite CDS View that provides data about "FICA Payment Document" in SAP S/4HANA. It reads from 2 data sources (I_CADisputedObject, I_CADisputedPaymentInfo) and exposes 11 fields with key fields CaseUniqueID, CAPaymentDocument.

Data Sources (2)

SourceAliasJoin Type
I_CADisputedObject _Object from
I_CADisputedPaymentInfo _Payment inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICADSPMTDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label FICA Payment Document view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CaseUniqueID I_CADisputedObject CaseUniqueID UUID
KEY CAPaymentDocument I_CADisputedPaymentInfo CAPaymentDocument Usage Doc.
ObjectType I_CADisputedPaymentInfo ObjectType Type
ObjectKey I_CADisputedPaymentInfo ObjectKey Object Key
RelationshipNumber I_CADisputedPaymentInfo RelationshipNumber BP Rel. Number
RelationToLinkedObject I_CADisputedPaymentInfo RelationToLinkedObject Relationsh.Cat.
BusinessPartner I_CADisputedObject BusinessPartner Issuing Authority
ContractAccount I_CADisputedObject ContractAccount Contract Acct
CADisputedPaymentOrigin I_CADisputedPaymentInfo CADisputedPaymentOrigin
_BusinessPartner I_CADisputedObject _BusinessPartner
_ContractAccount I_CADisputedObject _ContractAccount

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_CADisputedPaymentDoc.
-- 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: ICADSPMTDOC

CREATE VIEW I_CADisputedPaymentDoc AS
SELECT
  _Object.CaseUniqueID AS CaseUniqueID,
  _Payment.CAPaymentDocument AS CAPaymentDocument,
  _Payment.ObjectType AS ObjectType,
  _Payment.ObjectKey AS ObjectKey,
  _Payment.RelationshipNumber AS RelationshipNumber,
  _Payment.RelationToLinkedObject AS RelationToLinkedObject,
  _Object.BusinessPartner AS BusinessPartner,
  _Object.ContractAccount AS ContractAccount,
  _Payment.CADisputedPaymentOrigin AS CADisputedPaymentOrigin,
  _Object._BusinessPartner AS _BusinessPartner,
  _Object._ContractAccount AS _ContractAccount
FROM I_CADisputedObject AS _Object
INNER JOIN I_CADisputedPaymentInfo AS _Payment ON /* join condition not captured in parsed metadata */
;

Learn More