P_DebitOpenItemForSituation

DDL: P_DEBITOPENITEMFORSITUATION SQL: PDBTOPENITMFRSIT Type: view COMPOSITE

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.

1 data source(s) 22 fields

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
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
TransactionCurrency TransactionCurrency
Customer Customer
AccountingDocumentType AccountingDocumentType
PostingKey PostingKey
DocumentDate DocumentDate
AmountInTransactionCurrency
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
SpecialGLTransactionType SpecialGLTransactionType
ClearingDate ClearingDate
ClearingAccountingDocument ClearingAccountingDocument
ClearingJournalEntry ClearingJournalEntry
AssignmentReference AssignmentReference
DocumentItemText DocumentItemText
DebitCreditCode DebitCreditCode
NetDueDate NetDueDate
DocumentReferenceID _JournalEntry DocumentReferenceID
_Customer _Customer 
@AbapCatalog.sqlViewName: 'PDBTOPENITMFRSIT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
define view P_DebitOpenItemForSituation
  as select from I_OperationalAcctgDocItem
{
  key CompanyCode,
      @Consumption.semanticObject: 'AccountingDocument'
  key AccountingDocument,
  key FiscalYear,
  key AccountingDocumentItem,
      @Semantics.currencyCode: true
      TransactionCurrency,
      Customer,
      AccountingDocumentType,
      PostingKey,
      DocumentDate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast(AmountInTransactionCurrency as farp_transaction_amount preserving type) as AmountInTransactionCurrency,
      FinancialAccountType,
      SpecialGLCode,
      SpecialGLTransactionType,
      ClearingDate,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'ClearingJournalEntry' 
      ClearingAccountingDocument,
      ClearingJournalEntry,
      AssignmentReference,
      DocumentItemText,
      DebitCreditCode,
      NetDueDate,
      _JournalEntry.DocumentReferenceID,
      
      _Customer
}

where
          FinancialAccountType                  =  'D'
  and     ClearingAccountingDocument            =  ''
  and     AccountingDocumentCategory            <> 'D'
  and     AccountingDocumentCategory            <> 'M'
  and(
          DebitCreditCode                       =  'S'
    or(
          DebitCreditCode                       =  'H'
      and AmountInTransactionCurrency           >  0
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_CUSTOMER"
],
"BASE":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More