I_PT_SeriesCollection

DDL: I_PT_SERIESCOLLECTION Type: view_entity COMPOSITE Package: GLO-PT-ATCUD

Portugal Numbr Range Series Cross Module

I_PT_SeriesCollection is a Composite CDS View that provides data about "Portugal Numbr Range Series Cross Module" in SAP S/4HANA. Part of development package GLO-PT-ATCUD.

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Portugal Numbr Range Series Cross Module view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (107)

KeyFieldSource TableSource FieldDescription
KEY VATRegistration VATRegistration VAT Registration No.
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesLastNumber PT_SeriesLastNumber
PT_VATRegistrationCompanyCode
Supplier Supplier
PT_SupplierCategory
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesLastNumber
PT_VATRegistrationCompanyCode
Supplier Supplier
PT_SupplierCategory
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesLastNumber
PT_VATRegistrationCompanyCode
Supplier Supplier
PT_SupplierCategory
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesLastNumber
PT_VATRegistrationCompanyCode
Supplier Supplier
PT_SupplierCategory
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesLastNumber
PT_VATRegistrationCompanyCode
Supplier Supplier
PT_SupplierCategory
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesLastNumber PT_SeriesLastNumber
PT_VATRegistrationCompanyCode PT_VATRegistrationCompanyCode
Supplier Supplier Supplier
PT_SupplierCategory PT_SupplierCategory
KEY PT_SeriesIdentifier PT_SeriesIdentifier
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass
KEY PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess
PT_SeriesStartNumber PT_SeriesStartNumber
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesLastNumber PT_SeriesLastNumber
PT_VATRegistrationCompanyCode PT_VATRegistrationCompanyCode
Supplier Supplier Supplier
PT_SupplierCategory PT_SupplierCategory
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_SeriesCollection.
-- 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_SeriesCollection AS
SELECT
  VATRegistration,
  PT_SeriesIdentifier,
  PT_SeriesTypeCode,
  PT_SeriesDocumentClass,
  PT_SeriesDocumentType,
  PT_SeriesNumberRangeObject,
  PT_SeriesNumberRangeSubObject,
  PT_SeriesNumberRangeToYear,
  PT_SeriesNumberRangeInterval,
  PT_SeriesBusinessProcess,
  PT_SeriesStartNumber,
  PT_SeriesValdtnCodeIsEditable,
  PT_SeriesLastNumber,
  cast('-' as glo_pt_reqvat) AS PT_VATRegistrationCompanyCode,
  cast('-' as md_supplier ) AS Supplier,
  cast('-' as glo_pt_sup_cat ) AS PT_SupplierCategory,
  CompanyCode
;