P_CUSTOMERSALESAREATEXT
Customer Sales Area Text view
P_CUSTOMERSALESAREATEXT is a CDS View in S/4HANA. Customer Sales Area Text view. It contains 5 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_CustomerSalesAreaText | view | from | COMPOSITE | Customer Sales Area Text |
| I_BPSalesAreaTextTP | view | from | TRANSACTIONAL | TP view for Customer SalesArea texts |
Fields (5)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Customer | Customer | 1 |
| KEY | DistributionChannel | DistributionChannel | 1 |
| KEY | Division | Division | 1 |
| KEY | Language | Language | 1 |
| KEY | SalesOrganization | SalesOrganization | 1 |
@AbapCatalog.sqlViewName: 'PCUSTSATEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
//@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Customer Sales Area Text view'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm:#SESSION_VARIABLE
define view P_CustomerSalesAreaText as select from R_TextObjectEmptyText
association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on $projection.Customer = _CustomerToBusinessPartner.Customer
{
key TextObjectCategory,
key TextObjectType as LongTextID,
key TextObjectKey,
key Language,
PlainLongText as LongText,
cast(substring(TextObjectKey,1,10) as kunnr) as Customer,
cast(substring(TextObjectKey,11,4) as vkorg) as SalesOrganization,
cast(substring(TextObjectKey,15,2) as vtweg) as DistributionChannel,
cast(substring(TextObjectKey,17,2) as spart) as Division,
_CustomerToBusinessPartner
}
where TextObjectCategory = 'KNVV'