P_CANotDisputedDocumentSum

DDL: P_CANOTDISPUTEDDOCUMENTSUM SQL: PCANOTDCDOCS Type: view COMPOSITE
33 Fields 4 Data Sources 1 Associations

Not Disputed Document

P_CANotDisputedDocumentSum is a Composite CDS View that provides data about "Not Disputed Document" in SAP S/4HANA. It reads from 4 data sources (I_CADocumentHeader, I_CAMainTransaction, I_CADocumentBPItemPhysical, I_CASubTransaction) and exposes 33 fields with key fields CADocumentNumber, BusinessPartner, ContractAccount, CAMainTransaction, CASubTransaction. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
I_CADocumentHeader _DocumentHeader inner
I_CAMainTransaction _MainTransaction inner
I_CADocumentBPItemPhysical _NotDisputedDoc from
I_CASubTransaction _SubTransaction inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CAClearingReason _ClearingReason $projection.CAClearingReason = _ClearingReason.CAClearingReason

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCANOTDCDOCS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Not Disputed Document view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItemPhysical CADocumentNumber Document Number
KEY BusinessPartner I_CADocumentBPItemPhysical BusinessPartner Issuing Authority
KEY ContractAccount I_CADocumentBPItemPhysical ContractAccount Contract Acct
KEY CAMainTransaction I_CADocumentBPItemPhysical CAMainTransaction Main Trans.
KEY CASubTransaction I_CADocumentBPItemPhysical CASubTransaction Subtransaction
KEY CAClearingReason I_CADocumentBPItemPhysical CAClearingReason Clearing Reason
CAContract I_CADocumentBPItemPhysical CAContract Contract
CompanyCode I_CADocumentBPItemPhysical CompanyCode Receiver Company Code
CASubApplication I_CADocumentBPItemPhysical CASubApplication Subapplication
CANetDueDate I_CADocumentBPItemPhysical CANetDueDate Net Due Date
CADeferralDate I_CADocumentBPItemPhysical CADeferralDate Deferral To
CAClearingDate I_CADocumentBPItemPhysical CAClearingDate Clearing
CAApplicationArea I_CADocumentBPItemPhysical CAApplicationArea ApplicationArea
TransactionCurrency I_CADocumentBPItemPhysical TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency
CreationDate
CreationTime
CAPostingDate I_CADocumentHeader CAPostingDate Posting Date
CAReferenceDocument I_CADocumentHeader CAReferenceDocument Reference
ReferenceDocumentType I_CADocumentHeader ReferenceDocumentType Reference Document Type
CADocumentTypeName
DocumentDate I_CADocumentHeader DocumentDate Journal Entry Date
CAReconciliationKey I_CADocumentHeader CAReconciliationKey Reconcil. Key
CADocumentOriginCodeName I_CADocumentHeader CADocumentOriginCodeName
CreatedByUser I_CADocumentHeader CreatedByUser User Name
CADocumentOriginCode I_CADocumentHeader CADocumentOriginCode Document Origin
CAReversalDocumentNumber I_CADocumentHeader CAReversalDocumentNumber Revers.document
CAReversedDocumentNumber I_CADocumentHeader CAReversedDocumentNumber Rev. Doc. For
CAClearingReasonName
CAMainTransactionName
CASubTransactionName
CAClearingDocumentNumber I_CADocumentBPItemPhysical CAClearingDocumentNumber Clearing Doc.
_ClearingReason _ClearingReason

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 P_CANotDisputedDocumentSum.
-- 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: PCANOTDCDOCS

CREATE VIEW P_CANotDisputedDocumentSum AS
SELECT
  _NotDisputedDoc.CADocumentNumber AS CADocumentNumber,
  _NotDisputedDoc.BusinessPartner AS BusinessPartner,
  _NotDisputedDoc.ContractAccount AS ContractAccount,
  _NotDisputedDoc.CAMainTransaction AS CAMainTransaction,
  _NotDisputedDoc.CASubTransaction AS CASubTransaction,
  _NotDisputedDoc.CAClearingReason AS CAClearingReason,
  _NotDisputedDoc.CAContract AS CAContract,
  _NotDisputedDoc.CompanyCode AS CompanyCode,
  _NotDisputedDoc.CASubApplication AS CASubApplication,
  _NotDisputedDoc.CANetDueDate AS CANetDueDate,
  _NotDisputedDoc.CADeferralDate AS CADeferralDate,
  _NotDisputedDoc.CAClearingDate AS CAClearingDate,
  _NotDisputedDoc.CAApplicationArea AS CAApplicationArea,
  _NotDisputedDoc.TransactionCurrency AS TransactionCurrency,
  cast(_NotDisputedDoc.CAAmountInTransactionCurrency as betrw_kk) AS CAAmountInTransactionCurrency,
  cast(_DocumentHeader.CreationDate as erdat) AS CreationDate,
  cast(_DocumentHeader.CreationTime as crtime_kk) AS CreationTime,
  _DocumentHeader.CAPostingDate AS CAPostingDate,
  _DocumentHeader.CAReferenceDocument AS CAReferenceDocument,
  _DocumentHeader.ReferenceDocumentType AS ReferenceDocumentType,
  _DocumentHeader._DocType._Text[1:Language = $session.system_language].CADocumentTypeName AS CADocumentTypeName,
  _DocumentHeader.DocumentDate AS DocumentDate,
  _DocumentHeader.CAReconciliationKey AS CAReconciliationKey,
  _DocumentHeader.CADocumentOriginCodeName AS CADocumentOriginCodeName,
  _DocumentHeader.CreatedByUser AS CreatedByUser,
  _DocumentHeader.CADocumentOriginCode AS CADocumentOriginCode,
  _DocumentHeader.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _DocumentHeader.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  cast(_ClearingReason._Text[1:Language = $session.system_language].CAClearingReasonName as augrd_gfn_kk ) AS CAClearingReasonName,
  _MainTransaction._Text[1:Language = $session.system_language].CAMainTransactionName AS CAMainTransactionName,
  _SubTransaction._Text[1:Language = $session.system_language].CASubTransactionName AS CASubTransactionName,
  _NotDisputedDoc.CAClearingDocumentNumber AS CAClearingDocumentNumber
FROM I_CADocumentBPItemPhysical AS _NotDisputedDoc
INNER JOIN I_CADocumentHeader AS _DocumentHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_CAMainTransaction AS _MainTransaction ON /* join condition not captured in parsed metadata */
INNER JOIN I_CASubTransaction AS _SubTransaction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CAClearingReason AS _ClearingReason ON CAClearingReason = _ClearingReason.CAClearingReason  -- association [1..1]
;

Learn More