C_CADisputedDocumentTP

DDL: C_CADISPUTEDDOCUMENTTP SQL: CCADCDOCTP Type: view CONSUMPTION
38 Fields 1 Data Sources 1 Associations

Documents in Dispute Cases

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

Data Sources (1)

SourceAliasJoin Type
I_CADisputedDocumentTP I_CADisputedDocumentTP from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CADisputedDocumentItem _Item $projection.CADocumentNumber = _Item.CADocumentNumber association[1..1] to C_CADisputeCaseTP as _CADisputeCaseTP on $projection.CaseUniqueID = _CADisputeCaseTP.CaseUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCADCDOCTP 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
ObjectModel.transactionalProcessingDelegated 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
VDM.viewType #CONSUMPTION view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CaseUniqueID I_CADisputedDocumentTP CaseUniqueID
KEY CADocumentNumber I_CADisputedDocumentTP CADocumentNumber Document Number
ObjectType I_CADisputedDocumentTP ObjectType Type
ObjectKey I_CADisputedDocumentTP ObjectKey Object Key
RelationshipNumber I_CADisputedDocumentTP RelationshipNumber BP Rel. Number
RelationToLinkedObject I_CADisputedDocumentTP RelationToLinkedObject
CAAmountInTransactionCurrency I_CADisputedDocumentTP CAAmountInTransactionCurrency Amount
TransactionCurrency I_CADisputedDocumentTP TransactionCurrency Transaction Currency
CAMainTransaction I_CADisputedDocumentTP CAMainTransaction Main Trans.
CASubTransaction I_CADisputedDocumentTP CASubTransaction Subtransaction
CANetDueDate I_CADisputedDocumentTP CANetDueDate Net Due Date
CADeferralDate I_CADisputedDocumentTP CADeferralDate Deferral To
CAClearingDate I_CADisputedDocumentTP CAClearingDate Clearing
CAClearingReasonName I_CADisputedDocumentTP CAClearingReasonName
CAClearingReason I_CADisputedDocumentTP CAClearingReason Clearing Reason
OpenAmountInTransCrcy I_CADisputedDocumentTP OpenAmountInTransCrcy Open Amt Trans Crcy
CAMainTransactionName I_CADisputedDocumentTP CAMainTransactionName Main Transactn
CASubTransactionName I_CADisputedDocumentTP CASubTransactionName Subtransaction
BusinessPartner I_CADisputedDocumentTP BusinessPartner Issuing Authority
ContractAccount I_CADisputedDocumentTP ContractAccount Contract Acct
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
_Item _Item
_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 C_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: CCADCDOCTP

CREATE VIEW C_CADisputedDocumentTP AS
SELECT
  I_CADisputedDocumentTP.CaseUniqueID AS CaseUniqueID,
  I_CADisputedDocumentTP.CADocumentNumber AS CADocumentNumber,
  I_CADisputedDocumentTP.ObjectType AS ObjectType,
  I_CADisputedDocumentTP.ObjectKey AS ObjectKey,
  I_CADisputedDocumentTP.RelationshipNumber AS RelationshipNumber,
  I_CADisputedDocumentTP.RelationToLinkedObject AS RelationToLinkedObject,
  I_CADisputedDocumentTP.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  I_CADisputedDocumentTP.TransactionCurrency AS TransactionCurrency,
  I_CADisputedDocumentTP.CAMainTransaction AS CAMainTransaction,
  I_CADisputedDocumentTP.CASubTransaction AS CASubTransaction,
  I_CADisputedDocumentTP.CANetDueDate AS CANetDueDate,
  I_CADisputedDocumentTP.CADeferralDate AS CADeferralDate,
  I_CADisputedDocumentTP.CAClearingDate AS CAClearingDate,
  I_CADisputedDocumentTP.CAClearingReasonName AS CAClearingReasonName,
  I_CADisputedDocumentTP.CAClearingReason AS CAClearingReason,
  I_CADisputedDocumentTP.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  I_CADisputedDocumentTP.CAMainTransactionName AS CAMainTransactionName,
  I_CADisputedDocumentTP.CASubTransactionName AS CASubTransactionName,
  I_CADisputedDocumentTP.BusinessPartner AS BusinessPartner,
  I_CADisputedDocumentTP.ContractAccount AS ContractAccount,
  CreationDate,
  CreationTime,
  CADocumentOriginCodeName,
  CreatedByUser,
  CADocumentOriginCode,
  DocumentDate,
  CAPostingDate,
  CAReferenceDocument,
  CADocumentTypeName,
  CAReconciliationKey,
  CAReversalDocumentNumber,
  CAReversedDocumentNumber
FROM I_CADisputedDocumentTP
LEFT OUTER JOIN C_CADisputedDocumentItem AS _Item ON CADocumentNumber = _Item.CADocumentNumber association[1..1] to C_CADisputeCaseTP as _CADisputeCaseTP on CaseUniqueID = _CADisputeCaseTP.CaseUUID  -- association [0..*]
;

Learn More