ESH_N_CAWRITEOFF

DDL: ESH_N_CAWRITEOFF SQL: ESH_L_CAWRITEOFD Type: view
23 Fields 1 Data Sources 1 Associations

ESH_N_CAWRITEOFF is a CDS View in SAP S/4HANA. It reads from 1 data source (P_CAWRITEOFFENTERPRISESEARCH) and exposes 23 fields with key fields CABPITEMNUMBER, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, CAWRITEOFFDOCUMENTNUMBER. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CAWRITEOFFENTERPRISESEARCH P_CAWRITEOFFENTERPRISESEARCH from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _INDICATOR $projection.CAWriteOffIsReversed=_INDICATOR.domvalue_l and _INDICATOR.domname='XFELD' and _INDICATOR.as4local='A'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_CAWRITEOFD view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CABPITEMNUMBER CABPITEMNUMBER Item
KEY CADOCUMENTNUMBER CADOCUMENTNUMBER Document Number
KEY CAREPETITIONITEMNUMBER CAREPETITIONITEMNUMBER Repetition Item
KEY CASUBITEMNUMBER CASUBITEMNUMBER Subitem
KEY CAWRITEOFFDOCUMENTNUMBER CAWRITEOFFDOCUMENTNUMBER
KEY COMPANYCODE COMPANYCODE Receiver Company Code
BUSINESSAREA BUSINESSAREA Business Area
BUSINESSPARTNER BUSINESSPARTNER Issuing Authority
CAAMOUNTINTRANSACTIONCURRENCY CAAMOUNTINTRANSACTIONCURRENCY Amount
CCAAUTHORIZATIONGROUP _CAPARTNER CAAUTHORIZATIONGROUP AuthorizGroup
CAAUTHORIZATIONGROUP CAAUTHORIZATIONGROUP AuthorizGroup
CADOCUMENTORIGINCODE CADOCUMENTORIGINCODE Document Origin
CADOCUMENTORIGINCODENAME
CAWRITEOFFDATE CAWRITEOFFDATE
CAWRITEOFFISREVERSED CAWRITEOFFISREVERSED
CAWRITEOFFREASON CAWRITEOFFREASON
CAWRITEOFFREASONNAME
COMPANYCODENAME _COMPCODE COMPANYCODENAME Company Name
CONTRACTACCOUNT CONTRACTACCOUNT Contract Acct
CREATEDBYUSER _BUSINESSPARTNER CREATEDBYUSER User Name
INDICATORTEXT
SEGMENT SEGMENT Segment number
TRANSACTIONCURRENCY TRANSACTIONCURRENCY Transaction Currency

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

CREATE VIEW ESH_N_CAWRITEOFF AS
SELECT
  CABPITEMNUMBER,
  CADOCUMENTNUMBER,
  CAREPETITIONITEMNUMBER,
  CASUBITEMNUMBER,
  CAWRITEOFFDOCUMENTNUMBER,
  COMPANYCODE,
  BUSINESSAREA,
  BUSINESSPARTNER,
  CAAMOUNTINTRANSACTIONCURRENCY,
  _CAPARTNER.CAAUTHORIZATIONGROUP AS CCAAUTHORIZATIONGROUP,
  CAAUTHORIZATIONGROUP,
  CADOCUMENTORIGINCODE,
  _DOCORIGINCODE._TEXT[1: LANGUAGE = $parameters. P_Language].CADOCUMENTORIGINCODENAME AS CADOCUMENTORIGINCODENAME,
  CAWRITEOFFDATE,
  CAWRITEOFFISREVERSED,
  CAWRITEOFFREASON,
  _WRITEOFFREASON._TEXT[1: LANGUAGE = $parameters. P_Language].CAWRITEOFFREASONNAME AS CAWRITEOFFREASONNAME,
  _COMPCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CONTRACTACCOUNT,
  _BUSINESSPARTNER.CREATEDBYUSER AS CREATEDBYUSER,
  _INDICATOR[1: ddlanguage = $parameters. P_Language].ddtext AS INDICATORTEXT,
  SEGMENT,
  TRANSACTIONCURRENCY
FROM P_CAWRITEOFFENTERPRISESEARCH
LEFT OUTER JOIN dd07t AS _INDICATOR ON CAWriteOffIsReversed=_INDICATOR.domvalue_l AND _INDICATOR.domname='XFELD' AND _INDICATOR.as4local='A'  -- association [0..*]
;

Learn More