C_PT_SAFTHeader

DDL: C_PT_SAFTHEADER SQL: CSAFTHEADER Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PT
19 Fields 1 Data Sources

SAF-T PT Header

C_PT_SAFTHeader is a Consumption CDS View that provides data about "SAF-T PT Header" in SAP S/4HANA. It reads from 1 data source (I_SAFTHeader) and exposes 19 fields with key fields CompanyCode, StartDate, EndDate, FiscalYear. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (1)

SourceAliasJoin Type
I_SAFTHeader Head from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSAFTHEADER view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
EndUserText.label SAF-T PT Header view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SAFTHeader CompanyCode Receiver Company Code
KEY StartDate I_SAFTHeader StartDate Valid From
KEY EndDate I_SAFTHeader EndDate Term to
KEY FiscalYear I_SAFTHeader FiscalYear G/L Fiscal Year
VATRegistration39endasVATRegistration
CompanyCodeNameendendasCompanyName
HouseNumber1endasCompanyCodeAddress
CityNameendendasCityName
PostalCodeendasPostalCode
CountryendasCountry
EmbeddedSwVersionDescription Vers EmbeddedSwVersionStatusDesc
AddressID
Person
PhoneNumber Phone InternationalPhoneNumber Telephone no.
FaxNumber Fax InternationalFaxNumber Fax Number
EmailAddress email EmailAddress E-Mail Address
URLFieldLength
WebsiteURL
TaxonomyReferenceType GenSet TaxonomyReferenceType

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 C_PT_SAFTHeader.
-- 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: CSAFTHEADER

CREATE VIEW C_PT_SAFTHeader AS
SELECT
  Head.CompanyCode AS CompanyCode,
  Head.StartDate AS StartDate,
  Head.EndDate AS EndDate,
  Head.FiscalYear AS FiscalYear,
  case when RITA.CompanyCode is not initial then substring(RITA.VATRegistration, 3, 9) else substring(Head._CompanyCode.VATRegistration, 3, 9) end as VATRegistration AS VATRegistration39endasVATRegistration,
  case when RITA.CompanyCode is not initial then RITA.CompanyCodeName else case when Head._CompanyCode._OrgAddressDefaultRprstn.AddresseeName1 is not initial then concat_with_space (Head._CompanyCode._OrgAddressDefaultRprstn.AddresseeName1, Head._CompanyCode._OrgAddressDefaultRprstn.AddresseeName2, 1) else Head._CompanyCode.CompanyCodeName end end as CompanyName AS CompanyCodeNameendendasCompanyName,
  case when RITA.CompanyCode is not initial then RITA.CompanyCodeAddress else concat_with_space (Head._CompanyCode._OrgAddressDefaultRprstn.StreetName, Head._CompanyCode._OrgAddressDefaultRprstn.HouseNumber, 1) end as CompanyCodeAddress AS HouseNumber1endasCompanyCodeAddress,
  case when RITA.CompanyCode is not initial then RITA.CityName else case when Head._CompanyCode.CityName is not initial then Head._CompanyCode.CityName else Head._CompanyCode._OrgAddressDefaultRprstn.CityName end end as CityName AS CityNameendendasCityName,
  case when RITA.CompanyCode is not initial then RITA.PostalCode else Head._CompanyCode._OrgAddressDefaultRprstn.PostalCode end as PostalCode AS PostalCodeendasPostalCode,
  case when RITA.CompanyCode is not initial then RITA.Country else Head._CompanyCode._OrgAddressDefaultRprstn.Country end as Country AS CountryendasCountry,
  Vers.EmbeddedSwVersionStatusDesc AS EmbeddedSwVersionDescription,
  Head._CompanyCode.AddressID AS AddressID,
  cast( '' as ad_persnum ) AS Person,
  Phone.InternationalPhoneNumber AS PhoneNumber,
  Fax.InternationalFaxNumber AS FaxNumber,
  email.EmailAddress AS EmailAddress,
  ' ' AS URLFieldLength,
  ' ' AS WebsiteURL,
  GenSet.TaxonomyReferenceType AS TaxonomyReferenceType
FROM I_SAFTHeader AS Head
;

Learn More