I_PT_SeriesValidationCode

DDL: I_PT_SERIESVALIDATIONCODE Type: view_entity COMPOSITE Package: GLO-PT-ATCUD
29 Fields 1 Data Sources 5 Associations

Series Validation code for Portugal

I_PT_SeriesValidationCode is a Composite CDS View that provides data about "Series Validation code for Portugal" in SAP S/4HANA. It reads from 1 data source (P_PT_SeriesCollection) and exposes 29 fields with key fields VATRegistration, PT_SeriesIdentifier, PT_SeriesTypeCode, PT_SeriesDocumentType. It has 5 associations to related views. Part of development package GLO-PT-ATCUD.

Data Sources (1)

SourceAliasJoin Type
P_PT_SeriesCollection P_PT_SeriesCollection from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_PT_SeriesValidationCodes _SersValdtnCode $projection.VATRegistration = _SersValdtnCode.VATRegistration and $projection.PT_SeriesIdentifier = _SersValdtnCode.PT_SeriesIdentifier and $projection.PT_SeriesDocumentType = _SersValdtnCode.PT_SeriesDocumentType and $projection.PT_SeriesTypeCode = _SersValdtnCode.PT_SeriesTypeCode
[1..1] P_PT_DgtlSgntrCertification _PTCert _PTCert.PT_CertifiedProduct = 'S4HANA'
[0..1] I_PT_SeriesDocTypeText _PTDocType $projection.PT_SeriesDocumentType = _PTDocType.PT_SeriesDocumentType
[0..1] I_PT_SeriesTypeCodeText _PTSersTypCd $projection.PT_SeriesTypeCode = _PTSersTypCd.PT_SeriesTypeCode
[0..1] I_PT_SeriesProcgCodeText _PTSersProcCd $projection.PT_SeriesProcgCode = _PTSersProcCd.PT_SeriesProcgCode

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Series Validation code for Portugal view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY VATRegistration VATRegistration VAT Number
KEY PT_SeriesIdentifier PT_SeriesIdentifier Number Range Series
KEY PT_SeriesTypeCode PT_SeriesTypeCode Series Type Code
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess
PT_SeriesStartNumber
PT_SeriesLastNumber
PortugueseSgntrCertificate _PTCert PortugueseSgntrCertificate Certif. ID
PT_SeriesValdtnCode _SersValdtnCode PT_SeriesValdtnCode
PT_SeriesStatusendasPT_SeriesStatus
PT_SeriesRegistrationDate _SersValdtnCode PT_SeriesRegistrationDate
PT_SeriesStatusChangeDateTime _SersValdtnCode PT_SeriesStatusChangeDateTime
PT_VATRegistrationCompanyCode
Supplier
PT_SupplierCategory
CompanyCode Requesting Company Code
PT_SeriesCanclnIsDeclared _SersValdtnCode PT_SeriesCanclnIsDeclared
PT_SeriesCanclnReasonCode _SersValdtnCode PT_SeriesCanclnReasonCode
PT_SersFinishJustificationText _SersValdtnCode PT_SersFinishJustificationText
LastChangeDateTime _SersValdtnCode LastChangeDateTime Timestamp
PortugueseDigitalSignatureDate _SersValdtnCode PortugueseDigitalSignatureDate
PT_SeriesDocTypeText _PTDocType PT_SeriesDocTypeText
_PTSersProcCd _PTSersProcCd
PT_SeriesTypeCodeText _PTSersTypCd PT_SeriesTypeCodeText
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable

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_SeriesValidationCode.
-- 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_SeriesValidationCode AS
SELECT
  VATRegistration,
  PT_SeriesIdentifier,
  PT_SeriesTypeCode,
  PT_SeriesDocumentType,
  coalesce(_SersValdtnCode.PT_SeriesNumberRangeObject, _SeriesCollection.PT_SeriesNumberRangeObject) AS PT_SeriesNumberRangeObject,
  coalesce(_SersValdtnCode. PT_SeriesNumberRangeSubObject, _SeriesCollection. PT_SeriesNumberRangeSubObject) AS PT_SeriesNumberRangeSubObject,
  coalesce(_SersValdtnCode.PT_SeriesNumberRangeToYear, _SeriesCollection.PT_SeriesNumberRangeToYear) AS PT_SeriesNumberRangeToYear,
  coalesce(_SersValdtnCode.PT_SeriesNumberRangeInterval, _SeriesCollection.PT_SeriesNumberRangeInterval) AS PT_SeriesNumberRangeInterval,
  coalesce(_SersValdtnCode.PT_SeriesBusinessProcess, _SeriesCollection.PT_SeriesBusinessProcess) AS PT_SeriesBusinessProcess,
  coalesce(_SersValdtnCode.PT_SeriesStartNumber, _SeriesCollection.PT_SeriesStartNumber) AS PT_SeriesStartNumber,
  coalesce(_SersValdtnCode.PT_SeriesLastNumber, _SeriesCollection.PT_SeriesLastNumber) AS PT_SeriesLastNumber,
  _PTCert.PortugueseSgntrCertificate AS PortugueseSgntrCertificate,
  _SersValdtnCode.PT_SeriesValdtnCode AS PT_SeriesValdtnCode,
  case when _SersValdtnCode.PT_SeriesStatus is null then 'I' else _SersValdtnCode.PT_SeriesStatus end as PT_SeriesStatus AS PT_SeriesStatusendasPT_SeriesStatus,
  _SersValdtnCode.PT_SeriesRegistrationDate AS PT_SeriesRegistrationDate,
  _SersValdtnCode.PT_SeriesStatusChangeDateTime AS PT_SeriesStatusChangeDateTime,
  coalesce(_SersValdtnCode.PT_VATRegistrationCompanyCode, _SeriesCollection.PT_VATRegistrationCompanyCode) AS PT_VATRegistrationCompanyCode,
  coalesce(_SersValdtnCode.Supplier, _SeriesCollection.Supplier) AS Supplier,
  coalesce(_SersValdtnCode.PT_SupplierCategory, _SeriesCollection.PT_SupplierCategory) AS PT_SupplierCategory,
  coalesce(_SersValdtnCode.CompanyCode, _SeriesCollection.CompanyCode) AS CompanyCode,
  _SersValdtnCode.PT_SeriesCanclnIsDeclared AS PT_SeriesCanclnIsDeclared,
  _SersValdtnCode.PT_SeriesCanclnReasonCode AS PT_SeriesCanclnReasonCode,
  _SersValdtnCode.PT_SersFinishJustificationText AS PT_SersFinishJustificationText,
  _SersValdtnCode.LastChangeDateTime AS LastChangeDateTime,
  _SersValdtnCode.PortugueseDigitalSignatureDate AS PortugueseDigitalSignatureDate,
  _PTDocType.PT_SeriesDocTypeText AS PT_SeriesDocTypeText,
  _PTSersTypCd.PT_SeriesTypeCodeText AS PT_SeriesTypeCodeText,
  PT_SeriesValdtnCodeIsEditable
FROM P_PT_SeriesCollection
LEFT OUTER JOIN I_PT_SeriesValidationCodes AS _SersValdtnCode ON VATRegistration = _SersValdtnCode.VATRegistration AND PT_SeriesIdentifier = _SersValdtnCode.PT_SeriesIdentifier AND PT_SeriesDocumentType = _SersValdtnCode.PT_SeriesDocumentType AND PT_SeriesTypeCode = _SersValdtnCode.PT_SeriesTypeCode  -- association [0..1]
LEFT OUTER JOIN P_PT_DgtlSgntrCertification AS _PTCert ON _PTCert.PT_CertifiedProduct = 'S4HANA'  -- association [1..1]
LEFT OUTER JOIN I_PT_SeriesDocTypeText AS _PTDocType ON PT_SeriesDocumentType = _PTDocType.PT_SeriesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PT_SeriesTypeCodeText AS _PTSersTypCd ON PT_SeriesTypeCode = _PTSersTypCd.PT_SeriesTypeCode  -- association [0..1]
LEFT OUTER JOIN I_PT_SeriesProcgCodeText AS _PTSersProcCd ON PT_SeriesProcgCode = _PTSersProcCd.PT_SeriesProcgCode  -- association [0..1]
;

Learn More