I_BPSupplierPurchasingOrgTxtTP

DDL: I_BPSUPPLIERPURCHASINGORGTXTTP SQL: IBPSUPLRPOTXTTP Type: view TRANSACTIONAL

Supplier Purchasing Org LongText TP

I_BPSupplierPurchasingOrgTxtTP is a Transactional CDS View that provides data about "Supplier Purchasing Org LongText TP" in SAP S/4HANA. It reads from 1 data source (P_SupplierPurchasingOrgText) and exposes 12 fields with key fields BusinessPartner, PurchasingOrganization, Language, LongTextID, Supplier. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
P_SupplierPurchasingOrgText P_SupplierPurchasingOrgText from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerPurgOrgTP _BusinessPartnerPurgOrg $projection.PurchasingOrganization = _BusinessPartnerPurgOrg.PurchasingOrganization and $projection.BusinessPartner = _BusinessPartnerPurgOrg.BusinessPartner
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IBPSUPLRPOTXTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Purchasing Org LongText TP view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence SUPLRPO_TEXT_D view
ObjectModel.draftEnabled true 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 #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY PurchasingOrganization PurchasingOrganization
KEY Language Language
KEY LongTextID LongTextID
KEY Supplier Supplier
LongText LongText
BusinessPartnerForEdit
PurchasingOrganizationForEdit PurchasingOrganization
LongTextIDForEdit LongTextID
LanguageForEdit Language
_BusinessPartner _BusinessPartner
_BusinessPartnerPurgOrg _BusinessPartnerPurgOrg 
@AbapCatalog.sqlViewName: 'IBPSUPLRPOTXTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Supplier Purchasing Org LongText TP'
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType:#TRANSACTIONAL

@ObjectModel: {
  writeDraftPersistence: 'SUPLRPO_TEXT_D',  
  draftEnabled:true,
  semanticKey:           ['BusinessPartner','PurchasingOrganization','Language','LongTextID'],
  createEnabled:        true,
  deleteEnabled:        true,
  updateEnabled:        true,
  usageType.serviceQuality: #B,
  usageType.sizeCategory : #L,
  usageType.dataClass: #TRANSACTIONAL
}
define view I_BPSupplierPurchasingOrgTxtTP as select from P_SupplierPurchasingOrgText
association [1..1] to I_BusinessPartnerPurgOrgTP    as _BusinessPartnerPurgOrg           on $projection.PurchasingOrganization = _BusinessPartnerPurgOrg.PurchasingOrganization
                                                                                    and $projection.BusinessPartner =  _BusinessPartnerPurgOrg.BusinessPartner
association [1..1] to I_BusinessPartnerTP           as _BusinessPartner          on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

{

key _SupplierToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartner,
key PurchasingOrganization,
key Language,
key LongTextID,
key Supplier,
LongText,


_SupplierToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartnerForEdit,
PurchasingOrganization as PurchasingOrganizationForEdit,
LongTextID as LongTextIDForEdit,
Language as LanguageForEdit,


@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
_BusinessPartner,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]    
_BusinessPartnerPurgOrg // Make association public


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_SUPPLIER_TO_BUSINESSPARTNER",
"P_SUPPLIERPURCHASINGORGTEXT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERPURGORGTP",
"I_BUSINESSPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More