I_SupplierListTP_2

DDL: I_SUPPLIERLISTTP_2 Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources

Supplier List - TP

I_SupplierListTP_2 is a Transactional CDS View that provides data about "Supplier List - TP" in SAP S/4HANA. It reads from 1 data source (R_SupplierListTP) and exposes 18 fields with key field SupplierListUUID.

Data Sources (1)

SourceAliasJoin Type
R_SupplierListTP R_SupplierListTP projection

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SupplierListUUID view
ObjectModel.sapObjectNodeType.name SupplierList view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Supplier List - TP view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SLH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SupplierListUUID SupplierListUUID Supplier List UUID
SupplierList SupplierList Supplier Selection
SupplierListVersion SupplierListVersion Suplr List Version
SupplierListType SupplierListType Supplier List Type
SupplierListName SupplierListName Supplier List Name
SuplrListLifecycleStatus SuplrListLifecycleStatus SL Lifecycle Status
PurchaserRespWorkAgreement PurchaserRespWorkAgreement Purchaser Responsible
PurchaserResponsibleUser PurchaserResponsibleUser Purchaser Resp
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
SupplierListIsLatest SupplierListIsLatest Latest Supplier List
IsDeleted IsDeleted TRUE
SupplierListIsPublic SupplierListIsPublic Is Public
SupplierListHasAllCompanyCodes SupplierListHasAllCompanyCodes SL Company Codes
SuplrListHasPurchasingCategory SuplrListHasPurchasingCategory
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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 I_SupplierListTP_2.
-- 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 I_SupplierListTP_2 AS
SELECT
  SupplierListUUID,
  SupplierList,
  SupplierListVersion,
  SupplierListType,
  SupplierListName,
  SuplrListLifecycleStatus,
  PurchaserRespWorkAgreement,
  PurchaserResponsibleUser,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  SupplierListIsLatest,
  IsDeleted,
  SupplierListIsPublic,
  SupplierListHasAllCompanyCodes,
  SuplrListHasPurchasingCategory,
  IsEndOfPurposeBlocked
FROM R_SupplierListTP
;

Learn More