P_ES_PTRClearingDateBoE

DDL: P_ES_PTRCLEARINGDATEBOE Type: view_entity COMPOSITE Package: GLO_FIN_IS_AUDIT_ES
38 Fields 1 Data Sources

Clearing Date of Bill of Exchange

P_ES_PTRClearingDateBoE is a Composite CDS View that provides data about "Clearing Date of Bill of Exchange" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 38 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. Part of development package GLO_FIN_IS_AUDIT_ES.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem BSEGITEM from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
Supplier I_OperationalAcctgDocItem Supplier Supplier
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
TaxFulfillmentDate
ClearingDateendasClearingDate
FiscalPeriod I_OperationalAcctgDocItem FiscalPeriod Tax period
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
DueCalculationBaseDate I_OperationalAcctgDocItem DueCalculationBaseDate Due Calculation Base Date
NetDueDate I_OperationalAcctgDocItem NetDueDate Net Due Date
PaymentTerms I_OperationalAcctgDocItem PaymentTerms Pyt Terms
PaymentBlockingReason I_OperationalAcctgDocItem PaymentBlockingReason Pmnt block
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode Special G/L Ind
SpecialGLTransactionType I_OperationalAcctgDocItem SpecialGLTransactionType Transact.Type
PaymentMethod I_OperationalAcctgDocItem PaymentMethod Pymt Meth.
FollowOnDocumentType I_OperationalAcctgDocItem FollowOnDocumentType Follow-On Document Type
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency Pt Crcy Amt
_CompanyCode I_OperationalAcctgDocItem _CompanyCode
_FiscalYear I_OperationalAcctgDocItem _FiscalYear
_JournalEntry I_OperationalAcctgDocItem _JournalEntry
_AccountingDocumentType I_OperationalAcctgDocItem _AccountingDocumentType
_FiscalPeriod I_OperationalAcctgDocItem _FiscalPeriod
_FinancialAccountType I_OperationalAcctgDocItem _FinancialAccountType
_GLAccountInCompanyCode I_OperationalAcctgDocItem _GLAccountInCompanyCode
_SpecialGLCode I_OperationalAcctgDocItem _SpecialGLCode
_CompanyCodeCurrency I_OperationalAcctgDocItem _CompanyCodeCurrency
_TransactionCurrency I_OperationalAcctgDocItem _TransactionCurrency
_DebitCreditCode I_OperationalAcctgDocItem _DebitCreditCode

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 P_ES_PTRClearingDateBoE.
-- 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 P_ES_PTRClearingDateBoE AS
SELECT
  BSEGITEM.CompanyCode AS CompanyCode,
  BSEGITEM.FiscalYear AS FiscalYear,
  BSEGITEM.AccountingDocument AS AccountingDocument,
  BSEGITEM.AccountingDocumentItem AS AccountingDocumentItem,
  BSEGITEM.AccountingDocumentType AS AccountingDocumentType,
  BSEGITEM.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  BSEGITEM.FinancialAccountType AS FinancialAccountType,
  BSEGITEM.Supplier AS Supplier,
  BSEGITEM.PostingDate AS PostingDate,
  BSEGITEM.DocumentDate AS DocumentDate,
  BSEGITEM._JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  case when BOEBSEG.AccountingDocument is not initial then BOEBSEGFULL.ClearingDate else BSEGITEM.ClearingDate end as ClearingDate AS ClearingDateendasClearingDate,
  BSEGITEM.FiscalPeriod AS FiscalPeriod,
  BSEGITEM.GLAccount AS GLAccount,
  BSEGITEM.DueCalculationBaseDate AS DueCalculationBaseDate,
  BSEGITEM.NetDueDate AS NetDueDate,
  BSEGITEM.PaymentTerms AS PaymentTerms,
  BSEGITEM.PaymentBlockingReason AS PaymentBlockingReason,
  BSEGITEM.SpecialGLCode AS SpecialGLCode,
  BSEGITEM.SpecialGLTransactionType AS SpecialGLTransactionType,
  BSEGITEM.PaymentMethod AS PaymentMethod,
  BSEGITEM.FollowOnDocumentType AS FollowOnDocumentType,
  BSEGITEM.DebitCreditCode AS DebitCreditCode,
  BSEGITEM.CompanyCodeCurrency AS CompanyCodeCurrency,
  BSEGITEM.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  BSEGITEM.TransactionCurrency AS TransactionCurrency,
  BSEGITEM.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  BSEGITEM._CompanyCode AS _CompanyCode,
  BSEGITEM._FiscalYear AS _FiscalYear,
  BSEGITEM._JournalEntry AS _JournalEntry,
  BSEGITEM._AccountingDocumentType AS _AccountingDocumentType,
  BSEGITEM._FiscalPeriod AS _FiscalPeriod,
  BSEGITEM._FinancialAccountType AS _FinancialAccountType,
  BSEGITEM._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  BSEGITEM._SpecialGLCode AS _SpecialGLCode,
  BSEGITEM._CompanyCodeCurrency AS _CompanyCodeCurrency,
  BSEGITEM._TransactionCurrency AS _TransactionCurrency,
  BSEGITEM._DebitCreditCode AS _DebitCreditCode
FROM I_OperationalAcctgDocItem AS BSEGITEM
;

Learn More