C_PL_CAExcessDelayAcctDataC

DDL: C_PL_CAEXCESSDELAYACCTDATAC Type: view_entity CONSUMPTION Package: FKK_ID_PL_REP
26 Fields 1 Data Sources 2 Associations

FICA Data for Excess Delay - Cube

C_PL_CAExcessDelayAcctDataC is a Consumption CDS View (Cube) that provides data about "FICA Data for Excess Delay - Cube" in SAP S/4HANA. It reads from 1 data source (I_CAOverdueDocItemAtDate) and exposes 26 fields with key fields CADocumentNumber, CABPItemNumber, CARepetitionItemNumber, CASubItemNumber, StatryRptgEntity. It has 2 associations to related views. Part of development package FKK_ID_PL_REP.

Data Sources (1)

SourceAliasJoin Type
I_CAOverdueDocItemAtDate I_CAOverdueDocItemAtDate from

Parameters (1)

NameTypeDefault
P_KeyDate fipl_keydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_BusinessPartnerDefaultAddr _DefaultAddress $projection.BusinessPartner = _DefaultAddress.BusinessPartner and ( _DefaultAddress.ValidityStartDate is null or _DefaultAddress.ValidityStartDate <= $parameters.P_KeyDate ) and( _DefaultAddress.ValidityEndDate is null or _DefaultAddress.ValidityEndDate > $parameters.P_KeyDate )
[0..1] I_CAStRpDocItmJournalLog _log operational.CADocumentNumber = _log.CADocumentNumber and operational.CARepetitionItemNumber = _log.CARepetitionItemNumber and operational.CASubItemNumber = _log.CASubItemNumber and operational.CABPItemNumber = _log.CABPItemNumber

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Analytics.internalName #LOCAL view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
EndUserText.label FICA Data for Excess Delay - Cube view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber operational CADocumentNumber Document Number
KEY CABPItemNumber operational CABPItemNumber Item
KEY CARepetitionItemNumber operational CARepetitionItemNumber Repetition Item
KEY CASubItemNumber operational CASubItemNumber Subitem
KEY StatryRptgEntity _log StatryRptgEntity Reporting Entity
KEY StatryRptCategory _log StatryRptCategory Report ID
KEY StatryRptRunID _log StatryRptRunID Report Run ID
KEY BusinessPartnerAddressID _DefaultAddress BusinessPartnerAddressID
CAClearingDocumentNumber operational CAClearingDocumentNumber Clearing Doc.
CADocumentType operational CADocumentType Document Type
CompanyCode operational CompanyCode Receiver Company Code
CAMainTransaction operational CAMainTransaction Main Trans.
CASubTransaction operational CASubTransaction Subtransaction
CAAmountInLocalCurrency operational CAAmountInLocalCurrency Local Crcy Amt
CompanyCodeCurrency operational CompanyCodeCurrency Local Currency
BusinessPartner operational BusinessPartner Issuing Authority
CAAmountInTransactionCurrency operational CAAmountInTransactionCurrency Amount
TransactionCurrency operational TransactionCurrency Transaction Currency
BusinessPartnerFullName operational BusinessPartnerFullName Broker Name
DocumentDate operational DocumentDate Journal Entry Date
CAPostingDate operational CAPostingDate Posting Date
CANetDueDate operational CANetDueDate Net Due Date
CAClearingDate operational CAClearingDate Clearing
CAReferenceDocument operational CAReferenceDocument Reference
CABPItemText operational CABPItemText Text
Country

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_PL_CAExcessDelayAcctDataC.
-- 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 C_PL_CAExcessDelayAcctDataC AS
SELECT
  operational.CADocumentNumber AS CADocumentNumber,
  operational.CABPItemNumber AS CABPItemNumber,
  operational.CARepetitionItemNumber AS CARepetitionItemNumber,
  operational.CASubItemNumber AS CASubItemNumber,
  _log.StatryRptgEntity AS StatryRptgEntity,
  _log.StatryRptCategory AS StatryRptCategory,
  _log.StatryRptRunID AS StatryRptRunID,
  _DefaultAddress.BusinessPartnerAddressID AS BusinessPartnerAddressID,
  operational.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  operational.CADocumentType AS CADocumentType,
  operational.CompanyCode AS CompanyCode,
  operational.CAMainTransaction AS CAMainTransaction,
  operational.CASubTransaction AS CASubTransaction,
  operational.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  operational.CompanyCodeCurrency AS CompanyCodeCurrency,
  operational.BusinessPartner AS BusinessPartner,
  operational.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  operational.TransactionCurrency AS TransactionCurrency,
  operational.BusinessPartnerFullName AS BusinessPartnerFullName,
  operational.DocumentDate AS DocumentDate,
  operational.CAPostingDate AS CAPostingDate,
  operational.CANetDueDate AS CANetDueDate,
  operational.CAClearingDate AS CAClearingDate,
  operational.CAReferenceDocument AS CAReferenceDocument,
  operational.CABPItemText AS CABPItemText,
  _DefaultAddress._AddressDefaultRepresentation.Country AS Country
FROM I_CAOverdueDocItemAtDate
LEFT OUTER JOIN P_BusinessPartnerDefaultAddr AS _DefaultAddress ON BusinessPartner = _DefaultAddress.BusinessPartner AND ( _DefaultAddress.ValidityStartDate is null OR _DefaultAddress.ValidityStartDate <= $parameters.P_KeyDate ) AND( _DefaultAddress.ValidityEndDate is null OR _DefaultAddress.ValidityEndDate > $parameters.P_KeyDate )  -- association [1..1]
LEFT OUTER JOIN I_CAStRpDocItmJournalLog AS _log ON operational.CADocumentNumber = _log.CADocumentNumber AND operational.CARepetitionItemNumber = _log.CARepetitionItemNumber AND operational.CASubItemNumber = _log.CASubItemNumber AND operational.CABPItemNumber = _log.CABPItemNumber  -- association [0..1]
;

Learn More