C_PT_SeriesValidationCodeTP

DDL: C_PT_SERIESVALIDATIONCODETP Type: view_entity CONSUMPTION Package: GLO-PT-ATCUD

Series Validation Code - TP

C_PT_SeriesValidationCodeTP is a Consumption CDS View that provides data about "Series Validation Code - TP" in SAP S/4HANA. It reads from 1 data source (I_PT_SeriesValidationCodeTP) and exposes 40 fields with key fields VATRegistration, PT_SeriesIdentifier, PT_SeriesTypeCode, PT_SeriesDocumentType, PT_SeriesDocumentClass. It is exposed through 2 OData services (ASQL_F6137, UI_PT_SERIESVALDTNCODE). It is used in 1 Fiori application: Manage Series Validation Code. Part of development package GLO-PT-ATCUD.

Data Sources (1)

SourceAliasJoin Type
I_PT_SeriesValidationCodeTP I_PT_SeriesValidationCodeTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label Series Validation Code - TP view
ObjectModel.usageType.serviceQuality #C view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F6137 ASQL_F6137 C2 NOT_RELEASED
UI_PT_SERIESVALDTNCODE UI_PT_SERIESVALDTNCODE V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F6137 Manage Series Validation Code Transactional An application to maintain the Validation code for a Number Range Series in Portugal

Manage Series Validation Code

Business Role: General Ledger Accountant for Portugal

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY VATRegistration VATRegistration VAT Registration No.
KEY PT_SeriesIdentifier PT_SeriesIdentifier Number Range Series
KEY PT_SeriesTypeCode PT_SeriesTypeCode
KEY PT_SeriesDocumentType PT_SeriesDocumentType Series Document Type
KEY PT_SeriesDocumentClass PT_SeriesDocumentClass Document Class
PT_SeriesNumberRangeObject PT_SeriesNumberRangeObject
PT_SeriesNumberRangeSubObject PT_SeriesNumberRangeSubObject
PT_SeriesNumberRangeToYear PT_SeriesNumberRangeToYear
PT_SeriesNumberRangeInterval PT_SeriesNumberRangeInterval
PT_SeriesBusinessProcess PT_SeriesBusinessProcess Business Process
PortugueseDigitalSignatureDate PortugueseDigitalSignatureDate Start Date
PT_SeriesStartNumber PT_SeriesStartNumber Series Start Number
PortugueseSgntrCertificate PortugueseSgntrCertificate Certification ID
PT_SeriesValdtnCode PT_SeriesValdtnCode Validation Code
PT_SeriesProcgCode PT_SeriesProcgCode Series Processing Medium
PT_SeriesStatus PT_SeriesStatus Series Status
PT_SeriesStatusText PT_SeriesStatusText
PT_SeriesRegistrationDate PT_SeriesRegistrationDate Registration Date
PT_SeriesStatusChangeDateTime PT_SeriesStatusChangeDateTime Series Status Change Time
LastChangeDateTime LastChangeDateTime Timestamp
PT_SeriesBusinessProcText PT_SeriesBusinessProcText
PT_SeriesDocumentClassText PT_SeriesDocumentClassText
PT_SeriesDocTypeText PT_SeriesDocTypeText
PT_SeriesTypeCodeText PT_SeriesTypeCodeText
PT_SeriesProcgCodeText PT_SeriesProcgCodeText
PT_SupplierCategoryText PT_SupplierCategoryText
StatusCriticality StatusCriticality
PT_IsSelfBillingRelevance PT_IsSelfBillingRelevance
PT_SeriesValdtnCodeIsEditable PT_SeriesValdtnCodeIsEditable
PT_SeriesCanclnReasonCode PT_SeriesCanclnReasonCode Cancellation Reason Code
PT_SeriesCanclnReasonText PT_SeriesCanclnReasonText
PT_SeriesCanclnIsDeclared PT_SeriesCanclnIsDeclared
PT_SersFinishJustificationText PT_SersFinishJustificationText Finished Justification
PT_SeriesLastNumber PT_SeriesLastNumber Series Last Number
IsCancelled IsCancelled Boolean Variable (X = True, - = False, Space = Unknown)
IsExpired IsExpired Indicator
PT_VATRegistrationCompanyCode PT_VATRegistrationCompanyCode VAT Company Code
Supplier Supplier Supplier
PT_SupplierCategory PT_SupplierCategory Supplier Category
CompanyCode CompanyCode Requesting 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 C_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 C_PT_SeriesValidationCodeTP AS
SELECT
  VATRegistration,
  PT_SeriesIdentifier,
  PT_SeriesTypeCode,
  PT_SeriesDocumentType,
  PT_SeriesDocumentClass,
  PT_SeriesNumberRangeObject,
  PT_SeriesNumberRangeSubObject,
  PT_SeriesNumberRangeToYear,
  PT_SeriesNumberRangeInterval,
  PT_SeriesBusinessProcess,
  PortugueseDigitalSignatureDate,
  PT_SeriesStartNumber,
  PortugueseSgntrCertificate,
  PT_SeriesValdtnCode,
  PT_SeriesProcgCode,
  PT_SeriesStatus,
  PT_SeriesStatusText,
  PT_SeriesRegistrationDate,
  PT_SeriesStatusChangeDateTime,
  LastChangeDateTime,
  PT_SeriesBusinessProcText,
  PT_SeriesDocumentClassText,
  PT_SeriesDocTypeText,
  PT_SeriesTypeCodeText,
  PT_SeriesProcgCodeText,
  PT_SupplierCategoryText,
  StatusCriticality,
  PT_IsSelfBillingRelevance,
  PT_SeriesValdtnCodeIsEditable,
  PT_SeriesCanclnReasonCode,
  PT_SeriesCanclnReasonText,
  PT_SeriesCanclnIsDeclared,
  PT_SersFinishJustificationText,
  PT_SeriesLastNumber,
  IsCancelled,
  IsExpired,
  PT_VATRegistrationCompanyCode,
  Supplier,
  PT_SupplierCategory,
  CompanyCode
FROM I_PT_SeriesValidationCodeTP
;