I_CANotDisputedDocument

DDL: I_CANOTDISPUTEDDOCUMENT SQL: ICANOTDISDOC Type: view TRANSACTIONAL Package: ODATA_O2C_FICA_DISPUTE_MANAGE
36 Fields 1 Data Sources 2 Associations

Not Disputed Document

I_CANotDisputedDocument is a Transactional CDS View that provides data about "Not Disputed Document" in SAP S/4HANA. It reads from 1 data source (P_CANotDisputedDocumentSum) and exposes 36 fields with key fields CADocumentNumber, BusinessPartner, ContractAccount, CAMainTransaction, CASubTransaction. It has 2 associations to related views. Part of development package ODATA_O2C_FICA_DISPUTE_MANAGE.

Data Sources (1)

SourceAliasJoin Type
P_CANotDisputedDocumentSum _NotDisputedDoc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ContractAccountPartner _CAPartner $projection.BusinessPartner = _CAPartner.BusinessPartner and $projection.ContractAccount = _CAPartner.ContractAccount
[0..1] I_User _CreatedBy $projection.CreatedByUser = _CreatedBy.UserID

Annotations (10)

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

Fields (36)

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

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_CANotDisputedDocument.
-- 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: ICANOTDISDOC

CREATE VIEW I_CANotDisputedDocument 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,
  _NotDisputedDoc.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _NotDisputedDoc.CreationDate AS CreationDate,
  _NotDisputedDoc.CreationTime AS CreationTime,
  _NotDisputedDoc.CAPostingDate AS CAPostingDate,
  _NotDisputedDoc.CAReferenceDocument AS CAReferenceDocument,
  _NotDisputedDoc.ReferenceDocumentType AS ReferenceDocumentType,
  _NotDisputedDoc.CADocumentTypeName AS CADocumentTypeName,
  _NotDisputedDoc.DocumentDate AS DocumentDate,
  _NotDisputedDoc.CAReconciliationKey AS CAReconciliationKey,
  _NotDisputedDoc.CADocumentOriginCodeName AS CADocumentOriginCodeName,
  _NotDisputedDoc.CreatedByUser AS CreatedByUser,
  _CreatedBy.UserDescription AS CreatedByUserName,
  _NotDisputedDoc.CADocumentOriginCode AS CADocumentOriginCode,
  _NotDisputedDoc.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _NotDisputedDoc.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  _NotDisputedDoc.CAClearingReasonName AS CAClearingReasonName,
  cast(_NotDisputedDoc.OpenAmountInTransCrcy as obetw_gfn_kk) AS OpenAmountInTransCrcy,
  _NotDisputedDoc.CAMainTransactionName AS CAMainTransactionName,
  _NotDisputedDoc.CASubTransactionName AS CASubTransactionName,
  _CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _NotDisputedDoc.CAClearingDocumentNumber AS CAClearingDocumentNumber
FROM P_CANotDisputedDocumentSum AS _NotDisputedDoc
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
;

Learn More