I_StockTransportOrder

DDL: I_STOCKTRANSPORTORDER SQL: ISTOCKHEADER Type: view BASIC

Stock Transport Order

I_StockTransportOrder is a Basic CDS View that provides data about "Stock Transport Order" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrder) and exposes 41 fields with key field PurchaseOrder. It has 2 associations to related views.

1 data source(s) 41 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrder I_PurchaseOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_StockTransportOrderItem _StockTransportOrderItem $projection.PurchaseOrder = _StockTransportOrderItem.PurchaseOrder
[1..1] E_PurchasingDocument _PurchaseOrderExtension $projection.PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISTOCKHEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Stock Transport Order view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey PurchaseOrder view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder
PurchaseOrderType PurchaseOrderType
PurchaseOrderSubtype PurchaseOrderSubtype
CreatedByUser CreatedByUser
CreationDate CreationDate
PurchaseOrderDate PurchaseOrderDate
Language Language
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
ReleaseIsNotCompleted ReleaseIsNotCompleted
CompanyCode CompanyCode
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
Supplier Supplier
ManualSupplierAddressID ManualSupplierAddressID
SupplierAddressID SupplierAddressID
SupplierRespSalesPersonName SupplierRespSalesPersonName
SupplierPhoneNumber SupplierPhoneNumber
SupplyingSupplier SupplyingSupplier
SupplyingPlant SupplyingPlant
InvoicingParty InvoicingParty
PaymentTerms PaymentTerms
PurchasingDocumentCondition PurchasingDocumentCondition
PricingProcedure PricingProcedure
DocumentCurrency DocumentCurrency
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
ExchangeRate ExchangeRate
ExchangeRateIsFixed ExchangeRateIsFixed
LastChangeDateTime LastChangeDateTime
_StockTransportOrderItem _StockTransportOrderItem
_PurchaseOrderType _PurchaseOrderType
_CompanyCode _CompanyCode
_CreatedByUser _CreatedByUser
_Supplier _Supplier
_SupplyingSupplier _SupplyingSupplier
_InvoicingParty _InvoicingParty
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_DocumentCurrency _DocumentCurrency
_SupplyingPlant _SupplyingPlant
_Language _Language 
@AbapCatalog.sqlViewName: 'ISTOCKHEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Stock Transport Order'
@VDM.viewType : #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.compositionRoot:true
@ObjectModel.representativeKey: 'PurchaseOrder'
@ObjectModel.supportedCapabilities: [ #SEARCHABLE_ENTITY, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true

define view I_StockTransportOrder as select from I_PurchaseOrder

association [0..*] to I_StockTransportOrderItem as _StockTransportOrderItem on  $projection.PurchaseOrder = _StockTransportOrderItem.PurchaseOrder

association [1..1] to E_PurchasingDocument           as _PurchaseOrderExtension  on  $projection.PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument

{
  key cast (PurchaseOrder as vdm_stocktransportorder preserving type) as PurchaseOrder,
  @ObjectModel.foreignKey.association: '_PurchaseOrderType'
  PurchaseOrderType,
  PurchaseOrderSubtype,
  CreatedByUser,
  CreationDate,
  PurchaseOrderDate,
  @ObjectModel.foreignKey.association: '_Language'
  Language,
  PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  @ObjectModel.foreignKey.association: '_CompanyCode'
  CompanyCode,
  @ObjectModel.foreignKey.association: '_PurchasingOrganization'
  PurchasingOrganization,
  @ObjectModel.foreignKey.association: '_PurchasingGroup'
  PurchasingGroup,
  @ObjectModel.foreignKey.association: '_Supplier'
  Supplier,
  ManualSupplierAddressID,
  SupplierAddressID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  @ObjectModel.foreignKey.association: '_SupplyingSupplier'
  SupplyingSupplier,
  @ObjectModel.foreignKey.association: '_SupplyingPlant'
  SupplyingPlant,
  @ObjectModel.foreignKey.association: '_InvoicingParty'
  InvoicingParty,
  PaymentTerms,
  PurchasingDocumentCondition,
  PricingProcedure,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  ExchangeRate,
  ExchangeRateIsFixed,
  LastChangeDateTime,
  
  @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
  _StockTransportOrderItem,
  
  _PurchaseOrderType,
  _CompanyCode,
  _CreatedByUser,
  _Supplier,
  _SupplyingSupplier,
  _InvoicingParty,
  _PurchasingOrganization,
  _PurchasingGroup,
  _DocumentCurrency,
  _SupplyingPlant,
  _Language
}

where SupplyingPlant <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER"
],
"ASSOCIATED":
[
"E_PURCHASINGDOCUMENT",
"I_COMPANYCODE",
"I_CURRENCY",
"I_LANGUAGE",
"I_PLANT",
"I_PURCHASINGDOCUMENTTYPE",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_STOCKTRANSPORTORDERITEM",
"I_SUPPLIER",
"I_USER"
],
"BASE":
[
"I_PURCHASEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More