I_PT_SAFTSettlementInfo

DDL: I_PT_SAFTSETTLEMENTINFO Type: view_entity COMPOSITE
15 Fields 2 Data Sources 1 Associations

Settlement Data Collector

I_PT_SAFTSettlementInfo is a Composite CDS View that provides data about "Settlement Data Collector" in SAP S/4HANA. It reads from 2 data sources (I_PT_SettlmtDocsDgtlSgntr, I_SAFTSettlementMgmtHeader) and exposes 15 fields with key fields PT_SAFTDocumentNumber, CompanyCode, FiscalYear, PortugueseInvoiceDate. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PT_SettlmtDocsDgtlSgntr DigitalSignature inner
I_SAFTSettlementMgmtHeader SettlmtMgmtHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode DigitalSignature.CompanyCode = _CompanyCode.CompanyCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Settlement Data Collector view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PT_SAFTDocumentNumber
KEY CompanyCode I_PT_SettlmtDocsDgtlSgntr CompanyCode Receiver Company Code
KEY FiscalYear
KEY PortugueseInvoiceDate I_PT_SettlmtDocsDgtlSgntr InvoiceDate Run On
BillingDocument I_SAFTSettlementMgmtHeader SettlmtMgmtDoc Document Number
TransactionCurrency I_SAFTSettlementMgmtHeader SettlmtDocCurrency Doc. Currency
CompanyCodeCurrency _CompanyCode Currency Valuation Crcy
CustomerPaymentTerms I_SAFTSettlementMgmtHeader CustomerPaymentTerms Pyt Terms
CashDiscount1DueDate
CashDiscount2DueDate
CalcTxAmtCoCodeCrcyRatio
CalcTxAmtTransCrcyRatio
CashDiscountAmtInCoCodeCrcy Cash Discount Amount Currency
CashDiscountAmtInTransacCrcy
CustomerPaymentTermsName I_SAFTSettlementMgmtHeader CustomerPaymentTermsName

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_PT_SAFTSettlementInfo.
-- 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.

CREATE VIEW I_PT_SAFTSettlementInfo AS
SELECT
  cast(DigitalSignature.SettlementDocInvoiceNumber as abap.char(60)) AS PT_SAFTDocumentNumber,
  DigitalSignature.CompanyCode AS CompanyCode,
  cast( '' as abap.numc(4) ) AS FiscalYear,
  DigitalSignature.InvoiceDate AS PortugueseInvoiceDate,
  SettlmtMgmtHeader.SettlmtMgmtDoc AS BillingDocument,
  SettlmtMgmtHeader.SettlmtDocCurrency AS TransactionCurrency,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  SettlmtMgmtHeader.CustomerPaymentTerms AS CustomerPaymentTerms,
  dats_add_days(SettlmtMgmtHeader.SettlmtDate, cast( ceil(SettlmtMgmtHeader.CashDiscount1Days) as abap.int1 ),'NULL') AS CashDiscount1DueDate,
  dats_add_days(SettlmtMgmtHeader.SettlmtDate, cast( ceil(SettlmtMgmtHeader.CashDiscount2Days) as abap.int1 ),'NULL') AS CashDiscount2DueDate,
  cast( 0 as abap.fltp ) AS CalcTxAmtCoCodeCrcyRatio,
  cast( 0 as abap.fltp ) AS CalcTxAmtTransCrcyRatio,
  cast(0 as abap.curr(23,2)) AS CashDiscountAmtInCoCodeCrcy,
  cast(0 as abap.curr(23,2)) AS CashDiscountAmtInTransacCrcy,
  SettlmtMgmtHeader.CustomerPaymentTermsName AS CustomerPaymentTermsName
FROM I_SAFTSettlementMgmtHeader AS SettlmtMgmtHeader
INNER JOIN I_PT_SettlmtDocsDgtlSgntr AS DigitalSignature ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON DigitalSignature.CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More