I_PT_SAFTSelfBillgCustAddrHist

DDL: I_PT_SAFTSELFBILLGCUSTADDRHIST SQL: IPTSAFTSBADRHST Type: view COMPOSITE
11 Fields 1 Data Sources 2 Associations

SAF-T PT Self-Billing CustAddr History

I_PT_SAFTSelfBillgCustAddrHist is a Composite CDS View that provides data about "SAF-T PT Self-Billing CustAddr History" in SAP S/4HANA. It reads from 1 data source (I_PT_SelfBillgCustAddrVers) and exposes 11 fields with key fields FiscalYear, SupplierInvoice, PlantCustomer. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PT_SelfBillgCustAddrVers Version from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_GLAccountInCompanyCode _GLAccountInCompanyCode Version.ReconciliationAccount = _GLAccountInCompanyCode.GLAccount and Version.CompanyCode = _GLAccountInCompanyCode.CompanyCode
[0..1] I_PT_SAFTCustAddrHist _History $projection.PlantCustomer = _History.Customer and $projection.PortugueseCustomerVersion = _History.PortugueseCustomerVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPTSAFTSBADRHST view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label SAF-T PT Self-Billing CustAddr History view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear I_PT_SelfBillgCustAddrVers FiscalYear G/L Fiscal Year
KEY SupplierInvoice I_PT_SelfBillgCustAddrVers SupplierInvoice
KEY PlantCustomer I_PT_SelfBillgCustAddrVers PlantCustomer
CompanyCode I_PT_SelfBillgCustAddrVers CompanyCode Receiver Company Code
Supplier I_PT_SelfBillgCustAddrVers Supplier Supplier
PortugueseCustomerVersion I_PT_SelfBillgCustAddrVers PortugueseCustomerVersion
FirstNameendasPartnerFirstName
LastNameendasPartnerLastName
CountryelsePTendasland1asCountry
_Customer I_PT_SelfBillgCustAddrVers _Customer
_Supplier I_PT_SelfBillgCustAddrVers _Supplier

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_SAFTSelfBillgCustAddrHist.
-- 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: IPTSAFTSBADRHST

CREATE VIEW I_PT_SAFTSelfBillgCustAddrHist AS
SELECT
  Version.FiscalYear AS FiscalYear,
  Version.SupplierInvoice AS SupplierInvoice,
  Version.PlantCustomer AS PlantCustomer,
  Version.CompanyCode AS CompanyCode,
  Version.Supplier AS Supplier,
  Version.PortugueseCustomerVersion AS PortugueseCustomerVersion,
  case when _History.Customer is not initial then min(_History.PartnerFirstName) else min(Version._Customer._ContactPerson.FirstName) end as PartnerFirstName AS FirstNameendasPartnerFirstName,
  case when _History.Customer is not initial then min(_History.PartnerLastName) else min(Version._Customer._ContactPerson.LastName) end as PartnerLastName AS LastNameendasPartnerLastName,
  cast( case when _History.Customer is not initial then _History.Country when PlantCustomer is not initial then Version._Customer._AddressDefaultRepresentation.Country else 'PT' end as land1) as Country AS CountryelsePTendasland1asCountry,
  Version._Customer AS _Customer,
  Version._Supplier AS _Supplier
FROM I_PT_SelfBillgCustAddrVers AS Version
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON Version.ReconciliationAccount = _GLAccountInCompanyCode.GLAccount AND Version.CompanyCode = _GLAccountInCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTCustAddrHist AS _History ON PlantCustomer = _History.Customer AND PortugueseCustomerVersion = _History.PortugueseCustomerVersion  -- association [0..1]
;

Learn More