P_CrExp

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_CrExp.
-- 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: PCREXP

CREATE VIEW P_CrExp AS
SELECT
  I_Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CreditControlArea._CreditControlArea2Segment.CreditSegment AS CreditSegment,
  'Y' AS xBseg,
  _AccountingDocument.CreditControlArea AS CreditControlArea,
  _AccountingDocument.Customer AS Customer,
  _AccountingDocument.AccountingDocument AS AccountingDocument,
  _AccountingDocument.FiscalYear AS FiscalYear,
  _AccountingDocument.SpecialGLCode AS SpecialGLCode,
  _AccountingDocument._SpecialGLCode.CreditLimitIsChecked AS CreditLimitIsChecked,
  _AccountingDocument.FinancialAccountType AS FinancialAccountType,
  _AccountingDocument.TransactionCurrency AS TransactionCurrency,
  _AccountingDocument.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _AccountingDocument.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  _AccountingDocument.HedgedAmount AS HedgedAmount,
  _CreditControlArea._CreditControlArea2Segment._CreditSegment.CreditSegmentCurrency AS CreditSegmentCurrency,
  _CreditControlArea._CreditControlArea2Segment._CreditSegment.CrdtSgmtIsAddedToMainSgmt AS CrdtSgmtIsAddedToMainSgmt
FROM I_OperationalAcctgDocItem AS _AccountingDocument
INNER JOIN I_Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_CreditExposureCategory AS _CreditExposureCategory ON CreditExposureCategory = _CreditExposureCategory.CreditExposureCategory  -- association [1..1]
LEFT OUTER JOIN I_CrdtMgmtGLAccountExclusion AS _ExcludedGL ON _AccountingDocument.GLAccount = _ExcludedGL.GLAccount AND _AccountingDocument.CompanyCode = _ExcludedGL.CompanyCode  -- association [0..1]
;