R_StockTransportOrderTP

DDL: R_STOCKTRANSPORTORDERTP Type: view_entity TRANSACTIONAL Package: RAP_MM_STO
44 Fields 1 Data Sources 3 Associations

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.

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 STO Number
StockTransportOrderType StockTransportOrderType Document Type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
StockTransportOrderDate StockTransportOrderDate Document Date
LastChangeDateTime LastChangeDateTime Timestamp
Language Language Report Text Language
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
ReleaseIsNotCompleted ReleaseIsNotCompleted Subj.to Release
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Supplier Supplier Supplier
SupplierRespSalesPersonName SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber SupplierPhoneNumber Telephone
SupplyingPlant SupplyingPlant Supplying Plant
DocumentCurrency DocumentCurrency Document Currency
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsVersion IncotermsVersion Inco. Version
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IsIntrastatReportingRelevant IsIntrastatReportingRelevant Intrastat rel.
IsIntrastatReportingExcluded IsIntrastatReportingExcluded exclude Intra
VATRegistrationCountry VATRegistrationCountry CtryRgnSlsTxNo.
Customer Customer Sold-to Party
ManualSupplierAddressID ManualSupplierAddressID Address Number
CustomerAddressID
PlantAddressID _SupplyingPlant AddressID Ship-to address
SupplierAddressID _Supplier AddressID Ship-to address
PurchasingDocumentProcessCode PurchasingDocumentProcessCode Process Indicator
_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

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 R_StockTransportOrderTP.
-- 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.

CREATE VIEW R_StockTransportOrderTP AS
SELECT
  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,
  Customer,
  ManualSupplierAddressID,
  cast(_CustomerAddress.AddressID as BT_CustomerAddressID preserving type) AS CustomerAddressID,
  _SupplyingPlant.AddressID AS PlantAddressID,
  _Supplier.AddressID AS SupplierAddressID,
  PurchasingDocumentProcessCode
FROM R_StockTransportOrder AS StockTransportOrder
LEFT OUTER JOIN R_StockTransportOrderItemTP AS _StockTransportOrderItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_StockTransportOrderNoteTP AS _StockTransportOrderNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_StockTransportOrderPartnerTP AS _StockTransportOrderPartner ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More