R_JrnlEntrDsputCasePosblAssgTP

DDL: R_JRNLENTRDSPUTCASEPOSBLASSGTP Type: view_entity TRANSACTIONAL Package: ODATA_DISPUTE_OI_ASSIGNM
70 Fields 1 Data Sources 1 Associations

Dispute Case Possible Assignment

R_JrnlEntrDsputCasePosblAssgTP is a Transactional CDS View that provides data about "Dispute Case Possible Assignment" in SAP S/4HANA. It reads from 1 data source (I_JrnlEntrDsputCasePosblAssg) and exposes 70 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
I_JrnlEntrDsputCasePosblAssg I_JrnlEntrDsputCasePosblAssg from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_DisputeCase _DisputeCase $projection.DisputeCaseUUID = _DisputeCase.DisputeCaseUUID

Annotations (9)

NameValueLevelField
EndUserText.label Dispute Case Possible Assignment view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey DisputeCaseUUID view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view

Fields (70)

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

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

Learn More