I_StockTransportOrder

DDL: I_STOCKTRANSPORTORDER SQL: ISTOCKHEADER Type: view BASIC
41 Fields 1 Data Sources 2 Associations

Stock Transport Order

I_StockTransportOrder (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

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.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-PO
CapabilitiesData Source for Search, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

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 Stock Transport Order
PurchaseOrderType PurchaseOrderType Purchase Order Type
PurchaseOrderSubtype PurchaseOrderSubtype Control indicator for purchasing document type
CreatedByUser CreatedByUser User of person who created a purchasing document
CreationDate CreationDate Creation Date of Purchasing Document
PurchaseOrderDate PurchaseOrderDate Purchase Order Date
Language Language Report Text Language
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document
ReleaseIsNotCompleted ReleaseIsNotCompleted Release Not Yet Completely Effected
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Supplier Supplier Supplier
ManualSupplierAddressID ManualSupplierAddressID Address Number
SupplierAddressID SupplierAddressID Address Number
SupplierRespSalesPersonName SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office
SupplierPhoneNumber SupplierPhoneNumber Supplier's Phone Number
SupplyingSupplier SupplyingSupplier Goods Supplier
SupplyingPlant SupplyingPlant Supplying (issuing) plant in case of stock transport order
InvoicingParty InvoicingParty Different Invoicing Party
PaymentTerms PaymentTerms Terms of Payment Key
PurchasingDocumentCondition PurchasingDocumentCondition Number of the Document Condition
PricingProcedure PricingProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...)
DocumentCurrency DocumentCurrency Document Currency
ValidityStartDate ValidityStartDate Start of Validity Period
ValidityEndDate ValidityEndDate End of Validity Period
ExchangeRate ExchangeRate Exchange rate
ExchangeRateIsFixed ExchangeRateIsFixed Indicator for Fixed Exchange Rate
LastChangeDateTime LastChangeDateTime Change Time Stamp
_StockTransportOrderItem _StockTransportOrderItem
_PurchaseOrderType _PurchaseOrderType
_CompanyCode _CompanyCode
_CreatedByUser _CreatedByUser
_Supplier _Supplier
_SupplyingSupplier _SupplyingSupplier
_InvoicingParty _InvoicingParty
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_DocumentCurrency _DocumentCurrency
_SupplyingPlant _SupplyingPlant
_Language _Language

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_StockTransportOrder.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISTOCKHEADER

CREATE VIEW I_StockTransportOrder AS
SELECT
  cast (PurchaseOrder as vdm_stocktransportorder preserving type) AS PurchaseOrder,
  PurchaseOrderType,
  PurchaseOrderSubtype,
  CreatedByUser,
  CreationDate,
  PurchaseOrderDate,
  Language,
  PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  ManualSupplierAddressID,
  SupplierAddressID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  PaymentTerms,
  PurchasingDocumentCondition,
  PricingProcedure,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  ExchangeRate,
  ExchangeRateIsFixed,
  LastChangeDateTime
FROM I_PurchaseOrder
LEFT OUTER JOIN I_StockTransportOrderItem AS _StockTransportOrderItem ON PurchaseOrder = _StockTransportOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseOrderExtension ON PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument  -- association [1..1]
;

Learn More