C_PT_SAFTWrkgDocumentQuery

DDL: C_PT_SAFTWRKGDOCUMENTQUERY SQL: CPTSAFTWKDHQRY Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PT
22 Fields 1 Data Sources

SAFT PT Working Doc Hd - Qry

C_PT_SAFTWrkgDocumentQuery is a Consumption CDS View that provides data about "SAFT PT Working Doc Hd - Qry" in SAP S/4HANA. It reads from 1 data source (C_PT_SAFTPrelimDocumentCube) and exposes 22 fields with key fields CompanyCode, PortugueseInvoiceDate, PT_SAFTDocumentNumber. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (1)

SourceAliasJoin Type
C_PT_SAFTPrelimDocumentCube a from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFTWKDHQRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label SAFT PT Working Doc Hd - Qry view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Analytics.query true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode C_PT_SAFTPrelimDocumentCube CompanyCode Receiver Company Code
KEY PortugueseInvoiceDate C_PT_SAFTPrelimDocumentCube PortugueseInvoiceDate Invoice Date
KEY PT_SAFTDocumentNumber C_PT_SAFTPrelimDocumentCube PT_SAFTDocumentNumber Document Number
DocumentTransaction C_PT_SAFTPrelimDocumentCube DocumentTransaction Transaction ID
DocumentBillingStatus C_PT_SAFTPrelimDocumentCube DocumentBillingStatus PBEE BDR Status
LastChangeDateTimeText C_PT_SAFTPrelimDocumentCube LastChangeDateTimeText Sys. Date-Time
ReversalReasonName C_PT_SAFTPrelimDocumentCube ReversalReasonName Rev. Reason Name
LastChangedByUser C_PT_SAFTPrelimDocumentCube LastChangedByUser User Name
SourceBillingDocumentType C_PT_SAFTPrelimDocumentCube SourceBillingDocumentType Billing Type
PortugueseDigitalSignature C_PT_SAFTPrelimDocumentCube PortugueseDigitalSignature Digital Signature
PortugueseDgtlSgntrKeyVersion C_PT_SAFTPrelimDocumentCube PortugueseDgtlSgntrKeyVersion Key Version
FiscalPeriod C_PT_SAFTPrelimDocumentCube FiscalPeriod Tax period
PTDgtlSgntrSystemDateTimeText C_PT_SAFTPrelimDocumentCube PTDgtlSgntrSystemDateTimeText Sys. Date-Time
WorkTypeName C_PT_SAFTPrelimDocumentCube WorkTypeName WorkType
PortugueseCustomerWithVersion C_PT_SAFTPrelimDocumentCube PortugueseCustomerWithVersion Customer ID
TotalTaxAmount C_PT_SAFTPrelimDocumentCube TotalTaxAmount Total Tax Amount
TotalNetAmount C_PT_SAFTPrelimDocumentCube TotalNetAmount Total Net Amount
TotalGrossAmount C_PT_SAFTPrelimDocumentCube TotalGrossAmount Total Gross Amount
TransactionCurrency C_PT_SAFTPrelimDocumentCube TransactionCurrency Transaction Currency
CompanyCodeCurrency C_PT_SAFTPrelimDocumentCube CompanyCodeCurrency Local Currency
InvoiceAmountInFrgnCurrency C_PT_SAFTPrelimDocumentCube InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
ExchangeRate C_PT_SAFTPrelimDocumentCube ExchangeRate Exchange rate

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_SAFTWrkgDocumentQuery.
-- 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: CPTSAFTWKDHQRY

CREATE VIEW C_PT_SAFTWrkgDocumentQuery AS
SELECT
  a.CompanyCode AS CompanyCode,
  a.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  a.PT_SAFTDocumentNumber AS PT_SAFTDocumentNumber,
  a.DocumentTransaction AS DocumentTransaction,
  a.DocumentBillingStatus AS DocumentBillingStatus,
  a.LastChangeDateTimeText AS LastChangeDateTimeText,
  a.ReversalReasonName AS ReversalReasonName,
  a.LastChangedByUser AS LastChangedByUser,
  a.SourceBillingDocumentType AS SourceBillingDocumentType,
  a.PortugueseDigitalSignature AS PortugueseDigitalSignature,
  a.PortugueseDgtlSgntrKeyVersion AS PortugueseDgtlSgntrKeyVersion,
  a.FiscalPeriod AS FiscalPeriod,
  a.PTDgtlSgntrSystemDateTimeText AS PTDgtlSgntrSystemDateTimeText,
  a.WorkTypeName AS WorkTypeName,
  a.PortugueseCustomerWithVersion AS PortugueseCustomerWithVersion,
  a.TotalTaxAmount AS TotalTaxAmount,
  a.TotalNetAmount AS TotalNetAmount,
  a.TotalGrossAmount AS TotalGrossAmount,
  a.TransactionCurrency AS TransactionCurrency,
  a.CompanyCodeCurrency AS CompanyCodeCurrency,
  a.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  a.ExchangeRate AS ExchangeRate
FROM C_PT_SAFTPrelimDocumentCube AS a
;

Learn More