I_SAFTSettlementMgmtHeader

DDL: I_SAFTSETTLEMENTMGMTHEADER SQL: ISAFTSMHEADER Type: view COMPOSITE
28 Fields 4 Data Sources

SAF-T Settlement Management Header

I_SAFTSettlementMgmtHeader is a Composite CDS View that provides data about "SAF-T Settlement Management Header" in SAP S/4HANA. It reads from 4 data sources (I_CustomerPaymentTerms, P_SAFT_CancelSettlmtDoc, I_SettlmtMgmtDoc, I_SAFTSettlmtMgmtPaymentTerms) and exposes 28 fields with key fields CompanyCode, SettlmtMgmtDoc.

Data Sources (4)

SourceAliasJoin Type
I_CustomerPaymentTerms CustomerPayTerms left_outer
P_SAFT_CancelSettlmtDoc DocumentFlow left_outer
I_SettlmtMgmtDoc SettlmtMgmtDoc from
I_SAFTSettlmtMgmtPaymentTerms SettlmtMgmtPayTerm left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTSMHEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T Settlement Management Header view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SettlmtMgmtDoc CustSettlmtCompanyCode Cust. Company Code
KEY SettlmtMgmtDoc I_SettlmtMgmtDoc SettlmtMgmtDoc Document Number
SettlmtMgmtDocIsCancelled I_SettlmtMgmtDoc SettlmtMgmtDocIsCancelled Doc. Reversed
PayerParty I_SettlmtMgmtDoc PayerParty Payer
FiscalPeriod I_SettlmtMgmtDoc FiscalPeriod Tax period
CreationTime52asCreationDateTime
LastChangeDate I_SettlmtMgmtDoc LastChangeDate Time Stamp
CreationDate P_SAFT_CancelSettlmtDoc CreationDate Time Stamp
CreationTime P_SAFT_CancelSettlmtDoc CreationTime Time of Change
SettlmtDate I_SettlmtMgmtDoc SettlmtDate Settlement Date
SettlmtDocActivityReason I_SettlmtMgmtDoc SettlmtDocActivityReason Header Document Creation Activity Reason
CreatedByUser I_SettlmtMgmtDoc CreatedByUser User Name
CancelledSettlmtMgmtDoc I_SettlmtMgmtDoc CancelledSettlmtMgmtDoc Reversed Document
CustomerPaymentTerms I_SettlmtMgmtDoc CustomerPaymentTerms Pyt Terms
AuthorizationGroup
SettlmtDocCurrency I_SettlmtMgmtDoc SettlmtDocCurrency Doc. Currency
CustomerTotalTaxAmount I_SettlmtMgmtDoc CustomerTotalTaxAmount Customer Total Tax Amount
CustomerTotalNetAmount I_SettlmtMgmtDoc CustomerTotalNetAmount Extracted Net Value
ExchangeRateDate I_SettlmtMgmtDoc ExchangeRateDate Translatn Date
ExchangeRate I_SettlmtMgmtDoc ExchangeRate Exchange rate
CashDiscount1Days I_SettlmtMgmtDoc CustomerCashDiscount1Days Customer 1st Payment in Days
CashDiscount2Days I_SettlmtMgmtDoc CustomerCashDiscount2Days Customer 2nd Payment in Days
_PayerParty I_SettlmtMgmtDoc _PayerParty
_SettlmtDocActivityReason I_SettlmtMgmtDoc _SettlmtDocActivityReason
_CancelledSettlmtMgmtDoc I_SettlmtMgmtDoc _CancelledSettlmtMgmtDoc
_CustomerPaymentTerms I_SettlmtMgmtDoc _CustomerPaymentTerms
_CustSettlmtCompanyCode I_SettlmtMgmtDoc _CustSettlmtCompanyCode
_SettlmtDocCurrency I_SettlmtMgmtDoc _SettlmtDocCurrency

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_SAFTSettlementMgmtHeader.
-- 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: ISAFTSMHEADER

CREATE VIEW I_SAFTSettlementMgmtHeader AS
SELECT
  SettlmtMgmtDoc.CustSettlmtCompanyCode AS CompanyCode,
  SettlmtMgmtDoc.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  SettlmtMgmtDoc.SettlmtMgmtDocIsCancelled AS SettlmtMgmtDocIsCancelled,
  SettlmtMgmtDoc.PayerParty AS PayerParty,
  SettlmtMgmtDoc.FiscalPeriod AS FiscalPeriod,
  concat(substring(SettlmtMgmtDoc.CreationDate,1,4), concat('-', concat(substring(SettlmtMgmtDoc.CreationDate,5,2), concat('-', concat(substring(SettlmtMgmtDoc.CreationDate,7,2), concat('T', concat(substring(SettlmtMgmtDoc.CreationTime,1,2), concat(':', concat(substring(SettlmtMgmtDoc.CreationTime,3,2), concat(':',substring(SettlmtMgmtDoc.CreationTime,5,2))))))))))) as CreationDateTime AS CreationTime52asCreationDateTime,
  SettlmtMgmtDoc.LastChangeDate AS LastChangeDate,
  DocumentFlow.CreationDate AS CreationDate,
  DocumentFlow.CreationTime AS CreationTime,
  SettlmtMgmtDoc.SettlmtDate AS SettlmtDate,
  SettlmtMgmtDoc.SettlmtDocActivityReason AS SettlmtDocActivityReason,
  SettlmtMgmtDoc.CreatedByUser AS CreatedByUser,
  SettlmtMgmtDoc.CancelledSettlmtMgmtDoc AS CancelledSettlmtMgmtDoc,
  SettlmtMgmtDoc.CustomerPaymentTerms AS CustomerPaymentTerms,
  '' AS AuthorizationGroup,
  SettlmtMgmtDoc.SettlmtDocCurrency AS SettlmtDocCurrency,
  SettlmtMgmtDoc.CustomerTotalTaxAmount AS CustomerTotalTaxAmount,
  SettlmtMgmtDoc.CustomerTotalNetAmount AS CustomerTotalNetAmount,
  SettlmtMgmtDoc.ExchangeRateDate AS ExchangeRateDate,
  SettlmtMgmtDoc.ExchangeRate AS ExchangeRate,
  SettlmtMgmtDoc.CustomerCashDiscount1Days AS CashDiscount1Days,
  SettlmtMgmtDoc.CustomerCashDiscount2Days AS CashDiscount2Days,
  SettlmtMgmtDoc._PayerParty AS _PayerParty,
  SettlmtMgmtDoc._SettlmtDocActivityReason AS _SettlmtDocActivityReason,
  SettlmtMgmtDoc._CancelledSettlmtMgmtDoc AS _CancelledSettlmtMgmtDoc,
  SettlmtMgmtDoc._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SettlmtMgmtDoc._CustSettlmtCompanyCode AS _CustSettlmtCompanyCode,
  SettlmtMgmtDoc._SettlmtDocCurrency AS _SettlmtDocCurrency
FROM I_SettlmtMgmtDoc AS SettlmtMgmtDoc
LEFT OUTER JOIN I_SAFTSettlmtMgmtPaymentTerms AS SettlmtMgmtPayTerm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerPaymentTerms AS CustomerPayTerms ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SAFT_CancelSettlmtDoc AS DocumentFlow ON /* join condition not captured in parsed metadata */
;

Learn More