C_DsputCaseJrnlEntrAssgTP

DDL: C_DSPUTCASEJRNLENTRASSGTP Type: view_entity CONSUMPTION
37 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Proposed Assignments

C_DsputCaseJrnlEntrAssgTP is a Consumption CDS View that provides data about "Proposed Assignments" in SAP S/4HANA. It reads from 1 data source (R_DsputCaseJrnlEntrAssgmtTP) and exposes 37 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, Customer. It has 1 association to related views. It is exposed through 1 OData service (UI_DISPUTE_PROPOSAL_ASSGMT). It is used in 1 Fiori application: Manage Assignment Proposals for Dispute Cases.

Data Sources (1)

SourceAliasJoin Type
R_DsputCaseJrnlEntrAssgmtTP R_DsputCaseJrnlEntrAssgmtTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_DisputeCaseTP _ProposedDisputeCase $projection.CaseUUID = _ProposedDisputeCase.DisputeCaseUUID

Annotations (7)

NameValueLevelField
EndUserText.label Proposed Assignments view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_DISPUTE_PROPOSAL_ASSGMT UI_DISPUTE_PROPOSAL_ASSGMT V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5999 Manage Assignment Proposals for Dispute Cases Transactional Use this app to manage assignment proposals for dispute cases to open FI documents.

Manage Assignment Proposals for Dispute Cases

Business Role: Others

Use this new app to display, edit, and assign the assignment proposals of dispute cases to open items. You can revise the proposed assignments and assign the proposed dispute cases to the open items.

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY Customer Customer Sold-to Party
AmountInTransactionCurrency _OperationalAcctgDocItem AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency _OperationalAcctgDocItem TransactionCurrency Transaction Currency
BillingDocument _OperationalAcctgDocItem BillingDocument SD Document
PostingDate _OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate _OperationalAcctgDocItem DocumentDate Journal Entry Date
DocumentReferenceID
AccountingDocumentType _OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
DisputeCaseProcessor DisputeCaseProcessor
NumberOfMatchingDisputeCases NumberOfMatchingDisputeCases
JournalEntryHasAssgmtConflict JournalEntryHasAssgmtConflict
JrnlEntrIsAssgdToDsputCase JrnlEntrIsAssgdToDsputCase
CaseUUID CaseUUID UUID
CaseID _DisputeCase CaseID Case ID
CaseReason _DisputeCase CaseReason Reason
CaseExternalReference _DisputeCase CaseExternalReference External Reference
CustomerDisputedAmount _DisputeCase CustomerDisputedAmount Customer Disputed Amount
CustomerDisputedCurrency _DisputeCase CustomerDisputedCurrency Currency
DisputeCaseProcessorFullName _DisputeCaseProcessor UserDescription Full Name
CaseReasonNamelocalized
CustomerName _Customer CustomerName Name of Customer
CompanyCodeName _CompanyCode CompanyCodeName Company Name
AccountingDocumentTypeNamelocalized
FirstName _DisputeCaseProcessor FirstName First Name
LastName _DisputeCaseProcessor LastName Last Name
OrganizationBPName1 _Customer OrganizationBPName1 Name 1
OrganizationBPName2 _Customer OrganizationBPName2 Name 2
_AccountingDocument _AccountingDocument
_CompanyCode _CompanyCode
_Customer _Customer
_DisputeCaseredirectedtoC_DisputeCaseTP
_OperationalAcctgDocItem _OperationalAcctgDocItem
_ProposedDisputeCase _ProposedDisputeCase

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 C_DsputCaseJrnlEntrAssgTP.
-- 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 C_DsputCaseJrnlEntrAssgTP AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  Customer,
  _OperationalAcctgDocItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _OperationalAcctgDocItem.TransactionCurrency AS TransactionCurrency,
  _OperationalAcctgDocItem.BillingDocument AS BillingDocument,
  _OperationalAcctgDocItem.PostingDate AS PostingDate,
  _OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  _OperationalAcctgDocItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _OperationalAcctgDocItem.AccountingDocumentType AS AccountingDocumentType,
  DisputeCaseProcessor,
  NumberOfMatchingDisputeCases,
  JournalEntryHasAssgmtConflict,
  JrnlEntrIsAssgdToDsputCase,
  CaseUUID,
  _DisputeCase.CaseID AS CaseID,
  _DisputeCase.CaseReason AS CaseReason,
  _DisputeCase.CaseExternalReference AS CaseExternalReference,
  _DisputeCase.CustomerDisputedAmount AS CustomerDisputedAmount,
  _DisputeCase.CustomerDisputedCurrency AS CustomerDisputedCurrency,
  _DisputeCaseProcessor.UserDescription AS DisputeCaseProcessorFullName,
  _DisputeCase._Reasons._Text.CaseReasonName : localized AS CaseReasonNamelocalized,
  _Customer.CustomerName AS CustomerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _OperationalAcctgDocItem._AccountingDocumentType._Text.AccountingDocumentTypeName : localized AS AccountingDocumentTypeNamelocalized,
  _DisputeCaseProcessor.FirstName AS FirstName,
  _DisputeCaseProcessor.LastName AS LastName,
  _Customer.OrganizationBPName1 AS OrganizationBPName1,
  _Customer.OrganizationBPName2 AS OrganizationBPName2
FROM R_DsputCaseJrnlEntrAssgmtTP
LEFT OUTER JOIN C_DisputeCaseTP AS _ProposedDisputeCase ON CaseUUID = _ProposedDisputeCase.DisputeCaseUUID  -- association [0..*]
;

Learn More