I_JrnlEntrDsputCasePosblAssg

DDL: I_JRNLENTRDSPUTCASEPOSBLASSG Type: view_entity BASIC Package: ODATA_DISPUTE_OI_ASSIGNM
68 Fields 1 Data Sources 1 Associations

Possible Dispute Case Assignments

I_JrnlEntrDsputCasePosblAssg is a Basic CDS View that provides data about "Possible Dispute Case Assignments" in SAP S/4HANA. It reads from 1 data source (R_DisputeCase) and exposes 68 fields with key fields DisputeCaseUUID, CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 1 association to related views. Part of development package ODATA_DISPUTE_OI_ASSIGNM.

Data Sources (1)

SourceAliasJoin Type
R_DisputeCase R_DisputeCase from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Possible Dispute Case Assignments view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey DisputeCaseUUID view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY DisputeCaseUUID R_DisputeCase DisputeCaseUUID UUID
KEY CompanyCode I_CollsInvoiceRelatedDsputCase CompanyCode Receiver Company Code
KEY FiscalYear I_CollsInvoiceRelatedDsputCase FiscalYear G/L Fiscal Year
KEY AccountingDocument I_CollsInvoiceRelatedDsputCase AccountingDocument Journal Entry
KEY AccountingDocumentItem I_CollsInvoiceRelatedDsputCase AccountingDocumentItem Posting View Item
DisputeCaseCoordinator R_DisputeCase DisputeCaseCoordinator Coordinator
DisputeCaseRootCause R_DisputeCase DisputeCaseRootCause Root Cause Code
CaseProcessingDeadlineDate R_DisputeCase CaseProcessingDeadlineDate Process. Deadline
OriginalAmount R_DisputeCase OriginalAmount Original Disputed Amount
DisputedAmount R_DisputeCase DisputedAmount Disputed Amount
PaidAmount R_DisputeCase PaidAmount Paid Amount
CreditedAmount R_DisputeCase CreditedAmount Credited
WriteOffAmount R_DisputeCase WriteOffAmount Cleared Manually
ManuallyClearedAmount R_DisputeCase ManuallyClearedAmount Automatically Written Off
DisputeCaseCurrency R_DisputeCase DisputeCaseCurrency Currency
CustomerDisputedAmount R_DisputeCase CustomerDisputedAmount Customer Disputed Amount
CustomerDisputedCurrency R_DisputeCase CustomerDisputedCurrency Currency
ContactPersonName R_DisputeCase ContactPersonName Full Name
ContactPersonEmailAddress R_DisputeCase ContactPersonEmailAddress Email
ContactPersonPhoneNumber R_DisputeCase ContactPersonPhoneNumber Telephone No.
ContactPersonFaxNumber R_DisputeCase ContactPersonFaxNumber Fax Number
Customer R_DisputeCase Customer Sold-to Party
DisputeCaseExternalApplication R_DisputeCase DisputeCaseExternalApplication External Appl.
CaseType R_DisputeCase CaseType Upper/Lowercase
CaseID R_DisputeCase CaseID Case ID
CaseExternalReference R_DisputeCase CaseExternalReference External Reference
CaseCreatedBy R_DisputeCase CaseCreatedBy Created By
CaseCreatedOn R_DisputeCase CaseCreatedOn Created At
CaseLastChangedBy R_DisputeCase CaseLastChangedBy Changed By
CaseLastChangedOn R_DisputeCase CaseLastChangedOn Last Changed At
CaseClosedBy R_DisputeCase CaseClosedBy Closed By
CaseClosedTime R_DisputeCase CaseClosedTime Closed At
CasePlannedCloseDate R_DisputeCase CasePlannedCloseDate Planned Close Date
CaseProcessor R_DisputeCase CaseProcessor Processor
CaseResponsible R_DisputeCase CaseResponsible Person Responsible
CaseTitle R_DisputeCase CaseTitle Case Title
CaseEscalationReason R_DisputeCase CaseEscalationReason Escalation Reason
CaseCategory R_DisputeCase CaseCategory Category
CasePriority R_DisputeCase CasePriority Priority
CaseAuthorizationLevel R_DisputeCase CaseAuthorizationLevel Auth. Level
CaseStatusProfile R_DisputeCase CaseStatusProfile Status Profile
CaseStatus R_DisputeCase CaseStatus Status
CaseSystemStatus R_DisputeCase CaseSystemStatus System Status
CaseReason R_DisputeCase CaseReason Reason
CaseUserStatusName R_DisputeCase CaseUserStatusName User Status
Criticality
DisputeCaseAssgmtRankingValue
DisputeCaseAssgmtRankingName
_CompanyCode _CompanyCode
_AuthLevel R_DisputeCase _AuthLevel
_CaseAttribute R_DisputeCase _CaseAttribute
_CaseCategory R_DisputeCase _CaseCategory
_CaseSystemStatus R_DisputeCase _CaseSystemStatus
_CaseTypes R_DisputeCase _CaseTypes
_ChangedByContactCard R_DisputeCase _ChangedByContactCard
_ClosedByContactCard R_DisputeCase _ClosedByContactCard
_CreatedByContactCard R_DisputeCase _CreatedByContactCard
_Customer R_DisputeCase _Customer
_DisputeCaseCoordinatorCard R_DisputeCase _DisputeCaseCoordinatorCard
_DisputeCaseExternalAppl R_DisputeCase _DisputeCaseExternalAppl
_Escalation R_DisputeCase _Escalation
_Individual R_DisputeCase _Individual
_Priority R_DisputeCase _Priority
_ProcessorContactCard R_DisputeCase _ProcessorContactCard
_Reasons R_DisputeCase _Reasons
_ResponsibleContactCard R_DisputeCase _ResponsibleContactCard
_RootCause R_DisputeCase _RootCause
_StatProfile R_DisputeCase _StatProfile

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_JrnlEntrDsputCasePosblAssg.
-- 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_JrnlEntrDsputCasePosblAssg AS
SELECT
  R_DisputeCase.DisputeCaseUUID AS DisputeCaseUUID,
  I_CollsInvoiceRelatedDsputCase.CompanyCode AS CompanyCode,
  I_CollsInvoiceRelatedDsputCase.FiscalYear AS FiscalYear,
  I_CollsInvoiceRelatedDsputCase.AccountingDocument AS AccountingDocument,
  I_CollsInvoiceRelatedDsputCase.AccountingDocumentItem AS AccountingDocumentItem,
  R_DisputeCase.DisputeCaseCoordinator AS DisputeCaseCoordinator,
  R_DisputeCase.DisputeCaseRootCause AS DisputeCaseRootCause,
  R_DisputeCase.CaseProcessingDeadlineDate AS CaseProcessingDeadlineDate,
  R_DisputeCase.OriginalAmount AS OriginalAmount,
  R_DisputeCase.DisputedAmount AS DisputedAmount,
  R_DisputeCase.PaidAmount AS PaidAmount,
  R_DisputeCase.CreditedAmount AS CreditedAmount,
  R_DisputeCase.WriteOffAmount AS WriteOffAmount,
  R_DisputeCase.ManuallyClearedAmount AS ManuallyClearedAmount,
  R_DisputeCase.DisputeCaseCurrency AS DisputeCaseCurrency,
  R_DisputeCase.CustomerDisputedAmount AS CustomerDisputedAmount,
  R_DisputeCase.CustomerDisputedCurrency AS CustomerDisputedCurrency,
  R_DisputeCase.ContactPersonName AS ContactPersonName,
  R_DisputeCase.ContactPersonEmailAddress AS ContactPersonEmailAddress,
  R_DisputeCase.ContactPersonPhoneNumber AS ContactPersonPhoneNumber,
  R_DisputeCase.ContactPersonFaxNumber AS ContactPersonFaxNumber,
  R_DisputeCase.Customer AS Customer,
  R_DisputeCase.DisputeCaseExternalApplication AS DisputeCaseExternalApplication,
  R_DisputeCase.CaseType AS CaseType,
  R_DisputeCase.CaseID AS CaseID,
  R_DisputeCase.CaseExternalReference AS CaseExternalReference,
  R_DisputeCase.CaseCreatedBy AS CaseCreatedBy,
  R_DisputeCase.CaseCreatedOn AS CaseCreatedOn,
  R_DisputeCase.CaseLastChangedBy AS CaseLastChangedBy,
  R_DisputeCase.CaseLastChangedOn AS CaseLastChangedOn,
  R_DisputeCase.CaseClosedBy AS CaseClosedBy,
  R_DisputeCase.CaseClosedTime AS CaseClosedTime,
  R_DisputeCase.CasePlannedCloseDate AS CasePlannedCloseDate,
  R_DisputeCase.CaseProcessor AS CaseProcessor,
  R_DisputeCase.CaseResponsible AS CaseResponsible,
  R_DisputeCase.CaseTitle AS CaseTitle,
  R_DisputeCase.CaseEscalationReason AS CaseEscalationReason,
  R_DisputeCase.CaseCategory AS CaseCategory,
  R_DisputeCase.CasePriority AS CasePriority,
  R_DisputeCase.CaseAuthorizationLevel AS CaseAuthorizationLevel,
  R_DisputeCase.CaseStatusProfile AS CaseStatusProfile,
  R_DisputeCase.CaseStatus AS CaseStatus,
  R_DisputeCase.CaseSystemStatus AS CaseSystemStatus,
  R_DisputeCase.CaseReason AS CaseReason,
  R_DisputeCase.CaseUserStatusName AS CaseUserStatusName,
  cast( '00' as eve_tv_criticality ) AS Criticality,
  cast( '0' as fdm_cdis_ranking ) AS DisputeCaseAssgmtRankingValue,
  cast( '' as fdm_cdis_ranking_descr ) AS DisputeCaseAssgmtRankingName,
  R_DisputeCase._AuthLevel AS _AuthLevel,
  R_DisputeCase._CaseAttribute AS _CaseAttribute,
  R_DisputeCase._CaseCategory AS _CaseCategory,
  R_DisputeCase._CaseSystemStatus AS _CaseSystemStatus,
  R_DisputeCase._CaseTypes AS _CaseTypes,
  R_DisputeCase._ChangedByContactCard AS _ChangedByContactCard,
  R_DisputeCase._ClosedByContactCard AS _ClosedByContactCard,
  R_DisputeCase._CreatedByContactCard AS _CreatedByContactCard,
  R_DisputeCase._Customer AS _Customer,
  R_DisputeCase._DisputeCaseCoordinatorCard AS _DisputeCaseCoordinatorCard,
  R_DisputeCase._DisputeCaseExternalAppl AS _DisputeCaseExternalAppl,
  R_DisputeCase._Escalation AS _Escalation,
  R_DisputeCase._Individual AS _Individual,
  R_DisputeCase._Priority AS _Priority,
  R_DisputeCase._ProcessorContactCard AS _ProcessorContactCard,
  R_DisputeCase._Reasons AS _Reasons,
  R_DisputeCase._ResponsibleContactCard AS _ResponsibleContactCard,
  R_DisputeCase._RootCause AS _RootCause,
  R_DisputeCase._StatProfile AS _StatProfile
FROM R_DisputeCase
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More