P_ContrLbltyAstWthRefToImprmt

DDL: P_CONTRLBLTYASTWTHREFTOIMPRMT SQL: PCLCAREFIMP Type: view COMPOSITE
18 Fields 2 Data Sources

P_ContrLbltyAstWthRefToImprmt is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_RAPostingWithoutAcctAssgmt, I_RAPostingWithoutAcctAssgmt) and exposes 18 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, PerformanceObligation, RevnAcctgPostingCategory.

Data Sources (2)

SourceAliasJoin Type
I_RAPostingWithoutAcctAssgmt _RAImpairOfAssetPosting inner
I_RAPostingWithoutAcctAssgmt RevenueAccountingPosting from

Parameters (4)

NameTypeDefault
P_FiscalYearFrom fis_gjahr
P_FiscalPeriodFrom fis_poper
P_FiscalYearTo fis_gjahr
P_FiscalPeriodTo fis_poper

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCLCAREFIMP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_RAPostingWithoutAcctAssgmt CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RAPostingWithoutAcctAssgmt AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract I_RAPostingWithoutAcctAssgmt RevenueAccountingContract Revenue Contract
KEY PerformanceObligation I_RAPostingWithoutAcctAssgmt PerformanceObligation Performance Obligation
KEY RevnAcctgPostingCategory I_RAPostingWithoutAcctAssgmt RevnAcctgPostingCategory Update to FI
KEY RevnAcctgReconciliationKey I_RAPostingWithoutAcctAssgmt RevnAcctgReconciliationKey Reconcil. Key
FiscalYear I_RAPostingWithoutAcctAssgmt FiscalYear G/L Fiscal Year
FiscalPeriod I_RAPostingWithoutAcctAssgmt FiscalPeriod Tax period
FiscalYearPeriod I_RAPostingWithoutAcctAssgmt FiscalYearPeriod Period/Year
SalesDocumentCurrency I_RAPostingWithoutAcctAssgmt SalesDocumentCurrency Currency
CompanyCodeCurrency I_RAPostingWithoutAcctAssgmt CompanyCodeCurrency Local Currency
AdditionalCurrency1 I_RAPostingWithoutAcctAssgmt AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_RAPostingWithoutAcctAssgmt AdditionalCurrency2 Local curr. 3
RevnAcctgPostgAmtInSlsDocCrcy I_RAPostingWithoutAcctAssgmt RevnAcctgPostgAmtInSlsDocCrcy Reduction Amt
RevnAcctgPostgAmtInCoCodeCrcy I_RAPostingWithoutAcctAssgmt RevnAcctgPostgAmtInCoCodeCrcy
RevnAcctgPostgAmtInAddlCrcy1 I_RAPostingWithoutAcctAssgmt RevnAcctgPostgAmtInAddlCrcy1 Second Local Crcy
RevnAcctgPostgAmtInAddlCrcy2 I_RAPostingWithoutAcctAssgmt RevnAcctgPostgAmtInAddlCrcy2 Third Local Crcy
RAPostLevelOfContractBalance

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_ContrLbltyAstWthRefToImprmt.
-- 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: PCLCAREFIMP
-- Parameters: P_FiscalYearFrom : fis_gjahr, P_FiscalPeriodFrom : fis_poper, P_FiscalYearTo : fis_gjahr, P_FiscalPeriodTo : fis_poper

CREATE VIEW P_ContrLbltyAstWthRefToImprmt AS
SELECT
  RevenueAccountingPosting.CompanyCode AS CompanyCode,
  RevenueAccountingPosting.AccountingPrinciple AS AccountingPrinciple,
  RevenueAccountingPosting.RevenueAccountingContract AS RevenueAccountingContract,
  RevenueAccountingPosting.PerformanceObligation AS PerformanceObligation,
  RevenueAccountingPosting.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  RevenueAccountingPosting.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  RevenueAccountingPosting.FiscalYear AS FiscalYear,
  RevenueAccountingPosting.FiscalPeriod AS FiscalPeriod,
  RevenueAccountingPosting.FiscalYearPeriod AS FiscalYearPeriod,
  RevenueAccountingPosting.SalesDocumentCurrency AS SalesDocumentCurrency,
  RevenueAccountingPosting.CompanyCodeCurrency AS CompanyCodeCurrency,
  RevenueAccountingPosting.AdditionalCurrency1 AS AdditionalCurrency1,
  RevenueAccountingPosting.AdditionalCurrency2 AS AdditionalCurrency2,
  RevenueAccountingPosting.RevnAcctgPostgAmtInSlsDocCrcy AS RevnAcctgPostgAmtInSlsDocCrcy,
  RevenueAccountingPosting.RevnAcctgPostgAmtInCoCodeCrcy AS RevnAcctgPostgAmtInCoCodeCrcy,
  RevenueAccountingPosting.RevnAcctgPostgAmtInAddlCrcy1 AS RevnAcctgPostgAmtInAddlCrcy1,
  RevenueAccountingPosting.RevnAcctgPostgAmtInAddlCrcy2 AS RevnAcctgPostgAmtInAddlCrcy2,
  RevenueAccountingPosting._RevenueAccountingContract.RAPostLevelOfContractBalance AS RAPostLevelOfContractBalance
FROM I_RAPostingWithoutAcctAssgmt AS RevenueAccountingPosting
INNER JOIN I_RAPostingWithoutAcctAssgmt AS _RAImpairOfAssetPosting ON /* join condition not captured in parsed metadata */
;

Learn More