P_ReceivablesItemHedgedAmount1

DDL: P_RECEIVABLESITEMHEDGEDAMOUNT1 SQL: PRBLSHEDGEDAMT1 Type: view COMPOSITE
23 Fields 1 Data Sources 1 Associations

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.

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 Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
ClearingDate ClearingDate Clearing Date
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
DebitCreditCode DebitCreditCode Single-Character Flag
BusinessArea BusinessArea Business Area
GLAccount GLAccount General Ledger
Debtor Customer Sold-to Party
Creditor Supplier Supplier
PaymentDifferenceReason PaymentDifferenceReason Reason Code
CreditControlArea CreditControlArea Credit Control Area
DocumentDate DocumentDate Journal Entry Date
NetDueDate NetDueDate Net Due Date
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
CreditControlAreaCurrency _CreditControlArea CreditControlAreaCurrency Credit Control Area Currency
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
HedgedAmount HedgedAmount

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_ReceivablesItemHedgedAmount1.
-- 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: PRBLSHEDGEDAMT1

CREATE VIEW P_ReceivablesItemHedgedAmount1 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  ClearingDate,
  FinancialAccountType,
  SpecialGLCode,
  DebitCreditCode,
  BusinessArea,
  GLAccount,
  Customer AS Debtor,
  Supplier AS Creditor,
  PaymentDifferenceReason,
  CreditControlArea,
  DocumentDate,
  NetDueDate,
  AccountingDocumentCategory,
  _CreditControlArea.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  HedgedAmount
FROM I_OperationalAcctgDocItem
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
;

Learn More