R_RevenueAccountingContractTP

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 R_RevenueAccountingContractTP.
-- 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.

CREATE VIEW R_RevenueAccountingContractTP AS
SELECT
  Contract.RevenueAccountingContract AS RevenueAccountingContract,
  Contract.CompanyCode AS CompanyCode,
  Contract.AccountingPrinciple AS AccountingPrinciple,
  Contract.BusinessPartner AS BusinessPartner,
  Contract.Customer AS Customer,
  Contract.RevnAcctgContractDescription AS RevnAcctgContractDescription,
  Contract.RevnAcctgContractCategory AS RevnAcctgContractCategory,
  Contract.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  Contract.TotContractualPrcInSlsDocCrcy AS TotContractualPrcInSlsDocCrcy,
  Contract.AllocEffctAmountInSalesDocCrcy AS AllocEffctAmountInSalesDocCrcy,
  cast ( 0 as farr_cds_contr_to_be_allcd_amt ) AS ContrToBeAllcdAmtInSlsDocCrcy,
  Contract.RAContractHasAllocationEffect AS RAContractHasAllocationEffect,
  Contract.SalesDocumentCurrency AS SalesDocumentCurrency,
  Contract.RevnAcctgContractStatus AS RevnAcctgContractStatus,
  Contract.NumberOfPerformanceObligations AS NumberOfPerformanceObligations,
  Contract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  Contract.RevnAcctgContractCreatedByUser AS RevnAcctgContractCreatedByUser,
  Contract._CreatedByUser.UserDescription AS CreatedByUserDescription,
  Contract.RAContractLastSavedDateTime AS RAContractLastSavedDateTime,
  Contract.RAContractIsManuallyAllocated AS RAContractIsManuallyAllocated,
  Contract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  Contract.RAContractCompletionDate AS RAContractCompletionDate,
  Contract.RAContractLastChangedByUsr AS RAContractLastChangedByUsr,
  Contract.RAContractLastChangeDate AS RAContractLastChangeDate,
  cast (' ' as farr_manual_changed ) AS RAContractIsSetToSystemAlloc,
  Contract.RAContrHasMnlPrcAllocConflict AS RAContrHasMnlPrcAllocConflict,
  cast (coalesce(ContractWithAttribConflict.RAAttributeHasConflict, '') as farr_attr_conflict preserving type ) AS RAAttributeHasConflict,
  cast (coalesce(ContractWithSpreadingConflict.PerfOblgnHasSprdgConflict, '') as farr_spread_conflict preserving type ) AS PerfOblgnHasSprdgConflict,
  Contract.RAContractHasAssetsImpairment AS RAContractHasAssetsImpairment,
  Contract.RAContractIsUniversal AS RAContractIsUniversal,
  Contract._Customer AS _Customer,
  Contract._SalesOrganization AS _SalesOrganization,
  Contract._AccountingPrinciple AS _AccountingPrinciple,
  Contract._CompanyCode AS _CompanyCode,
  Contract._BusinessPartner AS _BusinessPartner,
  Contract.RAContractVersionCode AS RAContractVersionCode
FROM I_RevenueAccountingContract AS Contract
LEFT OUTER JOIN I_RAContractStatusText AS _RAContractStatusText ON RevnAcctgContractStatus = _RAContractStatusText.RevnAcctgContractStatus  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON RevnAcctgContractCreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RAPerformanceObligationTP AS _PerformanceObligation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RAContrMappgOplDocTP AS _Mapping ON /* condition not available in parsed metadata */  -- association [0..*]
;