C_CANotDisputedOpenDoc

DDL: C_CANOTDISPUTEDOPENDOC SQL: CNOTDSPUTDOPNDOC Type: view CONSUMPTION
35 Fields 1 Data Sources 3 Associations

Not Disputed Open Doc

C_CANotDisputedOpenDoc is a Consumption CDS View that provides data about "Not Disputed Open Doc" in SAP S/4HANA. It reads from 1 data source (I_CANotDisputedOpenDoc) and exposes 35 fields with key field CADocumentNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CANotDisputedOpenDoc I_CANotDisputedOpenDoc from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_CANotDisputedOpenItem _OpenItem $projection.CADocumentNumber = _OpenItem.CADocumentNumber
[0..1] P_CANotDisputedDocIsBlocked _CADocumentIsBlocked $projection.CADocumentNumber = _CADocumentIsBlocked.CADocumentNumber
[1..1] I_ContractAccountHeader _ContractAccount $projection.ContractAccount = _ContractAccount.ContractAccount

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CNOTDSPUTDOPNDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Not Disputed Open Doc view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
TransactionCurrency TransactionCurrency Transaction Currency
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CANetDueDate CANetDueDate Net Due Date
CADeferralDate CADeferralDate Deferral To
CAClearingDate CAClearingDate Clearing
CAClearingReasonName CAClearingReasonName
CAClearingReason CAClearingReason Clearing Reason
OpenAmountInTransCrcy OpenAmountInTransCrcy Open Amt Trans Crcy
CAMainTransactionName CAMainTransactionName Main Transactn
CASubTransactionName CASubTransactionName Subtransaction
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CompanyCode CompanyCode Receiver Company Code
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CADocumentOriginCodeName CADocumentOriginCodeName
CreatedByUser CreatedByUser User Name
CADocumentOriginCode CADocumentOriginCode Document Origin
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
CAPostingDate CAPostingDate Posting Date
CAReferenceDocument CAReferenceDocument Reference
ReferenceDocumentType ReferenceDocumentType Reference Document Type
CADocumentTypeName CADocumentTypeName
DocumentDate DocumentDate Journal Entry Date
CAReconciliationKey CAReconciliationKey Reconcil. Key
IsBusinessPurposeCompleted _CADocumentIsBlocked IsBusinessPurposeCompleted Purpose Completed
_ContractAccount _ContractAccount
_DocOriginCode _DocOriginCode
_OpenItem _OpenItem

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_CANotDisputedOpenDoc.
-- 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: CNOTDSPUTDOPNDOC

CREATE VIEW C_CANotDisputedOpenDoc AS
SELECT
  CADocumentNumber,
  CAAmountInTransactionCurrency,
  TransactionCurrency,
  CAMainTransaction,
  CASubTransaction,
  CANetDueDate,
  CADeferralDate,
  CAClearingDate,
  CAClearingReasonName,
  CAClearingReason,
  OpenAmountInTransCrcy,
  CAMainTransactionName,
  CASubTransactionName,
  BusinessPartner,
  ContractAccount,
  CAContract,
  CASubApplication,
  CompanyCode,
  CreationDate,
  CreationTime,
  CADocumentOriginCodeName,
  CreatedByUser,
  CADocumentOriginCode,
  CAReversalDocumentNumber,
  CAReversedDocumentNumber,
  CAPostingDate,
  CAReferenceDocument,
  ReferenceDocumentType,
  CADocumentTypeName,
  DocumentDate,
  CAReconciliationKey,
  _CADocumentIsBlocked.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_CANotDisputedOpenDoc
LEFT OUTER JOIN C_CANotDisputedOpenItem AS _OpenItem ON CADocumentNumber = _OpenItem.CADocumentNumber  -- association [0..*]
LEFT OUTER JOIN P_CANotDisputedDocIsBlocked AS _CADocumentIsBlocked ON CADocumentNumber = _CADocumentIsBlocked.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [1..1]
;

Learn More