I_SAFTSettlementMgmtHeader

DDL: I_SAFTSETTLEMENTMGMTHEADER SQL: ISAFTSMHEADER Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_GEN
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, R_SettlmtMgmtDoc, I_SAFTSettlmtMgmtPaymentTerms) and exposes 28 fields with key fields CompanyCode, SettlmtMgmtDoc. Part of development package GLO_FIN_IS_SAFT_GEN.

Data Sources (4)

SourceAliasJoin Type
I_CustomerPaymentTerms CustomerPayTerms left_outer
P_SAFT_CancelSettlmtDoc DocumentFlow left_outer
R_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 R_SettlmtMgmtDoc IntercompanyCompanyCode
KEY SettlmtMgmtDoc R_SettlmtMgmtDoc SettlmtMgmtDoc Document Number
SettlmtMgmtDocIsCancelled R_SettlmtMgmtDoc SettlmtMgmtDocIsCancelled Doc. Reversed
PayerParty R_SettlmtMgmtDoc PayerParty Payer
FiscalPeriod R_SettlmtMgmtDoc FiscalPeriod Tax period
CreationTime52asCreationDateTime
LastChangeDate R_SettlmtMgmtDoc LastChangeDate Time Stamp
CreationDate P_SAFT_CancelSettlmtDoc CreationDate Time Stamp
CreationTime P_SAFT_CancelSettlmtDoc CreationTime Time of Change
SettlmtDate R_SettlmtMgmtDoc SettlmtDate Settlement Date
SettlmtDocActivityReason R_SettlmtMgmtDoc SettlmtDocActivityReason Header Document Creation Activity Reason
CreatedByUser R_SettlmtMgmtDoc CreatedByUser User Name
CancelledSettlmtMgmtDoc R_SettlmtMgmtDoc CancelledSettlmtMgmtDoc
CustomerPaymentTerms R_SettlmtMgmtDoc CustomerPaymentTerms Pyt Terms
AuthorizationGroup
SettlmtDocCurrency R_SettlmtMgmtDoc SettlmtDocCurrency Doc. Currency
CustomerTotalTaxAmount R_SettlmtMgmtDoc CustomerTotalTaxAmount Customer Total Tax Amount
CustomerTotalNetAmount R_SettlmtMgmtDoc CustomerTotalNetAmount Extracted Net Value
ExchangeRateDate R_SettlmtMgmtDoc ExchangeRateDate Translatn Date
ExchangeRate R_SettlmtMgmtDoc ExchangeRate Exchange rate
CashDiscount1Days R_SettlmtMgmtDoc CustomerCashDiscount1Days Customer 1st Payment in Days
CashDiscount2Days R_SettlmtMgmtDoc CustomerCashDiscount2Days Customer 2nd Payment in Days
_PayerParty R_SettlmtMgmtDoc _PayerParty
_SettlmtDocActivityReason R_SettlmtMgmtDoc _SettlmtDocActivityReason
_CancelledSettlmtMgmtDoc R_SettlmtMgmtDoc _CancelledSettlmtMgmtDoc
_CustomerPaymentTerms R_SettlmtMgmtDoc _CustomerPaymentTerms
_IntercompanyCompanyCode R_SettlmtMgmtDoc _IntercompanyCompanyCode
_SettlmtDocCurrency R_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.IntercompanyCompanyCode 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._IntercompanyCompanyCode AS _IntercompanyCompanyCode,
  SettlmtMgmtDoc._SettlmtDocCurrency AS _SettlmtDocCurrency
FROM R_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