I_CADisputedDocumentTP

DDL: I_CADISPUTEDDOCUMENTTP SQL: ICADCDOCTP Type: view TRANSACTIONAL
38 Fields 1 Data Sources

Documents in Dispute Cases

I_CADisputedDocumentTP is a Transactional CDS View that provides data about "Documents in Dispute Cases" in SAP S/4HANA. It reads from 1 data source (I_CADisputedDocument) and exposes 38 fields with key fields CADocumentNumber, CaseUniqueID.

Data Sources (1)

SourceAliasJoin Type
I_CADisputedDocument _DisputedDoc from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICADCDOCTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Documents in Dispute Cases view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence CADISPDOC_D view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADisputedDocument CADocumentNumber Document Number
KEY CaseUniqueID I_CADisputedDocument CaseUniqueID
ObjectType I_CADisputedDocument ObjectType Type
ObjectKey I_CADisputedDocument ObjectKey Object Key
RelationshipNumber I_CADisputedDocument RelationshipNumber BP Rel. Number
RelationToLinkedObject I_CADisputedDocument RelationToLinkedObject
CAAmountInTransactionCurrency I_CADisputedDocument CAAmountInTransactionCurrency Amount
TransactionCurrency I_CADisputedDocument TransactionCurrency Transaction Currency
CAMainTransaction I_CADisputedDocument CAMainTransaction Main Trans.
CASubTransaction I_CADisputedDocument CASubTransaction Subtransaction
CAContract I_CADisputedDocument CAContract Contract
ContractAccount I_CADisputedDocument ContractAccount Contract Acct
BusinessPartner I_CADisputedDocument BusinessPartner Issuing Authority
CANetDueDate I_CADisputedDocument CANetDueDate Net Due Date
CADeferralDate I_CADisputedDocument CADeferralDate Deferral To
CAClearingDate I_CADisputedDocument CAClearingDate Clearing
CAClearingReason I_CADisputedDocument CAClearingReason Clearing Reason
OpenAmountInTransCrcy I_CADisputedDocument OpenAmountInTransCrcy Open Amt Trans Crcy
CAMainTransactionName I_CADisputedDocument CAMainTransactionName Main Transactn
CASubTransactionName I_CADisputedDocument CASubTransactionName Subtransaction
CAClearingReasonName I_CADisputedDocument CAClearingReasonName
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CADocumentOriginCodeName CADocumentOriginCodeName
CreatedByUser CreatedByUser User Name
CADocumentOriginCode CADocumentOriginCode Document Origin
DocumentDate DocumentDate Journal Entry Date
CAPostingDate CAPostingDate Posting Date
CAReferenceDocument CAReferenceDocument Reference
CADocumentTypeName CADocumentTypeName
CAReconciliationKey CAReconciliationKey Reconcil. Key
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
_BusinessPartner _BusinessPartner
_ContractAccount _ContractAccount
_Currency _Currency
_DocOriginCode _DocOriginCode
_CADisputeCaseTP _CADisputeCaseTP

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_CADisputedDocumentTP.
-- 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: ICADCDOCTP

CREATE VIEW I_CADisputedDocumentTP AS
SELECT
  _DisputedDoc.CADocumentNumber AS CADocumentNumber,
  _DisputedDoc.CaseUniqueID AS CaseUniqueID,
  _DisputedDoc.ObjectType AS ObjectType,
  _DisputedDoc.ObjectKey AS ObjectKey,
  _DisputedDoc.RelationshipNumber AS RelationshipNumber,
  _DisputedDoc.RelationToLinkedObject AS RelationToLinkedObject,
  _DisputedDoc.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _DisputedDoc.TransactionCurrency AS TransactionCurrency,
  _DisputedDoc.CAMainTransaction AS CAMainTransaction,
  _DisputedDoc.CASubTransaction AS CASubTransaction,
  _DisputedDoc.CAContract AS CAContract,
  _DisputedDoc.ContractAccount AS ContractAccount,
  _DisputedDoc.BusinessPartner AS BusinessPartner,
  _DisputedDoc.CANetDueDate AS CANetDueDate,
  _DisputedDoc.CADeferralDate AS CADeferralDate,
  _DisputedDoc.CAClearingDate AS CAClearingDate,
  _DisputedDoc.CAClearingReason AS CAClearingReason,
  _DisputedDoc.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  _DisputedDoc.CAMainTransactionName AS CAMainTransactionName,
  _DisputedDoc.CASubTransactionName AS CASubTransactionName,
  _DisputedDoc.CAClearingReasonName AS CAClearingReasonName,
  CreationDate,
  CreationTime,
  CADocumentOriginCodeName,
  CreatedByUser,
  CADocumentOriginCode,
  DocumentDate,
  CAPostingDate,
  CAReferenceDocument,
  CADocumentTypeName,
  CAReconciliationKey,
  CAReversalDocumentNumber,
  CAReversedDocumentNumber
FROM I_CADisputedDocument AS _DisputedDoc
;

Learn More