C_PT_SAFTDeliveryHdrCube

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_SAFTDeliveryHdrCube.
-- 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: CPTSAFTDELHDRC

CREATE VIEW C_PT_SAFTDeliveryHdrCube AS
SELECT
  PortugueseDeliveryNumber,
  DeliveryDocument,
  ShipToParty,
  CreationTime,
  CompanyCode,
  DeliveryDocumentType,
  PT_SeriesDocumentNumber,
  PT_SeriesDocumentType,
  GoodsMovementStatus,
  CreatedByUser,
  PortugueseDigitalSignature,
  BillingPriceSource,
  PTDgtlSgntrSystemDateTimeText,
  PortugueseDgtlSgntrKeyVersion,
  SUBSTRING(TransportationPlanningDate,5,2) AS TransportationPlanningDate,
  PortugueseSgntrCertificate,
  Supplier,
  DeliveryDate,
  ShipToPartyHouseNumber,
  ShipToPartyStreetName,
  CustAddressNumber,
  ShipToPartyCityName,
  ShipToPartyPostalCode,
  ShipToPartyCountry,
  CustomerRegion,
  HouseNumber,
  StreetName,
  SupplierAddress,
  CityName,
  PostalCode,
  Region,
  Country,
  TransportationPlanningTimeZone,
  GoodsIssueTime,
  InvoiceAmountInFrgnCurrency,
  cast(TransactionCurrency as waers) AS TransactionCurrency,
  cast( TotalGrossAmount as abap.dec(11,2)) AS TotalGrossAmount,
  TotalNetAmount,
  TotalTaxAmount,
  ExchangeRate
FROM I_PT_SAFTDeliveryHeader
;