P_SUPPLIERPURCHASINGORGTEXT
Supplier Purchasing Org Long Text View
P_SUPPLIERPURCHASINGORGTEXT is a CDS View in S/4HANA. Supplier Purchasing Org Long Text View. It contains 2 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_SupplierPurchasingOrgText | view | from | COMPOSITE | Purchasing Organization Text |
| I_BPSupplierPurchasingOrgTxtTP | view | from | TRANSACTIONAL | Supplier Purchasing Org LongText TP |
Fields (2)
| Key | Field | CDS Fields | Used 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'