R_SalesOrderRequestSourceTP

DDL: R_SALESORDERREQUESTSOURCETP SQL: RSORSTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_AUTOEXTRN
58 Fields 1 Data Sources 1 Associations

Sales Order Request Source Transactional Processing

R_SalesOrderRequestSourceTP is a Transactional CDS View that provides data about "Sales Order Request Source Transactional Processing" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderRequestSource) and exposes 58 fields with key field SalesOrderRequest. It has 1 association to related views. Part of development package RAP_SD_SLS_AUTOEXTRN.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderRequestSource SalesOrderRequestSource from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_SlsOrdReqSourceImageTP _SourceImage

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.representativeKey SalesOrderRequest view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Sales Order Request Source Transactional Processing view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest SalesOrderRequest Sales Order Request
MasterDataDeterminationStatus MasterDataDeterminationStatus MD Determination Sts
LanguageISOCode LanguageISOCode Language ISO Code
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
CustomerPurchaseOrderDateText CustomerPurchaseOrderDateText
ExtractedRequestedDeliveryDate ExtractedRequestedDeliveryDate Extracted Requested Delivery Date
RequestedDeliveryDateText RequestedDeliveryDateText
CustomerPaymentTermsText CustomerPaymentTermsText Payment Terms
CustomerIncotermsText CustomerIncotermsText Incoterms
ExtractedSupplier ExtractedSupplier Extracted Supplier ID
CurrencyISOCode CurrencyISOCode Document Currency
TransactionCurrency TransactionCurrency Transaction Currency
CustomerTotalNetAmount CustomerTotalNetAmount Extracted Net Value
CustomerSubtotalAmount CustomerSubtotalAmount Extracted Subtotal Value
SoldToPartyAddressFullName SoldToPartyAddressFullName Extracted Sold-to Party Address
SoldToPartyName SoldToPartyName Sold-to Party Name
SoldToPartyAdditionalName SoldToPartyAdditionalName Sold-to Party Name 2
SoldToPartyPostalCode SoldToPartyPostalCode Postal Code
SoldToPartyHouseNumber SoldToPartyHouseNumber House Number
SoldToPartyStreetName SoldToPartyStreetName Street
SoldToPartyDistrictName SoldToPartyDistrictName District
SoldToPartyCityName SoldToPartyCityName City
SoldToPartyRegionName SoldToPartyRegionName Region
SoldToPartyCountryName SoldToPartyCountryName Country/Region
SoldToPartyTelephoneNumber SoldToPartyTelephoneNumber Phone
SoldToPartyFaxNumber SoldToPartyFaxNumber Fax
SoldToPartyEmailAddress SoldToPartyEmailAddress Email
SoldToPartyTaxRegisterNumber SoldToPartyTaxRegisterNumber Tax Registration Number
SoldToPartyTaxNumber SoldToPartyTaxNumber Additional Tax Number
SoldToPartyBankAccount SoldToPartyBankAccount Bank Account
SoldToPartyIBAN SoldToPartyIBAN International Bank Account Number
SoldToPartyExtRefID SoldToPartyExtRefID Extracted Sold-to Party
ShipToPartyAddressFullName ShipToPartyAddressFullName Extracted Ship-to Party Address
ShipToPartyName ShipToPartyName Ship-To Party Name
ShipToPartyAdditionalName ShipToPartyAdditionalName Ship-to Party Name 2
ShipToPartyPostalCode ShipToPartyPostalCode Postal Code
ShipToPartyHouseNumber ShipToPartyHouseNumber House Number
ShipToPartyStreetName ShipToPartyStreetName Street
ShipToPartyDistrictName ShipToPartyDistrictName District
ShipToPartyCityName ShipToPartyCityName City
ShipToPartyRegionName ShipToPartyRegionName Region
ShipToPartyCountryName ShipToPartyCountryName Country/Region
ShipToPartyTelephoneNumber ShipToPartyTelephoneNumber Phone
ShipToPartyFaxNumber ShipToPartyFaxNumber Fax
ShipToPartyEmailAddress ShipToPartyEmailAddress Email
DetnStrategyForSoldToParty DetnStrategyForSoldToParty Determination Strategy for Sold-to Party
DeterminedSoldToParty DeterminedSoldToParty Determined Sold-to Party
DetnStrategyForShipToParty DetnStrategyForShipToParty Determination Strategy for Ship-to Party
DeterminedShipToParty DeterminedShipToParty Determined Ship-to Party
DetnStrategyForSalesArea DetnStrategyForSalesArea Determination Strategy for Sales Area
DeterminedSalesOrganization DeterminedSalesOrganization Determined Sales Organization
DeterminedDistributionChannel DeterminedDistributionChannel Determined Distribution Channel
DeterminedDivision DeterminedDivision Determined Division
AIFMessageUUID AIFMessageUUID UUID
_TransactionCurrency _TransactionCurrency
_SalesOrderRequest _SalesOrderRequest
_SourceImage _SourceImage

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_SalesOrderRequestSourceTP.
-- 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: RSORSTP

CREATE VIEW R_SalesOrderRequestSourceTP AS
SELECT
  SalesOrderRequest,
  MasterDataDeterminationStatus,
  LanguageISOCode,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderDateText,
  ExtractedRequestedDeliveryDate,
  RequestedDeliveryDateText,
  CustomerPaymentTermsText,
  CustomerIncotermsText,
  ExtractedSupplier,
  CurrencyISOCode,
  TransactionCurrency,
  CustomerTotalNetAmount,
  CustomerSubtotalAmount,
  SoldToPartyAddressFullName,
  SoldToPartyName,
  SoldToPartyAdditionalName,
  SoldToPartyPostalCode,
  SoldToPartyHouseNumber,
  SoldToPartyStreetName,
  SoldToPartyDistrictName,
  SoldToPartyCityName,
  SoldToPartyRegionName,
  SoldToPartyCountryName,
  SoldToPartyTelephoneNumber,
  SoldToPartyFaxNumber,
  SoldToPartyEmailAddress,
  SoldToPartyTaxRegisterNumber,
  SoldToPartyTaxNumber,
  SoldToPartyBankAccount,
  SoldToPartyIBAN,
  SoldToPartyExtRefID,
  ShipToPartyAddressFullName,
  ShipToPartyName,
  ShipToPartyAdditionalName,
  ShipToPartyPostalCode,
  ShipToPartyHouseNumber,
  ShipToPartyStreetName,
  ShipToPartyDistrictName,
  ShipToPartyCityName,
  ShipToPartyRegionName,
  ShipToPartyCountryName,
  ShipToPartyTelephoneNumber,
  ShipToPartyFaxNumber,
  ShipToPartyEmailAddress,
  DetnStrategyForSoldToParty,
  DeterminedSoldToParty,
  DetnStrategyForShipToParty,
  DeterminedShipToParty,
  DetnStrategyForSalesArea,
  DeterminedSalesOrganization,
  DeterminedDistributionChannel,
  DeterminedDivision,
  AIFMessageUUID
FROM I_SalesOrderRequestSource AS SalesOrderRequestSource
LEFT OUTER JOIN R_SlsOrdReqSourceImageTP AS _SourceImage ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More