I_BusinessPartnerSupplierTxtTP

DDL: I_BUSINESSPARTNERSUPPLIERTXTTP SQL: IBPSUPLRTXTTP Type: view TRANSACTIONAL Package: VDM_MD_BP
10 Fields 1 Data Sources 1 Associations

Supplier LongText Transactional

I_BusinessPartnerSupplierTxtTP is a Transactional CDS View that provides data about "Supplier LongText Transactional" in SAP S/4HANA. It reads from 1 data source (P_SupplierText) and exposes 10 fields with key fields BusinessPartner, LongTextID, Language, Supplier. It has 1 association to related views. Part of development package VDM_MD_BP.

Data Sources (1)

SourceAliasJoin Type
P_SupplierText BusinessPartnerSupplierText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IBPSUPLRTXTTP view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence SUPLR_TEXT_D view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey BusinessPartner view
EndUserText.label Supplier LongText Transactional view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY LongTextID LongTextID Text ID
KEY Language Language Report Text Language
KEY Supplier Supplier Supplier
LongText LongText Text Name
BusinessPartnerForEdit BusinessPartner Issuing Authority
LongTextIDForEdit LongTextID Text ID
LanguageForEdit Language Report Text Language
TextObjectCategory TextObjectCategory Text object
_BusinessPartner _BusinessPartner

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_BusinessPartnerSupplierTxtTP.
-- 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: IBPSUPLRTXTTP

CREATE VIEW I_BusinessPartnerSupplierTxtTP AS
SELECT
  BusinessPartner,
  LongTextID,
  Language,
  Supplier,
  LongText,
  BusinessPartner AS BusinessPartnerForEdit,
  LongTextID AS LongTextIDForEdit,
  Language AS LanguageForEdit,
  TextObjectCategory
FROM P_SupplierText AS BusinessPartnerSupplierText
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
;

Learn More