I_PT_SAFTAcctgOneTimeCustomer

DDL: I_PT_SAFTACCTGONETIMECUSTOMER SQL: IPTSAFTACCOTC Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_PT
12 Fields 3 Data Sources

SAF-T PT Accounting One Time Customer

I_PT_SAFTAcctgOneTimeCustomer is a Composite CDS View that provides data about "SAF-T PT Accounting One Time Customer" in SAP S/4HANA. It reads from 3 data sources (I_PT_SAFTIsAlternateAccount, I_GLAccountInCompanyCode, I_PT_AcctgDocDgtlSgntr) and exposes 12 fields with key fields CompanyCode, PortugueseInvoiceNumber. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (3)

SourceAliasJoin Type
I_PT_SAFTIsAlternateAccount c inner
I_GLAccountInCompanyCode f inner
I_PT_AcctgDocDgtlSgntr Sig inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPTSAFTACCOTC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY 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 SAF-T PT Accounting One Time Customer view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_PT_AcctgDocDgtlSgntr CompanyCode Receiver Company Code
KEY PortugueseInvoiceNumber I_PT_AcctgDocDgtlSgntr PortugueseInvoiceNumber
AccountingDocument Acctg AccountingDocument Journal Entry
FiscalYear Acctg FiscalYear G/L Fiscal Year
DocumentDate I_PT_AcctgDocDgtlSgntr PortugueseInvoiceDate Date
PortugueseCustomerWithVersion
Customer Acctg Customer Sold-to Party
CityNameelseDesconhecidoendendasCityName
PostalCodeelse0000000endendasPostalCode
CountryelseDesconhecidoendendasCountry
WebsiteURL
_Customer Acctg _Customer

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_SAFTAcctgOneTimeCustomer.
-- 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: IPTSAFTACCOTC

CREATE VIEW I_PT_SAFTAcctgOneTimeCustomer AS
SELECT
  Sig.CompanyCode AS CompanyCode,
  Sig.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  Acctg.AccountingDocument AS AccountingDocument,
  Acctg.FiscalYear AS FiscalYear,
  Sig.PortugueseInvoiceDate AS DocumentDate,
  cast(Acctg.Customer as abap.char(15)) AS PortugueseCustomerWithVersion,
  Acctg.Customer AS Customer,
  case when Acctg.CustomerVATRegistration is initial or Acctg.CustomerVATRegistration is null then 'Desconhecido' else case when Acctg.CityName is not initial and Acctg.CityName is not null then Acctg.CityName else 'Desconhecido' end end as CityName AS CityNameelseDesconhecidoendendasCityName,
  case when Acctg.CustomerVATRegistration is initial or Acctg.CustomerVATRegistration is null then '0000-000' else case when Acctg.PostalCode is not initial and Acctg.PostalCode is not null then Acctg.PostalCode else '0000-000' end end as PostalCode AS PostalCodeelse0000000endendasPostalCode,
  case when Acctg.CustomerVATRegistration is initial or Acctg.CustomerVATRegistration is null then 'Desconhecido' else case when Acctg.Country is not initial and Acctg.Country is not null then Acctg.Country else 'Desconhecido' end end as Country AS CountryelseDesconhecidoendendasCountry,
  'Desconhecido' AS WebsiteURL,
  Acctg._Customer AS _Customer
INNER JOIN I_PT_AcctgDocDgtlSgntr AS Sig 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 f ON /* join condition not captured in parsed metadata */
;

Learn More