R_StockTransportOrderPartner

DDL: R_STOCKTRANSPORTORDERPARTNER Type: view_entity BASIC Package: VDM_MM_STO

Partner for Stock Transport Order

R_StockTransportOrderPartner is a Basic CDS View that provides data about "Partner for Stock Transport Order" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentPartner, R_StockTransportOrder) and exposes 22 fields with key fields StockTransportOrder, PartnerFunction. Part of development package VDM_MM_STO.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentPartner Partner from
R_StockTransportOrder StockTransportOrder inner

Annotations (9)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey PartnerFunction view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Partner for Stock Transport Order view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder
KEY PartnerFunction
SupplierSubrange I_PurchasingDocumentPartner SupplierSubrange
Plant I_PurchasingDocumentPartner Plant
PurchasingOrganization I_PurchasingDocumentPartner PurchasingOrganization
PartnerCounter I_PurchasingDocumentPartner PartnerCounter
CreatedByUser I_PurchasingDocumentPartner CreatedByUser
CreationDate I_PurchasingDocumentPartner CreationDate
PurchasingDocumentPartnerType I_PurchasingDocumentPartner PurchasingDocumentPartnerType
Supplier I_PurchasingDocumentPartner Supplier
SupplierHierarchyCategory I_PurchasingDocumentPartner SupplierHierarchyCategory
SupplierContact I_PurchasingDocumentPartner SupplierContact
PersonWorkAgreement I_PurchasingDocumentPartner PersonWorkAgreement
DefaultPartner I_PurchasingDocumentPartner DefaultPartner
_StockTransportOrder _StockTransportOrder
_PurchasingOrganization I_PurchasingDocumentPartner _PurchasingOrganization
_Plant I_PurchasingDocumentPartner _Plant
_PartnerFunction I_PurchasingDocumentPartner _PartnerFunction
_PartnerFunctionText I_PurchasingDocumentPartner _PartnerFunctionText
_Supplier I_PurchasingDocumentPartner _Supplier
_SupplierContact I_PurchasingDocumentPartner _SupplierContact
_PersonWorkAgreement I_PurchasingDocumentPartner _PersonWorkAgreement
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #BASIC
}

@ObjectModel: {
  usageType: {
    dataClass:      #TRANSACTIONAL,
    serviceQuality: #B,
    sizeCategory:   #L
  },

  representativeKey: 'PartnerFunction'
}

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}

@EndUserText.label: 'Partner for Stock Transport Order'

define view entity R_StockTransportOrderPartner
  as select from I_PurchasingDocumentPartner as Partner
    inner join   R_StockTransportOrder       as StockTransportOrder on Partner.PurchasingDocument = StockTransportOrder.StockTransportOrder
    
  association to one R_StockTransportOrder as _StockTransportOrder on $projection.StockTransportOrder = _StockTransportOrder.StockTransportOrder
{
       //Key

       @ObjectModel.foreignKey.association: '_StockTransportOrder'
  key  cast(Partner.PurchasingDocument as vdm_stocktransportorder preserving type) as StockTransportOrder,

  key  cast(Partner.PartnerFunction as parvw_unv preserving type)                  as PartnerFunction,

       Partner.SupplierSubrange,

       Partner.Plant,

       Partner.PurchasingOrganization,

       Partner.PartnerCounter,

       Partner.CreatedByUser,

       Partner.CreationDate,

       Partner.PurchasingDocumentPartnerType, // transient


       Partner.Supplier,

       Partner.SupplierHierarchyCategory,

       Partner.SupplierContact,

       Partner.PersonWorkAgreement,

       Partner.DefaultPartner, // default for a particular Partner function, checkbox on Partner tab in ME21N



       // Associations

       _StockTransportOrder,
       Partner._PurchasingOrganization,
       Partner._Plant,
       Partner._PartnerFunction,
       Partner._PartnerFunctionText,
       Partner._Supplier,
       Partner._SupplierContact,
       Partner._PersonWorkAgreement
}
where
  Partner.PurchasingDocumentItem = '00000'