I_PT_SeriesValidationCodeTP

DDL: I_PT_SERIESVALIDATIONCODETP Type: view_entity TRANSACTIONAL
35 Fields 1 Data Sources 5 Associations

Series Validation Code - TP

I_PT_SeriesValidationCodeTP is a Transactional CDS View that provides data about "Series Validation Code - TP" in SAP S/4HANA. It reads from 1 data source (I_PT_SeriesValidationCode) and exposes 35 fields with key fields VATRegistration, PT_SeriesIdentifier, PT_SeriesTypeCode, PT_SeriesDocumentType, PT_SeriesDocumentClass. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PT_SeriesValidationCode I_PT_SeriesValidationCode from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_PT_SeriesBusinessProcText _PTSersBusProc $projection.PT_SeriesBusinessProcess = _PTSersBusProc.PT_SeriesBusinessProcess
[0..1] I_PT_SeriesStatusText _SeriesStatusText $projection.PT_SeriesStatus = _SeriesStatusText.PT_SeriesStatus
[0..1] I_PT_SeriesDocClassText _PTSersDocClass $projection.PT_SeriesDocumentClass = _PTSersDocClass.PT_SeriesDocumentClass
[0..1] I_PT_SeriesCancelReasonVH _PTSersCancelReason $projection.PT_SeriesCanclnReasonCode = _PTSersCancelReason.PT_SeriesCanclnReasonCode
[0..1] I_PT_SupplierCategoryVH _PTSersSupplierCat $projection.PT_SupplierCategory = _PTSersSupplierCat.PT_SupplierCategory

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Series Validation Code - TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY VATRegistration VATRegistration VAT Registration No.
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PortugueseSgntrCertificate PortugueseSgntrCertificate Certif. ID
PT_SeriesValdtnCode PT_SeriesValdtnCode
PT_SeriesProcgCode PT_SeriesProcgCode
PT_SeriesStatus PT_SeriesStatus
PT_SeriesStatusText _SeriesStatusText PT_SeriesStatusText
PT_SeriesRegistrationDate PT_SeriesRegistrationDate
PT_SeriesStatusChangeDateTime PT_SeriesStatusChangeDateTime
LastChangeDateTime LastChangeDateTime Timestamp
PortugueseDigitalSignatureDate PortugueseDigitalSignatureDate
PT_SeriesTypeCodeText PT_SeriesTypeCodeText
PT_SeriesDocumentClassText _PTSersDocClass PT_SeriesDocumentClassText
PT_SeriesBusinessProcText _PTSersBusProc PT_SeriesBusinessProcText
PT_SeriesDocTypeText PT_SeriesDocTypeText
PT_SeriesProcgCodeText _PTSersProcCd PT_SeriesProcgCodeText
PT_SeriesCanclnReasonCode PT_SeriesCanclnReasonCode
PT_SeriesCanclnReasonText _PTSersCancelReason PT_SeriesCanclnReasonText
PT_SeriesCanclnIsDeclared PT_SeriesCanclnIsDeclared
PT_SersFinishJustificationText PT_SersFinishJustificationText
PT_SeriesLastNumber PT_SeriesLastNumber
PT_VATRegistrationCompanyCode PT_VATRegistrationCompanyCode
Supplier Supplier Supplier
PT_SupplierCategory PT_SupplierCategory
PT_SupplierCategoryText _PTSersSupplierCat PT_SupplierCategoryText
CompanyCode CompanyCode Receiver Company Code

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_SeriesValidationCodeTP.
-- 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_SeriesValidationCodeTP AS
SELECT
  VATRegistration,
  PT_SeriesIdentifier,
  PT_SeriesTypeCode,
  PT_SeriesDocumentType,
  PT_SeriesDocumentClass,
  PT_SeriesNumberRangeObject,
  PT_SeriesNumberRangeSubObject,
  PT_SeriesNumberRangeToYear,
  PT_SeriesNumberRangeInterval,
  PT_SeriesBusinessProcess,
  PT_SeriesStartNumber,
  PortugueseSgntrCertificate,
  PT_SeriesValdtnCode,
  PT_SeriesProcgCode,
  PT_SeriesStatus,
  _SeriesStatusText.PT_SeriesStatusText AS PT_SeriesStatusText,
  PT_SeriesRegistrationDate,
  PT_SeriesStatusChangeDateTime,
  LastChangeDateTime,
  PortugueseDigitalSignatureDate,
  PT_SeriesTypeCodeText,
  _PTSersDocClass.PT_SeriesDocumentClassText AS PT_SeriesDocumentClassText,
  _PTSersBusProc.PT_SeriesBusinessProcText AS PT_SeriesBusinessProcText,
  PT_SeriesDocTypeText,
  _PTSersProcCd.PT_SeriesProcgCodeText AS PT_SeriesProcgCodeText,
  PT_SeriesCanclnReasonCode,
  _PTSersCancelReason.PT_SeriesCanclnReasonText AS PT_SeriesCanclnReasonText,
  PT_SeriesCanclnIsDeclared,
  PT_SersFinishJustificationText,
  PT_SeriesLastNumber,
  PT_VATRegistrationCompanyCode,
  Supplier,
  PT_SupplierCategory,
  _PTSersSupplierCat.PT_SupplierCategoryText AS PT_SupplierCategoryText,
  CompanyCode
FROM I_PT_SeriesValidationCode
LEFT OUTER JOIN I_PT_SeriesBusinessProcText AS _PTSersBusProc ON PT_SeriesBusinessProcess = _PTSersBusProc.PT_SeriesBusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_PT_SeriesStatusText AS _SeriesStatusText ON PT_SeriesStatus = _SeriesStatusText.PT_SeriesStatus  -- association [0..1]
LEFT OUTER JOIN I_PT_SeriesDocClassText AS _PTSersDocClass ON PT_SeriesDocumentClass = _PTSersDocClass.PT_SeriesDocumentClass  -- association [0..1]
LEFT OUTER JOIN I_PT_SeriesCancelReasonVH AS _PTSersCancelReason ON PT_SeriesCanclnReasonCode = _PTSersCancelReason.PT_SeriesCanclnReasonCode  -- association [0..1]
LEFT OUTER JOIN I_PT_SupplierCategoryVH AS _PTSersSupplierCat ON PT_SupplierCategory = _PTSersSupplierCat.PT_SupplierCategory  -- association [0..1]
;

Learn More