C_PT_SAFTDeliveryHdrQry

DDL: C_PT_SAFTDELIVERYHDRQRY SQL: CPTSAFTDELHDRQ Type: view CONSUMPTION
42 Fields 1 Data Sources

SAFT Delivery Document Header query view

C_PT_SAFTDeliveryHdrQry is a Consumption CDS View that provides data about "SAFT Delivery Document Header query view" in SAP S/4HANA. It reads from 1 data source (C_PT_SAFTDeliveryHdrCube) and exposes 42 fields with key field PortugueseDeliveryNumber.

Data Sources (1)

SourceAliasJoin Type
C_PT_SAFTDeliveryHdrCube C_PT_SAFTDeliveryHdrCube from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFTDELHDRQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
AbapCatalog.preserveKey true view
EndUserText.label SAFT Delivery Document Header query view view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PortugueseDeliveryNumber PortugueseDeliveryNumber Delivery No
DeliveryDocument DeliveryDocument Outbound Delivery
ShipToParty ShipToParty Ship-To Party (obsolete)
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CompanyCode CompanyCode Receiver Company Code
DeliveryDocumentType DeliveryDocumentType Delivery Type
PT_SeriesDocumentNumber PT_SeriesDocumentNumber ATCUD Code
PT_SeriesDocumentType PT_SeriesDocumentType SAF-T Document Type
GoodsMovementStatus GoodsMovementStatus Gds Movemt Status
CreatedByUser CreatedByUser User Name
BillingPriceSource BillingPriceSource Single-Character Flag
PortugueseCustomerWithVersion PortugueseCustomerWithVersion
PTDgtlSgntrSystemDateTimeText PTDgtlSgntrSystemDateTimeText Sys. Date-Time
PortugueseDigitalSignature PortugueseDigitalSignature Digital Signature
PortugueseDgtlSgntrKeyVersion PortugueseDgtlSgntrKeyVersion Key Version
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
PortugueseSgntrCertificate PortugueseSgntrCertificate Certif. ID
Supplier Supplier Supplier
DeliveryDate DeliveryDate Delivery Date
ShipToPartyHouseNumber ShipToPartyHouseNumber House Number
ShipToPartyStreetName ShipToPartyStreetName Street
CustAddressNumber CustAddressNumber
ShipToPartyCityName ShipToPartyCityName City
ShipToPartyPostalCode ShipToPartyPostalCode Postal Code
ShipToPartyCountry ShipToPartyCountry Country/Region
CustomerRegion CustomerRegion
HouseNumber HouseNumber House Number
StreetName StreetName Text
SupplierAddress SupplierAddress 3rd Party Suplr Addr
CityName CityName Name
PostalCode PostalCode Postal Code
Region Region Venue Region
Country Country Venue: Ctry/Reg
TransportationPlanningTimeZone TransportationPlanningTimeZone Time Zone
GoodsIssueTime GoodsIssueTime GI Time
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
TotalGrossAmount TotalGrossAmount Total Gross Amount
TotalNetAmount TotalNetAmount Total Net Amount
TotalTaxAmount TotalTaxAmount Tax Amount
ExchangeRate ExchangeRate Exchange rate
TransactionCurrency TransactionCurrency Transaction Currency

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_SAFTDeliveryHdrQry.
-- 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: CPTSAFTDELHDRQ

CREATE VIEW C_PT_SAFTDeliveryHdrQry AS
SELECT
  PortugueseDeliveryNumber,
  DeliveryDocument,
  ShipToParty,
  CreationDate,
  CreationTime,
  CompanyCode,
  DeliveryDocumentType,
  PT_SeriesDocumentNumber,
  PT_SeriesDocumentType,
  GoodsMovementStatus,
  CreatedByUser,
  BillingPriceSource,
  PortugueseCustomerWithVersion,
  PTDgtlSgntrSystemDateTimeText,
  PortugueseDigitalSignature,
  PortugueseDgtlSgntrKeyVersion,
  TransportationPlanningDate,
  PortugueseSgntrCertificate,
  Supplier,
  DeliveryDate,
  ShipToPartyHouseNumber,
  ShipToPartyStreetName,
  CustAddressNumber,
  ShipToPartyCityName,
  ShipToPartyPostalCode,
  ShipToPartyCountry,
  CustomerRegion,
  HouseNumber,
  StreetName,
  SupplierAddress,
  CityName,
  PostalCode,
  Region,
  Country,
  TransportationPlanningTimeZone,
  GoodsIssueTime,
  InvoiceAmountInFrgnCurrency,
  TotalGrossAmount,
  TotalNetAmount,
  TotalTaxAmount,
  ExchangeRate,
  TransactionCurrency
FROM C_PT_SAFTDeliveryHdrCube
;

Learn More