I_CADisputedObject

DDL: I_CADISPUTEDOBJECT SQL: ICADISPOBJ Type: view COMPOSITE
10 Fields 3 Data Sources 2 Associations

FICA Disputed Object

I_CADisputedObject is a Composite CDS View that provides data about "FICA Disputed Object" in SAP S/4HANA. It reads from 3 data sources (I_CADisputedBusinessPartner, I_CACaseAttribute, I_CADisputedObjectDocument) and exposes 10 fields with key fields CaseUniqueID, CADocumentNumber. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_CADisputedBusinessPartner _CADisputeBP from
I_CACaseAttribute _CADisputeCase inner
I_CADisputedObjectDocument _CADisputeDoc left_outer

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_ContractAccountPartner _ContractAccount $projection.ContractAccount = _ContractAccount.ContractAccount and $projection.BusinessPartner = _ContractAccount.BusinessPartner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICADISPOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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 FICA Disputed Object view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CaseUniqueID I_CADisputedBusinessPartner CaseUniqueID
KEY CADocumentNumber I_CADisputedObjectDocument CADocumentNumber Document Number
RelationshipNumber I_CADisputedObjectDocument RelationshipNumber BP Rel. Number
RelationToLinkedObject I_CADisputedObjectDocument RelationToLinkedObject
ObjectType I_CADisputedObjectDocument ObjectType Type
ObjectKey I_CADisputedObjectDocument ObjectKey Object Key
BusinessPartner I_CADisputedBusinessPartner BusinessPartner Issuing Authority
ContractAccount I_CACaseAttribute ContractAccount Contract Acct
_BusinessPartner _BusinessPartner
_ContractAccount _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_CADisputedObject.
-- 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: ICADISPOBJ

CREATE VIEW I_CADisputedObject AS
SELECT
  _CADisputeBP.CaseUniqueID AS CaseUniqueID,
  _CADisputeDoc.CADocumentNumber AS CADocumentNumber,
  _CADisputeDoc.RelationshipNumber AS RelationshipNumber,
  _CADisputeDoc.RelationToLinkedObject AS RelationToLinkedObject,
  _CADisputeDoc.ObjectType AS ObjectType,
  _CADisputeDoc.ObjectKey AS ObjectKey,
  _CADisputeBP.BusinessPartner AS BusinessPartner,
  _CADisputeCase.ContractAccount AS ContractAccount
FROM I_CADisputedBusinessPartner AS _CADisputeBP
INNER JOIN I_CACaseAttribute AS _CADisputeCase ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CADisputedObjectDocument AS _CADisputeDoc ON /* join condition not captured in parsed metadata */
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 [0..1]
;

Learn More