I_CollsInvoiceRelatedDsputCase

DDL: I_COLLSINVOICERELATEDDSPUTCASE Type: view BASIC
24 Fields 6 Associations

Dispute Case Related to Invoice

I_CollsInvoiceRelatedDsputCase is a Basic CDS View that provides data about "Dispute Case Related to Invoice" in SAP S/4HANA. It has 6 associations to related views.

Associations (6)

CardinalityTargetAliasCondition
[0..1] R_RblsMgmtUserContactCard _CreatedByContactCard $projection.casecreatedby = _CreatedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ChangedByContactCard $projection.caselastchangedby = _ChangedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ClosedByContactCard $projection.caseclosedby = _ClosedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _DisputeCaseCoordinatorCard $projection.disputecasecoordinator = _DisputeCaseCoordinatorCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ProcessorContactCard $projection.caseprocessor = _ProcessorContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ResponsibleContactCard $projection.caseresponsible = _ResponsibleContactCard.ContactCardID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICOLLSINVRELDC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Dispute Case Related to Invoice view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CaseUniqueID view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY LogicalSystem LogicalSystem Logical System
KEY ObjectType ObjectType Type
KEY ObjectKey ObjectKey Object Key
KEY CaseUniqueID CaseUniqueID
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentItem AccountingDocumentItem Posting View Item
CaseID CaseID Case ID
DisputeCaseCoordinator _DisputeCase DisputeCaseCoordinator Coordinator
CaseCreatedBy _DisputeCase CaseCreatedBy Created By
CaseLastChangedBy _DisputeCase CaseLastChangedBy Changed By
CaseClosedBy _DisputeCase CaseClosedBy Closed By
CaseProcessor _DisputeCase CaseProcessor Processor
CaseResponsible _DisputeCase CaseResponsible Person Responsible
NumberOfDisputeCases
_CaseAttribute _CaseAttribute
_DisputeCase _DisputeCase
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard
_CreatedByContactCard _CreatedByContactCard
_DisputeCaseCoordinatorCard _DisputeCaseCoordinatorCard
_ProcessorContactCard _ProcessorContactCard
_ResponsibleContactCard _ResponsibleContactCard

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_CollsInvoiceRelatedDsputCase.
-- 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.

CREATE VIEW I_CollsInvoiceRelatedDsputCase AS
SELECT
  LogicalSystem,
  ObjectType,
  ObjectKey,
  CaseUniqueID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  CaseID,
  _DisputeCase.DisputeCaseCoordinator AS DisputeCaseCoordinator,
  _DisputeCase.CaseCreatedBy AS CaseCreatedBy,
  _DisputeCase.CaseLastChangedBy AS CaseLastChangedBy,
  _DisputeCase.CaseClosedBy AS CaseClosedBy,
  _DisputeCase.CaseProcessor AS CaseProcessor,
  _DisputeCase.CaseResponsible AS CaseResponsible,
  cast ( 1 as int4 ) AS NumberOfDisputeCases
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByContactCard ON casecreatedby = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ChangedByContactCard ON caselastchangedby = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ClosedByContactCard ON caseclosedby = _ClosedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _DisputeCaseCoordinatorCard ON disputecasecoordinator = _DisputeCaseCoordinatorCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ProcessorContactCard ON caseprocessor = _ProcessorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ResponsibleContactCard ON caseresponsible = _ResponsibleContactCard.ContactCardID  -- association [0..1]
;

Learn More