I_PT_SAFTGenLdgrOneTmeSupplier

DDL: I_PT_SAFTGENLDGRONETMESUPPLIER SQL: ISAFTPTGLOTS Type: view COMPOSITE
17 Fields 5 Data Sources

SAFT PT GLEntries OTS

I_PT_SAFTGenLdgrOneTmeSupplier is a Composite CDS View that provides data about "SAFT PT GLEntries OTS" in SAP S/4HANA. It reads from 5 data sources (I_SAFTGenLedgerOneTimeSupplier, I_PT_SAFTGenericSettings, I_PT_SAFTIsAlternateAccount, P_PT_SAFTSUPMAX, I_GLAccountInCompanyCode) and exposes 17 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger.

Data Sources (5)

SourceAliasJoin Type
I_SAFTGenLedgerOneTimeSupplier a from
I_PT_SAFTGenericSettings b inner
I_PT_SAFTIsAlternateAccount c inner
P_PT_SAFTSUPMAX CM left_outer
I_GLAccountInCompanyCode d inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTPTGLOTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label SAFT PT GLEntries OTS view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SAFTGenLedgerOneTimeSupplier CompanyCode Receiver Company Code
KEY FiscalYear I_SAFTGenLedgerOneTimeSupplier FiscalYear G/L Fiscal Year
KEY AccountingDocument I_SAFTGenLedgerOneTimeSupplier AccountingDocument Journal Entry
KEY Ledger I_SAFTGenLedgerOneTimeSupplier Ledger Ledger
DocumentDate I_SAFTGenLedgerOneTimeSupplier PostingDate Posting Date for GR
VATRegistrationendasSupplier
VATRegistrationendasVATRegistration
CityNameelseDesconhecidoendasCityName
CountryelseDesconhecidoendasCountry
PhoneNumberendasPhoneNumber
FaxNumberendasFaxNumber
EmailAddressendasEmailAddress
WebsiteURLendasWebsiteURL
_CompanyCode _CompanyCode
_JournalEntry _JournalEntry
_Ledger _Ledger
_FiscalYear _FiscalYear

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_SAFTGenLdgrOneTmeSupplier.
-- 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: ISAFTPTGLOTS

CREATE VIEW I_PT_SAFTGenLdgrOneTmeSupplier AS
SELECT
  a.CompanyCode AS CompanyCode,
  a.FiscalYear AS FiscalYear,
  a.AccountingDocument AS AccountingDocument,
  a.Ledger AS Ledger,
  a.PostingDate AS DocumentDate,
  case when a.VATRegistration is initial or a.VATRegistration is null then concat(a.Supplier, concat('/', '999999990')) else concat(a.Supplier, concat('/', a.VATRegistration)) end as Supplier AS VATRegistrationendasSupplier,
  case when a.VATRegistration is initial or a.VATRegistration is null then '999999990' else a.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  case when a.CityName is not initial and a.CityName is not null then a.CityName when CM.CityName is not initial and CM.CityName is not null then CM.CityName else 'Desconhecido' end as CityName AS CityNameelseDesconhecidoendasCityName,
  case when a.Country is not initial or a.Country is not null then a.Country when CM.Country is not initial or CM.Country is not null then CM.Country else 'Desconhecido' end as Country AS CountryelseDesconhecidoendasCountry,
  case when a._DfltAddrRprstn._PhoneNumber[ 1: PhNmbrIsCurrentOverallDefault = 'X' ].InternationalPhoneNumber is not null and a._DfltAddrRprstn._PhoneNumber[ 1: PhNmbrIsCurrentOverallDefault = 'X' ].InternationalPhoneNumber is not initial then a._DfltAddrRprstn._PhoneNumber[ 1: PhNmbrIsCurrentOverallDefault = 'X' ].InternationalPhoneNumber when CM.PhoneNumber is not null and CM.PhoneNumber is not initial then CM.PhoneNumber end as PhoneNumber AS PhoneNumberendasPhoneNumber,
  case when a._DfltAddrRprstn._FaxNumber[ 1: FaxNumberIsCurrentDefault = 'X' ].InternationalFaxNumber is not null and a._DfltAddrRprstn._FaxNumber[ 1: FaxNumberIsCurrentDefault = 'X' ].InternationalFaxNumber is not initial then a._DfltAddrRprstn._FaxNumber[ 1: FaxNumberIsCurrentDefault = 'X' ].InternationalFaxNumber when CM.FaxNumber is not null and CM.FaxNumber is not initial then CM.FaxNumber end as FaxNumber AS FaxNumberendasFaxNumber,
  case when a.EmailAddress is not null and a.EmailAddress is not initial then a.EmailAddress when CM.EmailAddress is not null and CM.EmailAddress is not initial then CM.EmailAddress end as EmailAddress AS EmailAddressendasEmailAddress,
  case when a.SearchURLAddress is not null and a.SearchURLAddress is not initial then cast(lower(a.SearchURLAddress) as ad_uri2) when CM.WebsiteURL is not null and CM.WebsiteURL is not initial then CM.WebsiteURL end as WebsiteURL AS WebsiteURLendasWebsiteURL
FROM I_SAFTGenLedgerOneTimeSupplier AS a
INNER JOIN I_PT_SAFTGenericSettings AS b ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTIsAlternateAccount AS c ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountInCompanyCode AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PT_SAFTSUPMAX AS CM ON /* join condition not captured in parsed metadata */
;

Learn More