I_CAOverdueDocItemAtDate

DDL: I_CAOVERDUEDOCITEMATDATE Type: view_entity COMPOSITE
29 Fields 1 Data Sources 2 Associations

FICA Overdue Document Items at date

I_CAOverdueDocItemAtDate is a Composite CDS View that provides data about "FICA Overdue Document Items at date" in SAP S/4HANA. It reads from 1 data source (I_CAOverdueItemsAtDate) and exposes 29 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CAOverdueItemsAtDate I_CAOverdueItemsAtDate from

Parameters (1)

NameTypeDefault
P_KeyDate fipl_keydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CADocument _header item.CADocumentNumber = _header.CADocumentNumber
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label FICA Overdue Document Items at date view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber item CADocumentNumber Document Number
KEY CARepetitionItemNumber item CARepetitionItemNumber Repetition Item
KEY CABPItemNumber item CABPItemNumber Item
KEY CASubItemNumber item CASubItemNumber Subitem
IsCleared
CAClearingDocumentNumber item CAClearingDocumentNumber Clearing Doc.
CADocumentType item CADocumentType Document Type
BusinessPartner item BusinessPartner Issuing Authority
BusinessPartnerFullName
CAReconciliationAccount item CAReconciliationAccount G/L Account
CAMainTransaction item CAMainTransaction Main Trans.
CASubTransaction item CASubTransaction Subtransaction
TaxCode item TaxCode Tax Code
CABPItemText item CABPItemText Text
BusinessArea item BusinessArea Business Area
CAReferenceDocument item CAReferenceDocument Reference
DocumentDate item DocumentDate Journal Entry Date
CAPostingDate item CAPostingDate Posting Date
CANetDueDate item CANetDueDate Net Due Date
CAClearingDate item CAClearingDate Clearing
CAAmountInLocalCurrency item CAAmountInLocalCurrency Local Crcy Amt
CAAmountInTransactionCurrency item CAAmountInTransactionCurrency Amount
TransactionCurrency item TransactionCurrency Transaction Currency
CompanyCodeCurrency item CompanyCodeCurrency Local Currency
CompanyCode item CompanyCode Receiver Company Code
NetDueArrearsDaysInteger
OriginalReferenceDocument _header OriginalReferenceDocument Reference Key
CAReversalDocumentNumber _header CAReversalDocumentNumber Revers.document
TaxReportingDate _header TaxReportingDate Tax Reporting Date

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_CAOverdueDocItemAtDate.
-- 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.
-- Parameters: P_KeyDate : fipl_keydate

CREATE VIEW I_CAOverdueDocItemAtDate AS
SELECT
  item.CADocumentNumber AS CADocumentNumber,
  item.CARepetitionItemNumber AS CARepetitionItemNumber,
  item.CABPItemNumber AS CABPItemNumber,
  item.CASubItemNumber AS CASubItemNumber,
  cast( item.IsCleared as fkk_id_cleared ) AS IsCleared,
  item.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  item.CADocumentType AS CADocumentType,
  item.BusinessPartner AS BusinessPartner,
  cast( _BusinessPartner.BusinessPartnerFullName as fkk_id_bpnm ) AS BusinessPartnerFullName,
  item.CAReconciliationAccount AS CAReconciliationAccount,
  item.CAMainTransaction AS CAMainTransaction,
  item.CASubTransaction AS CASubTransaction,
  item.TaxCode AS TaxCode,
  item.CABPItemText AS CABPItemText,
  item.BusinessArea AS BusinessArea,
  item.CAReferenceDocument AS CAReferenceDocument,
  item.DocumentDate AS DocumentDate,
  item.CAPostingDate AS CAPostingDate,
  item.CANetDueDate AS CANetDueDate,
  item.CAClearingDate AS CAClearingDate,
  item.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  item.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  item.TransactionCurrency AS TransactionCurrency,
  item.CompanyCodeCurrency AS CompanyCodeCurrency,
  item.CompanyCode AS CompanyCode,
  cast( item.NetDueArrearsDaysInteger as fkk_id_arrdays ) AS NetDueArrearsDaysInteger,
  _header.OriginalReferenceDocument AS OriginalReferenceDocument,
  _header.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _header.TaxReportingDate AS TaxReportingDate
FROM I_CAOverdueItemsAtDate
LEFT OUTER JOIN I_CADocument AS _header ON item.CADocumentNumber = _header.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
;

Learn More