P_DebitOpenItemForSituation

DDL: P_DEBITOPENITEMFORSITUATION SQL: PDBTOPENITMFRSIT Type: view COMPOSITE
22 Fields 1 Data Sources

P_DebitOpenItemForSituation is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 22 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PDBTOPENITMFRSIT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
TransactionCurrency TransactionCurrency Transaction Currency
Customer Customer Sold-to Party
AccountingDocumentType AccountingDocumentType Journal Entry Type
PostingKey PostingKey Posting Key
DocumentDate DocumentDate Journal Entry Date
AmountInTransactionCurrency Pt Crcy Amt
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
ClearingDate ClearingDate Clearing Date
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ClearingJournalEntry ClearingJournalEntry Clrng doc.
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
DebitCreditCode DebitCreditCode Single-Character Flag
NetDueDate NetDueDate Net Due Date
DocumentReferenceID _JournalEntry DocumentReferenceID Reference
_Customer _Customer

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_DebitOpenItemForSituation.
-- 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: PDBTOPENITMFRSIT

CREATE VIEW P_DebitOpenItemForSituation AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  TransactionCurrency,
  Customer,
  AccountingDocumentType,
  PostingKey,
  DocumentDate,
  cast(AmountInTransactionCurrency as farp_transaction_amount preserving type) AS AmountInTransactionCurrency,
  FinancialAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingJournalEntry,
  AssignmentReference,
  DocumentItemText,
  DebitCreditCode,
  NetDueDate,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID
FROM I_OperationalAcctgDocItem
;

Learn More