I_PT_SAFTIntgtdCustomerLog

DDL: I_PT_SAFTINTGTDCUSTOMERLOG Type: view_entity BASIC Package: GLO_FIN_IS_SAFT_PT
29 Fields 1 Data Sources

Customer Log for PT SAFT Integrated

I_PT_SAFTIntgtdCustomerLog is a Basic CDS View that provides data about "Customer Log for PT SAFT Integrated" in SAP S/4HANA. It reads from 1 data source (saft_pta_icuslog) and exposes 29 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, SAFTModuleForProcDetn, Ledger. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (1)

SourceAliasJoin Type
saft_pta_icuslog saft_pta_icuslog from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Customer Log for PT SAFT Integrated view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY SAFTModuleForProcDetn saftmodule
KEY Ledger ledger Ledger
KEY ChartOfAccounts chartofaccounts Node Class
KEY CompanyCode companycode Receiver Company Code
KEY BusinessPartnerCustomer businesspartnercustomer CHAR35
KEY GLAccount glaccount General Ledger
KEY PT_SAFTDocumentNumber pt_saftdocumentnumber
KEY FiscalYear G/L Fiscal Year
KEY PortugueseInvoiceDate portugueseinvoicedate Date
KEY AccountingDocument accountingdocument Journal Entry
PT_SAFTReconciliationAccount
CustomerVATRegistration customervatregistration VAT Registration No.
CITClassificationCodeDesc citclassificationcodedesc Clsfcn Code Name
IsOneTimeAccount isonetimeaccount One-time acct
Customer customer Sold-to Party
CompanyName companyname Text
CompanyContactPersonFullName companycontactpersonfullname Full Name
StreetName streetname Text
CityName cityname Name
PostalCode Postal Code
PT_SAFTCountryText
PhoneNumber Telephone no.
FaxNumber Fax Number
EmailAddress emailaddress E-Mail Address
WebsiteURL websiteurl URI
BillingDocument billingdocument SD Document

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_SAFTIntgtdCustomerLog.
-- 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.

CREATE VIEW I_PT_SAFTIntgtdCustomerLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  saftmodule AS SAFTModuleForProcDetn,
  Ledger,
  ChartOfAccounts,
  CompanyCode,
  BusinessPartnerCustomer,
  GLAccount,
  PT_SAFTDocumentNumber,
  cast(fiscalyear as fis_gjahr_no_conv) AS FiscalYear,
  PortugueseInvoiceDate,
  AccountingDocument,
  cast(pt_saftreconciliationaccount as pt_saft_glaccount) AS PT_SAFTReconciliationAccount,
  CustomerVATRegistration,
  CITClassificationCodeDesc,
  IsOneTimeAccount,
  Customer,
  CompanyName,
  CompanyContactPersonFullName,
  StreetName,
  CityName,
  cast(postalcode as ad_pstcd1) AS PostalCode,
  cast(pt_saftcountrytext as pt_saft_country) AS PT_SAFTCountryText,
  cast(phonenumber as ad_tlnmbr) AS PhoneNumber,
  cast(faxnumber as telfx) AS FaxNumber,
  EmailAddress,
  WebsiteURL,
  BillingDocument
FROM saft_pta_icuslog
;

Learn More