ESH_N_PEROBLIGN

DDL: ESH_N_PEROBLIGN Type: view_entity Package: BSESH_FI_RA
23 Fields 1 Data Sources 3 Associations

Anchor view -PEROBLIGN

ESH_N_PEROBLIGN is a CDS View that provides data about "Anchor view -PEROBLIGN" in SAP S/4HANA. It reads from 1 data source (I_RAPERFORMANCEOBLIGATION) and exposes 23 fields with key field PERFORMANCEOBLIGATION. It has 3 associations to related views. Part of development package BSESH_FI_RA.

Data Sources (1)

SourceAliasJoin Type
I_RAPERFORMANCEOBLIGATION I_RAPERFORMANCEOBLIGATION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (3)

CardinalityTargetAliasCondition
[0..*] dd07t _INDICATORMANUALLYCHGD $projection.RAPerfOblgnIsManuallyChanged=_INDICATORMANUALLYCHGD.domvalue_l and _INDICATORMANUALLYCHGD.domname='XFELD' and _INDICATORMANUALLYCHGD.as4local='A'
[0..*] dd07t _FULFILLMENTTYPE ( $projection.PerfOblgnFulfillmentType=_FULFILLMENTTYPE.domvalue_l AND _FULFILLMENTTYPE.domname='FARR_FULFILL_TYPE' AND _FULFILLMENTTYPE.as4local='A' )
[0..*] dd07t _RAPERFOBLGNSTATUS ( $projection.RevnAcctgPerfOblgnStatus=_RAPERFOBLGNSTATUS.domvalue_l AND _RAPERFOBLGNSTATUS.domname='FARR_POB_STATUS' AND _RAPERFOBLGNSTATUS.as4local='A' )

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PERFORMANCEOBLIGATION PERFORMANCEOBLIGATION Performance Obligation
ACCOUNTINGPRINCIPLE ACCOUNTINGPRINCIPLE AP Ledger/CoCode
BUSINESSPARTNER BUSINESSPARTNER Issuing Authority
COMPANYCODE COMPANYCODE Receiver Company Code
CONTRACTUALPRCINSLSDOCCRCY CONTRACTUALPRCINSLSDOCCRCY Contractual Price
CUSTOMER CUSTOMER Sold-to Party
INDICATORTEXT
PERFOBLGNCREATEDBYUSER PERFOBLGNCREATEDBYUSER Created By
PERFOBLGNCREATIONDATE PERFOBLGNCREATIONDATE Created On
PERFOBLGNEVENTTYPE PERFOBLGNEVENTTYPE Event Type
PERFOBLGNEVENTTYPETEXT
PERFOBLGNFULFILLMENTTYPE PERFOBLGNFULFILLMENTTYPE Fulfillment Type
PERFOBLGNFULFILLMENTTYPENAME
PERFOBLGNLASTCHANGEDATE PERFOBLGNLASTCHANGEDATE Changed on
PERFOBLGNLASTCHANGEDBYUSR PERFOBLGNLASTCHANGEDBYUSR Last Changed By
PERFORMANCEOBLIGATIONCLASS PERFORMANCEOBLIGATIONCLASS Performance Obligation Name
RAPERFOBLGNISMANUALLYCHANGED RAPERFOBLGNISMANUALLYCHANGED Manual Changed
RAPERFORMANCEOBLIGATIONTYPE RAPERFORMANCEOBLIGATIONTYPE Performance Obligation Type
REVENUEACCOUNTINGCONTRACT REVENUEACCOUNTINGCONTRACT Revenue Contract
REVNACCTGPERFOBLGNSTATUS REVNACCTGPERFOBLGNSTATUS Perf. Oblig. Status
REVNACCTGPERFOBLGNSTATUSNAME
SALESDOCUMENTCURRENCY SALESDOCUMENTCURRENCY Currency
SSPRICEINSALESDOCCRCY SSPRICEINSALESDOCCRCY Standalone Selling Price

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 ESH_N_PEROBLIGN.
-- 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.
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_PEROBLIGN AS
SELECT
  PERFORMANCEOBLIGATION,
  ACCOUNTINGPRINCIPLE,
  BUSINESSPARTNER,
  COMPANYCODE,
  CONTRACTUALPRCINSLSDOCCRCY,
  CUSTOMER,
  _INDICATORMANUALLYCHGD[1: ddlanguage = $parameters. P_Language].ddtext AS INDICATORTEXT,
  PERFOBLGNCREATEDBYUSER,
  PERFOBLGNCREATIONDATE,
  PERFOBLGNEVENTTYPE,
  _PERFOBLIGATIONEVENTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].PERFOBLGNEVENTTYPETEXT AS PERFOBLGNEVENTTYPETEXT,
  PERFOBLGNFULFILLMENTTYPE,
  _FULFILLMENTTYPE[1: ddlanguage = $parameters. P_Language].ddtext AS PERFOBLGNFULFILLMENTTYPENAME,
  PERFOBLGNLASTCHANGEDATE,
  PERFOBLGNLASTCHANGEDBYUSR,
  PERFORMANCEOBLIGATIONCLASS,
  RAPERFOBLGNISMANUALLYCHANGED,
  RAPERFORMANCEOBLIGATIONTYPE,
  REVENUEACCOUNTINGCONTRACT,
  REVNACCTGPERFOBLGNSTATUS,
  _RAPERFOBLGNSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS REVNACCTGPERFOBLGNSTATUSNAME,
  SALESDOCUMENTCURRENCY,
  SSPRICEINSALESDOCCRCY
FROM I_RAPERFORMANCEOBLIGATION
LEFT OUTER JOIN dd07t AS _INDICATORMANUALLYCHGD ON RAPerfOblgnIsManuallyChanged=_INDICATORMANUALLYCHGD.domvalue_l AND _INDICATORMANUALLYCHGD.domname='XFELD' AND _INDICATORMANUALLYCHGD.as4local='A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS _FULFILLMENTTYPE ON ( PerfOblgnFulfillmentType=_FULFILLMENTTYPE.domvalue_l AND _FULFILLMENTTYPE.domname='FARR_FULFILL_TYPE' AND _FULFILLMENTTYPE.as4local='A' )  -- association [0..*]
LEFT OUTER JOIN dd07t AS _RAPERFOBLGNSTATUS ON ( RevnAcctgPerfOblgnStatus=_RAPERFOBLGNSTATUS.domvalue_l AND _RAPERFOBLGNSTATUS.domname='FARR_POB_STATUS' AND _RAPERFOBLGNSTATUS.as4local='A' )  -- association [0..*]
;

Learn More