Deprecated
This CDS view is deprecated in S/4HANA. Use C_PT_SAFTPaymentDocumentC instead. View all deprecated CDS views →

C_PT_SAFTPaytDocHeaderCube

DDL: C_PT_SAFTPAYTDOCHEADERCUBE Type: view_entity CONSUMPTION Package: ID-FI-SAFT_DEPREC
11 Fields 5 Data Sources 1 Associations

Payment Header for SAFT PT - Cube

C_PT_SAFTPaytDocHeaderCube is a Consumption CDS View (Cube) that provides data about "Payment Header for SAFT PT - Cube" in SAP S/4HANA. It reads from 5 data sources (I_AccountingDocumentType, I_PT_SAFTPaytSignatureCheck, I_ClrgInfoRelationForAcctgDoc, I_JournalEntry, I_PT_DgtlSgntrNmbrRngeAcctg) and exposes 11 fields with key fields CompanyCode, PostingDate, FiscalYear, ClearingAccountingDocument. It has 1 association to related views. Part of development package ID-FI-SAFT_DEPREC.

Data Sources (5)

SourceAliasJoin Type
I_AccountingDocumentType AcctDoc inner
I_PT_SAFTPaytSignatureCheck check inner
I_ClrgInfoRelationForAcctgDoc Clear inner
I_JournalEntry Document from
I_PT_DgtlSgntrNmbrRngeAcctg NrRange inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_AccountingDocument _ReversalDocument _ReversalDocument.AccountingDocument = Document.ReverseDocument and _ReversalDocument.FiscalYear = Document.ReverseDocumentFiscalYear and _ReversalDocument.CompanyCode = Document.CompanyCode

Annotations (12)

NameValueLevelField
EndUserText.label Payment Header for SAFT PT - Cube view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_PT_SAFTPaymentDocumentC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode Receiver Company Code
KEY PostingDate I_JournalEntry PostingDate Posting Date for GR
KEY FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
KEY ClearingAccountingDocument I_JournalEntry AccountingDocument Journal Entry
char30asPaymentReference
FiscalPeriod I_JournalEntry FiscalPeriod Tax period
char70asDocumentTransaction
CreationTime52endasPaymentStatusDateText
ReversalReason I_JournalEntry ReversalReason Reversal Reason
CreatedByUser I_JournalEntry AccountingDocCreatedByUser User which created overhead document
CreationTime52asLastChangeDateTimeText

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_SAFTPaytDocHeaderCube.
-- 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_SAFTPaytDocHeaderCube AS
SELECT
  Document.CompanyCode AS CompanyCode,
  Document.PostingDate AS PostingDate,
  Document.FiscalYear AS FiscalYear,
  Document.AccountingDocument AS ClearingAccountingDocument,
  cast(concat( concat( concat_with_space(Document.AccountingDocumentType, NrRange.PortugueseDgtlSignatureSeries, 1), '/'), Document.AccountingDocument) as abap.char(30)) as PaymentReference AS char30asPaymentReference,
  Document.FiscalPeriod AS FiscalPeriod,
  cast(concat_with_space(concat(substring(Document.DocumentDate,1,4), concat('-', concat(substring(Document.DocumentDate,5,2), concat('-', substring(Document.DocumentDate,7,2))))), concat_with_space(Document.AccountingDocumentType, Document.AccountingDocument, 1), 1) as abap.char(70)) as DocumentTransaction AS char70asDocumentTransaction,
  case when Document.ReverseDocument is not initial and Document.IsReversed <> '' then concat(substring(Document.AccountingDocumentCreationDate,1,4), concat('-', concat(substring(_ReversalDocument.AccountingDocumentCreationDate,5,2), concat('-', concat(substring(_ReversalDocument.AccountingDocumentCreationDate,7,2), concat('T', concat(substring(_ReversalDocument.CreationTime,1,2), concat(':', concat(substring(_ReversalDocument.CreationTime,3,2), concat(':', substring(_ReversalDocument.CreationTime,5,2))))))))))) else concat(substring(Document.AccountingDocumentCreationDate,1,4), concat('-', concat(substring(Document.AccountingDocumentCreationDate,5,2), concat('-', concat(substring(Document.AccountingDocumentCreationDate,7,2), concat('T', concat(substring(Document.CreationTime,1,2), concat(':', concat(substring(Document.CreationTime,3,2), concat(':', substring(Document.CreationTime,5,2))))))))))) end as PaymentStatusDateText AS CreationTime52endasPaymentStatusDateText,
  Document.ReversalReason AS ReversalReason,
  Document.AccountingDocCreatedByUser AS CreatedByUser,
  concat(substring(Document.AccountingDocumentCreationDate,1,4), concat('-', concat(substring(Document.AccountingDocumentCreationDate,5,2), concat('-', concat(substring(Document.AccountingDocumentCreationDate,7,2), concat('T', concat(substring(Document.CreationTime,1,2), concat(':', concat(substring(Document.CreationTime,3,2), concat(':', substring(Document.CreationTime,5,2))))))))))) as LastChangeDateTimeText AS CreationTime52asLastChangeDateTimeText
FROM I_JournalEntry AS Document
INNER JOIN I_PT_SAFTPaytSignatureCheck AS check ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClrgInfoRelationForAcctgDoc AS Clear ON /* join condition not captured in parsed metadata */
INNER JOIN I_AccountingDocumentType AS AcctDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_DgtlSgntrNmbrRngeAcctg AS NrRange ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccountingDocument AS _ReversalDocument ON _ReversalDocument.AccountingDocument = Document.ReverseDocument AND _ReversalDocument.FiscalYear = Document.ReverseDocumentFiscalYear AND _ReversalDocument.CompanyCode = Document.CompanyCode  -- association [0..1]
;

Learn More