I_CANotDisputedClearedItem

DDL: I_CANOTDISPUTEDCLEAREDITEM SQL: INODSPUTDCLRDITM Type: view COMPOSITE
43 Fields 2 Data Sources

Not Disputed Cleared Items

I_CANotDisputedClearedItem is a Composite CDS View that provides data about "Not Disputed Cleared Items" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentHeader, I_CADocumentBPItemPhysical) and exposes 43 fields with key fields CADocumentNumber, CABPItemNumber, CARepetitionItemNumber, CASubItemNumber.

Data Sources (2)

SourceAliasJoin Type
I_CADocumentHeader _CADocumentHeader inner
I_CADocumentBPItemPhysical _Item from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName INODSPUTDCLRDITM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Not Disputed Cleared Items view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItemPhysical CADocumentNumber Document Number
KEY CABPItemNumber
KEY CARepetitionItemNumber I_CADocumentBPItemPhysical CARepetitionItemNumber Repetition Item
KEY CASubItemNumber I_CADocumentBPItemPhysical CASubItemNumber Subitem
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
TransactionCurrency I_CADocumentBPItemPhysical TransactionCurrency Transaction Currency
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction Subtransaction
CANetDueDate CANetDueDate Net Due Date
CADeferralDate CADeferralDate Deferral To
CAClearingDate CAClearingDate Clearing
CAClearingReason CAClearingReason Clearing Reason
CAClearingReasonName
OpenAmountInTransCrcy
CAMainTransactionName
CASubTransactionName
BusinessPartner I_CADocumentBPItemPhysical BusinessPartner Issuing Authority
ContractAccount I_CADocumentBPItemPhysical ContractAccount Contract Acct
CAContract I_CADocumentBPItemPhysical CAContract Contract
CASubApplication I_CADocumentBPItemPhysical CASubApplication Subapplication
CompanyCode I_CADocumentBPItemPhysical CompanyCode Receiver Company Code
CreationDate
CreationTime
CADocumentOriginCodeName I_CADocumentHeader CADocumentOriginCodeName
CreatedByUser I_CADocumentHeader CreatedByUser User Name
CADocumentOriginCode I_CADocumentHeader CADocumentOriginCode Document Origin
DocumentDate I_CADocumentHeader DocumentDate Journal Entry Date
CAPostingDate I_CADocumentHeader CAPostingDate Posting Date
CAReferenceDocument I_CADocumentHeader CAReferenceDocument Reference
CADocumentTypeName
CAReconciliationKey I_CADocumentHeader CAReconciliationKey Reconcil. Key
CAReversalDocumentNumber I_CADocumentHeader CAReversalDocumentNumber Revers.document
CAReversedDocumentNumber I_CADocumentHeader CAReversedDocumentNumber Rev. Doc. For
CAApplicationArea I_CADocumentBPItemPhysical CAApplicationArea ApplicationArea
_BusinessPartner _BusinessPartner
_CAPartner _CAPartner
_Currency _Currency
_DocOriginCode _DocOriginCode
_CompCode _CompCode
_CAHeader _CAHeader
_ClearingReason _ClearingReason
_MainTransaction _MainTransaction
_DocHeader _DocHeader

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_CANotDisputedClearedItem.
-- 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: INODSPUTDCLRDITM

CREATE VIEW I_CANotDisputedClearedItem AS
SELECT
  _Item.CADocumentNumber AS CADocumentNumber,
  cast(LTRIM (_Item.CABPItemNumber, '0') as opupk_kk ) AS CABPItemNumber,
  _Item.CARepetitionItemNumber AS CARepetitionItemNumber,
  _Item.CASubItemNumber AS CASubItemNumber,
  CAAmountInTransactionCurrency,
  _Item.TransactionCurrency AS TransactionCurrency,
  CAMainTransaction,
  cast(CASubTransaction as tvorg_gfn_kk) AS CASubTransaction,
  CANetDueDate,
  CADeferralDate,
  CAClearingDate,
  CAClearingReason,
  cast( _ClearingReason._Text[1: Language=$session.system_language].CAClearingReasonName as augrd_gfn_kk) AS CAClearingReasonName,
  cast(0 as obetw_gfn_kk ) AS OpenAmountInTransCrcy,
  _MainTransaction._Text[1:Language = $session.system_language].CAMainTransactionName AS CAMainTransactionName,
  _SubTransaction._Text[1:Language = $session.system_language].CASubTransactionName AS CASubTransactionName,
  _Item.BusinessPartner AS BusinessPartner,
  _Item.ContractAccount AS ContractAccount,
  _Item.CAContract AS CAContract,
  _Item.CASubApplication AS CASubApplication,
  _Item.CompanyCode AS CompanyCode,
  cast(_CADocumentHeader.CreationDate as erdat) AS CreationDate,
  cast(_CADocumentHeader.CreationTime as crtime_kk) AS CreationTime,
  _CADocumentHeader.CADocumentOriginCodeName AS CADocumentOriginCodeName,
  _CADocumentHeader.CreatedByUser AS CreatedByUser,
  _CADocumentHeader.CADocumentOriginCode AS CADocumentOriginCode,
  _CADocumentHeader.DocumentDate AS DocumentDate,
  _CADocumentHeader.CAPostingDate AS CAPostingDate,
  _CADocumentHeader.CAReferenceDocument AS CAReferenceDocument,
  _CADocumentHeader._DocType._Text[1:Language = $session.system_language].CADocumentTypeName AS CADocumentTypeName,
  _CADocumentHeader.CAReconciliationKey AS CAReconciliationKey,
  _CADocumentHeader.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _CADocumentHeader.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  _Item.CAApplicationArea AS CAApplicationArea
FROM I_CADocumentBPItemPhysical AS _Item
INNER JOIN I_CADocumentHeader AS _CADocumentHeader ON /* join condition not captured in parsed metadata */
;

Learn More