P_ReceivablesItemHedgedAmount1

DDL: P_RECEIVABLESITEMHEDGEDAMOUNT1 SQL: PRBLSHEDGEDAMT1 Type: view COMPOSITE

P_ReceivablesItemHedgedAmount1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 23 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 1 association to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CreditControlArea _CreditControlArea $projection.CreditControlArea = _CreditControlArea.CreditControlArea

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRBLSHEDGEDAMT1 view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
ClearingDate ClearingDate
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
DebitCreditCode DebitCreditCode
BusinessArea BusinessArea
GLAccount GLAccount
Debtor Customer
Creditor Supplier
PaymentDifferenceReason PaymentDifferenceReason
CreditControlArea CreditControlArea
DocumentDate DocumentDate
NetDueDate NetDueDate
AccountingDocumentCategory AccountingDocumentCategory
CreditControlAreaCurrency _CreditControlArea CreditControlAreaCurrency
TransactionCurrency TransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
HedgedAmount HedgedAmount 
@AbapCatalog.sqlViewName: 'PRBLSHEDGEDAMT1'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ReceivablesItemHedgedAmount1

  as select from  I_OperationalAcctgDocItem  //  P_ReceivablesItem

  
  association [0..1] to I_CreditControlArea as _CreditControlArea on  $projection.CreditControlArea           = _CreditControlArea.CreditControlArea
  
{
  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
  key AccountingDocumentItem,
  
      ClearingDate,
      FinancialAccountType,
      SpecialGLCode,
      DebitCreditCode,
      BusinessArea,
      GLAccount,
      Customer                as Debtor,
      Supplier                as Creditor,
      PaymentDifferenceReason,
      CreditControlArea,
      DocumentDate,
      NetDueDate,
      AccountingDocumentCategory,
      
      cast( case
              when _JournalEntry.ExchangeRateDate is initial then PostingDate
              else _JournalEntry.ExchangeRateDate
            end  as fac_wwert_d )                   as CurrencyTranslationDate,
      _CreditControlArea.CreditControlAreaCurrency  as CreditControlAreaCurrency,

      @Semantics.currencyCode: true
      TransactionCurrency,
      @Semantics.currencyCode: true
      CompanyCodeCurrency,

      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      AmountInCompanyCodeCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      AmountInTransactionCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      HedgedAmount
}
where FinancialAccountType = 'D'                                                                                                         
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CREDITCONTROLAREA",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_CREDITCONTROLAREA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More