ESH_N_CARETURNDOCUMENT

DDL: ESH_N_CARETURNDOCUMENT SQL: ESH_L_RETRNDOC Type: view Package: FKK_ESH
18 Fields 1 Data Sources

Anchor view -CARETURNDOCUMENT

ESH_N_CARETURNDOCUMENT is a CDS View that provides data about "Anchor view -CARETURNDOCUMENT" in SAP S/4HANA. It reads from 1 data source (N_CARETURNHISTORY) and exposes 18 fields with key fields BUSINESSPARTNER, CARETURNDOCUMENTNUMBER, CONTRACTACCOUNT. Part of development package FKK_ESH.

Data Sources (1)

SourceAliasJoin Type
N_CARETURNHISTORY N_CARETURNHISTORY from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_RETRNDOC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BUSINESSPARTNER BUSINESSPARTNER Issuing Authority
KEY CARETURNDOCUMENTNUMBER CARETURNDOCUMENTNUMBER Returns Doc.
KEY CONTRACTACCOUNT CONTRACTACCOUNT Contract Acct
BUSINESSAREA BUSINESSAREA Business Area
CAAUTHORIZATIONGROUP CAAUTHORIZATIONGROUP AuthorizGroup
CADOCUMENTHASBEENREVERSED CADOCUMENTHASBEENREVERSED
CADOCUMENTHASBEENREVERSEDNAME CADOCUMENTHASBEENREVERSEDNAME
CADOCUMENTNUMBER CADOCUMENTNUMBER Document Number
CAPARTIALAMOUNTOFRETURN CAPARTIALAMOUNTOFRETURN
CAPOSTINGDATE CAPOSTINGDATE Posting Date
CARETURNAMOUNT CARETURNAMOUNT
CARETURNLOT CARETURNLOT
CARETURNREASON CARETURNREASON Return Reason
CARETURNREASONNAME CARETURNREASONNAME
COMPANYCODE COMPANYCODE Receiver Company Code
CONTRACTACCOUNTNAME CONTRACTACCOUNTNAME Cont. acct name
ISBUSINESSPURPOSECOMPLETED ISBUSINESSPURPOSECOMPLETED Purpose Completed
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_CARETURNDOCUMENT.
-- 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_RETRNDOC

CREATE VIEW ESH_N_CARETURNDOCUMENT AS
SELECT
  BUSINESSPARTNER,
  CARETURNDOCUMENTNUMBER,
  CONTRACTACCOUNT,
  BUSINESSAREA,
  CAAUTHORIZATIONGROUP,
  CADOCUMENTHASBEENREVERSED,
  CADOCUMENTHASBEENREVERSEDNAME,
  CADOCUMENTNUMBER,
  CAPARTIALAMOUNTOFRETURN,
  CAPOSTINGDATE,
  CARETURNAMOUNT,
  CARETURNLOT,
  CARETURNREASON,
  CARETURNREASONNAME,
  COMPANYCODE,
  CONTRACTACCOUNTNAME,
  ISBUSINESSPURPOSECOMPLETED,
  TRANSACTIONCURRENCY
FROM N_CARETURNHISTORY
;

Learn More