R_StockTransportOrderTP

DDL: R_STOCKTRANSPORTORDERTP Type: view_entity TRANSACTIONAL Package: RAP_MM_STO

Stock Transport Order - TP

R_StockTransportOrderTP is a Transactional CDS View that provides data about "Stock Transport Order - TP" in SAP S/4HANA. It reads from 1 data source (R_StockTransportOrder) and exposes 44 fields with key field StockTransportOrder. It has 3 associations to related views. Part of development package RAP_MM_STO.

1 data source(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
R_StockTransportOrder StockTransportOrder from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_StockTransportOrderItemTP _StockTransportOrderItem
[0..*] R_StockTransportOrderNoteTP _StockTransportOrderNote
[0..*] R_StockTransportOrderPartnerTP _StockTransportOrderPartner

Annotations (11)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name StockTransportOrder view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey StockTransportOrder view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Stock Transport Order - TP view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder StockTransportOrder
StockTransportOrderType StockTransportOrderType
CreatedByUser CreatedByUser
CreationDate CreationDate
StockTransportOrderDate StockTransportOrderDate
LastChangeDateTime LastChangeDateTime
Language Language
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
ReleaseIsNotCompleted ReleaseIsNotCompleted
CompanyCode CompanyCode
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
Supplier Supplier
SupplierRespSalesPersonName SupplierRespSalesPersonName
SupplierPhoneNumber SupplierPhoneNumber
SupplyingPlant SupplyingPlant
DocumentCurrency DocumentCurrency
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsVersion IncotermsVersion
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
IsIntrastatReportingRelevant IsIntrastatReportingRelevant
IsIntrastatReportingExcluded IsIntrastatReportingExcluded
VATRegistrationCountry VATRegistrationCountry
Customer Customer
ManualSupplierAddressID ManualSupplierAddressID
CustomerAddressID
PlantAddressID _SupplyingPlant AddressID
SupplierAddressID _Supplier AddressID
PurchasingDocumentProcessCode PurchasingDocumentProcessCode
_CompanyCode _CompanyCode
_CreatedByUser _CreatedByUser
_DocumentCurrency _DocumentCurrency
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion
_Language _Language
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_Supplier _Supplier
_SupplyingPlant _SupplyingPlant
_StockTransportOrderItem _StockTransportOrderItem
_StockTransportOrderNote _StockTransportOrderNote
_StockTransportOrderPartner _StockTransportOrderPartner 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@ObjectModel: {
   sapObjectNodeType: {
     name: 'StockTransportOrder'
   },

   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   },

   representativeKey: 'StockTransportOrder',
   modelingPattern: #TRANSACTIONAL_INTERFACE,
   supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
   semanticKey: ['StockTransportOrder']
 }

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

@EndUserText.label: 'Stock Transport Order - TP'

define root view entity R_StockTransportOrderTP
  as select from R_StockTransportOrder as StockTransportOrder
  composition [0..*] of R_StockTransportOrderItemTP as _StockTransportOrderItem
  composition [0..*] of R_StockTransportOrderNoteTP as _StockTransportOrderNote
  composition [0..*] of R_StockTransportOrderPartnerTP as _StockTransportOrderPartner
  
  association to one I_Customer                 as _CustomerAddress         on $projection.Customer = _CustomerAddress.Customer
  --Extension Association
  association to exact one E_PurchasingDocument        as _StockTransportOrderExtension on $projection.StockTransportOrder = _StockTransportOrderExtension.PurchasingDocument

{
  key StockTransportOrder,
      StockTransportOrderType,
      CreatedByUser,
      CreationDate,
      StockTransportOrderDate,
      LastChangeDateTime,
      Language,
      PurchasingDocumentDeletionCode,
      ReleaseIsNotCompleted,
      CompanyCode,
      PurchasingOrganization,
      PurchasingGroup,
      Supplier,
      SupplierRespSalesPersonName,
      SupplierPhoneNumber,
      SupplyingPlant,
      DocumentCurrency,
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsVersion,
      IncotermsLocation1,
      IncotermsLocation2,
      IsIntrastatReportingRelevant,
      IsIntrastatReportingExcluded,
      VATRegistrationCountry,
      
      // Address handling

      Customer,
      ManualSupplierAddressID,
      cast(_CustomerAddress.AddressID as BT_CustomerAddressID preserving type) as CustomerAddressID,
      _SupplyingPlant.AddressID as PlantAddressID,
      _Supplier.AddressID as SupplierAddressID,
      
      // Process Code will be used at the API level

      PurchasingDocumentProcessCode,

      /* Associations */
      _CompanyCode,
      _CreatedByUser,
      _DocumentCurrency,
      _IncotermsClassification,
      _IncotermsVersion,
      _Language,
      _PurchasingGroup,
      _PurchasingOrganization,
      _Supplier,
      _SupplyingPlant,

      _StockTransportOrderItem,
      _StockTransportOrderNote,
      _StockTransportOrderPartner
      
      /* Text associations for CustomUI */
//      _StockTransportOrderTypeText,

//      _DocumentCurrencyText

}

Learn More