P_SUPPLIERPURCHASINGORGTEXT

CDS View

P_SUPPLIERPURCHASINGORGTEXT is a CDS View in S/4HANA. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_SupplierPurchasingOrgText view from COMPOSITE Purchasing Organization Text
I_BPSupplierPurchasingOrgTxtTP view from TRANSACTIONAL Supplier Purchasing Org LongText TP

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Language Language 1
KEY Supplier Supplier 1 
@AbapCatalog.sqlViewName: 'PSUPPPOTEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
//@AccessControl.authorizationCheck: #CHECK

//@EndUserText.label: 'Supplier Purchasing Org Long Text View'

@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm:#SESSION_VARIABLE

define view P_SupplierPurchasingOrgText as select from R_TextObjectEmptyText
association [1..1] to I_Supplier_to_BusinessPartner as _SupplierToBusinessPartner 
    on $projection.Supplier = _SupplierToBusinessPartner.Supplier {
//R_TextObjectEmptyText

key TextObjectCategory,
key TextObjectType as LongTextID,
key TextObjectKey,
key Language,
PlainLongText as LongText,
cast(substring(TextObjectKey,1,10) as lifnr) as Supplier,
cast(substring(TextObjectKey,11,4) as ekorg) as PurchasingOrganization,

_SupplierToBusinessPartner 
}
where TextObjectCategory = 'LFM1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_TEXTOBJECTEMPTYTEXT"
],
"ASSOCIATED":
[
"I_SUPPLIER_TO_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More