Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

Srf_Ushlp1042intdtl

DDL: SRF_USHLP1042INTDTL SQL: SRFUSHLP1042INT Type: view

Intermediary details for 1042s

Srf_Ushlp1042intdtl is a CDS View that provides data about "Intermediary details for 1042s" in SAP S/4HANA. It reads from 1 data source (fiwtus_int_1042s) and exposes 10 fields with key field IntermediatryID.

Data Sources (1)

SourceAliasJoin Type
fiwtus_int_1042s fiwtus_int_1042s from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SRFUSHLP1042INT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Intermediary details for 1042s view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.status #DEPRECATED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY IntermediatryID fiwtus_int_id Intermediary ID
IntermediatryEIN fiwtus_ein_num Intermediary Ent EIN
Intermediatrychap3status fiwtus_c3_s_cd Status Code
Intermediatrychap4status fiwtus_c4_s_cd Chap 4 Status CD
IntermediatryName fiwtus_int_name Int. Entity
IntermediatryGIIN fiwtus_int_giin Intermediary GIIN
IntermediatryCountryCode fiwtus_c_code Country Code
IntermediatryTaxNumber fiwtus_f_tin Forg. Tax Id No.
IntermediatryAddress1 fiwtus_address1 Address 1
IntermediatryAddress2 fiwtus_address2 Address 2

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 Srf_Ushlp1042intdtl.
-- 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: SRFUSHLP1042INT

CREATE VIEW Srf_Ushlp1042intdtl AS
SELECT
  fiwtus_int_id AS IntermediatryID,
  fiwtus_ein_num AS IntermediatryEIN,
  fiwtus_c3_s_cd AS Intermediatrychap3status,
  fiwtus_c4_s_cd AS Intermediatrychap4status,
  fiwtus_int_name AS IntermediatryName,
  fiwtus_int_giin AS IntermediatryGIIN,
  fiwtus_c_code AS IntermediatryCountryCode,
  fiwtus_f_tin AS IntermediatryTaxNumber,
  fiwtus_address1 AS IntermediatryAddress1,
  fiwtus_address2 AS IntermediatryAddress2
FROM fiwtus_int_1042s
;