I_PT_SAFTPaymentOneTimeCust

DDL: I_PT_SAFTPAYMENTONETIMECUST SQL: IPTSAFTPAYOTC Type: view COMPOSITE
14 Fields 2 Data Sources

SAF-T Payment One Time Customer

I_PT_SAFTPaymentOneTimeCust is a Composite CDS View that provides data about "SAF-T Payment One Time Customer" in SAP S/4HANA. It reads from 2 data sources (I_SAFTAcctgOneTimeCustomer, I_PT_SAFTIsAlternateAccount) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear, DocumentDate.

Data Sources (2)

SourceAliasJoin Type
I_SAFTAcctgOneTimeCustomer Acctg inner
I_PT_SAFTIsAlternateAccount c inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPTSAFTPAYOTC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label SAF-T Payment One Time Customer view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SAFTAcctgOneTimeCustomer CompanyCode Receiver Company Code
KEY AccountingDocument I_SAFTAcctgOneTimeCustomer AccountingDocument Journal Entry
KEY FiscalYear I_SAFTAcctgOneTimeCustomer FiscalYear G/L Fiscal Year
KEY DocumentDate I_SAFTAcctgOneTimeCustomer PostingDate Posting Date for GR
Customer I_SAFTAcctgOneTimeCustomer Customer Sold-to Party
CustomerVATRegistrationendasCustomerNum
CityNameelseDesconhecidoendendasCityName
PostalCodeelse0000000endendasPostalCode
CountryelseDesconhecidoendendasCountry
PhoneNumberendendasPhoneNumber
FaxNumberendendasFaxNumber
EmailAddressendendasEmailAddress
WebsiteURL
IsOneTimeAccount

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_SAFTPaymentOneTimeCust.
-- 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: IPTSAFTPAYOTC

CREATE VIEW I_PT_SAFTPaymentOneTimeCust AS
SELECT
  Acctg.CompanyCode AS CompanyCode,
  Acctg.AccountingDocument AS AccountingDocument,
  Acctg.FiscalYear AS FiscalYear,
  Acctg.PostingDate AS DocumentDate,
  Acctg.Customer AS Customer,
  ( case when Acctg.CustomerVATRegistration is initial or Acctg.CustomerVATRegistration is null then concat(Acctg.Customer, concat('/', '999999990')) else concat(Acctg.Customer, concat('/', Acctg.CustomerVATRegistration)) end ) as CustomerNum AS CustomerVATRegistrationendasCustomerNum,
  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,
  case when Acctg.CustomerVATRegistration is initial or Acctg.CustomerVATRegistration is null then 'Desconhecido' else case when Acctg.PhoneNumber is not null and Acctg.PhoneNumber is not initial then coalesce ( Acctg.PhoneNumber, '' ) end end as PhoneNumber AS PhoneNumberendendasPhoneNumber,
  case when Acctg.CustomerVATRegistration is initial or Acctg.CustomerVATRegistration is null then 'Desconhecido' else case when Acctg.FaxNumber is not null and Acctg.FaxNumber is not initial then Acctg.FaxNumber end end as FaxNumber AS FaxNumberendendasFaxNumber,
  case when Acctg.CustomerVATRegistration is initial or Acctg.CustomerVATRegistration is null then 'Desconhecido' else case when Acctg.EmailAddress is not null and Acctg.EmailAddress is not initial then Acctg.EmailAddress end end as EmailAddress AS EmailAddressendendasEmailAddress,
  ' ' AS WebsiteURL,
  'X' AS IsOneTimeAccount
INNER JOIN I_SAFTAcctgOneTimeCustomer AS Acctg ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTIsAlternateAccount AS c ON /* join condition not captured in parsed metadata */
;

Learn More