I_SalesOrderRequestSource

DDL: I_SALESORDERREQUESTSOURCE SQL: ISORS Type: view BASIC Package: VDM_SD_SLS_AUTOEXTRN
58 Fields 1 Data Sources 3 Associations

Sales Order Request Source

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

Data Sources (1)

SourceAliasJoin Type
sdsls_sor_src SalesOrderRequestSource from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency
[0..1] I_SalesOrderRequest _SalesOrderRequest $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
[0..*] I_SalesOrderRequestSourceImage _SourceImage $projection.SalesOrderRequest = _SourceImage.SalesOrderRequest

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISORS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order Request Source view
ObjectModel.representativeKey SalesOrderRequest view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest sdsls_sor_src salesorderrequest Sales Order Request
MasterDataDeterminationStatus sdsls_sor_src masterdatadeterminationstatus MD Determination Sts
LanguageISOCode sdsls_sor_src languageisocode Language ISO Code
PurchaseOrderByCustomer sdsls_sor_src purchaseorderbycustomer Purchase Order Number
CustomerPurchaseOrderDate sdsls_sor_src customerpurchaseorderdate Purchase Order Date
CustomerPurchaseOrderDateText sdsls_sor_src customerpurchaseorderdatetext
ExtractedRequestedDeliveryDate sdsls_sor_src extractedrequesteddeliverydate Extracted Requested Delivery Date
RequestedDeliveryDateText sdsls_sor_src requesteddeliverydatetext
CustomerPaymentTermsText sdsls_sor_src customerpaymenttermstext Payment Terms
CustomerIncotermsText sdsls_sor_src customerincotermstext Incoterms
ExtractedSupplier sdsls_sor_src extractedsupplier Extracted Supplier ID
CurrencyISOCode sdsls_sor_src currencyisocode Document Currency
TransactionCurrency sdsls_sor_src transactioncurrency Transaction Currency
CustomerTotalNetAmount sdsls_sor_src customertotalnetamount Extracted Net Value
CustomerSubtotalAmount sdsls_sor_src customersubtotalamount Extracted Subtotal Value
SoldToPartyAddressFullName sdsls_sor_src soldtopartyaddressfullname Extracted Sold-to Party Address
SoldToPartyName sdsls_sor_src soldtopartyname Sold-to Party Name
SoldToPartyAdditionalName sdsls_sor_src soldtopartyadditionalname Sold-to Party Name 2
SoldToPartyPostalCode sdsls_sor_src soldtopartypostalcode Postal Code
SoldToPartyHouseNumber sdsls_sor_src soldtopartyhousenumber House Number
SoldToPartyStreetName sdsls_sor_src soldtopartystreetname Street
SoldToPartyDistrictName sdsls_sor_src soldtopartydistrictname District
SoldToPartyCityName sdsls_sor_src soldtopartycityname City
SoldToPartyRegionName sdsls_sor_src soldtopartyregionname Region
SoldToPartyCountryName sdsls_sor_src soldtopartycountryname Country/Region
SoldToPartyTelephoneNumber sdsls_sor_src soldtopartytelephonenumber Phone
SoldToPartyFaxNumber sdsls_sor_src soldtopartyfaxnumber Fax
SoldToPartyEmailAddress sdsls_sor_src soldtopartyemailaddress Email
SoldToPartyTaxRegisterNumber sdsls_sor_src soldtopartytaxregisternumber Tax Registration Number
SoldToPartyTaxNumber sdsls_sor_src soldtopartytaxnumber Additional Tax Number
SoldToPartyBankAccount sdsls_sor_src soldtopartybankaccount Bank Account
SoldToPartyIBAN sdsls_sor_src soldtopartyiban International Bank Account Number
SoldToPartyExtRefID sdsls_sor_src soldtopartyextrefid Extracted Sold-to Party
ShipToPartyAddressFullName sdsls_sor_src shiptopartyaddressfullname Extracted Ship-to Party Address
ShipToPartyName sdsls_sor_src shiptopartyname Ship-To Party Name
ShipToPartyAdditionalName sdsls_sor_src shiptopartyadditionalname Ship-to Party Name 2
ShipToPartyPostalCode sdsls_sor_src shiptopartypostalcode Postal Code
ShipToPartyHouseNumber sdsls_sor_src shiptopartyhousenumber House Number
ShipToPartyStreetName sdsls_sor_src shiptopartystreetname Street
ShipToPartyDistrictName sdsls_sor_src shiptopartydistrictname District
ShipToPartyCityName sdsls_sor_src shiptopartycityname City
ShipToPartyRegionName sdsls_sor_src shiptopartyregionname Region
ShipToPartyCountryName sdsls_sor_src shiptopartycountryname Country/Region
ShipToPartyTelephoneNumber sdsls_sor_src shiptopartytelephonenumber Phone
ShipToPartyFaxNumber sdsls_sor_src shiptopartyfaxnumber Fax
ShipToPartyEmailAddress sdsls_sor_src shiptopartyemailaddress Email
DetnStrategyForSoldToParty sdsls_sor_src detnstrategyforsoldtoparty Determination Strategy for Sold-to Party
DeterminedSoldToParty sdsls_sor_src determinedsoldtoparty Determined Sold-to Party
DetnStrategyForShipToParty sdsls_sor_src detnstrategyforshiptoparty Determination Strategy for Ship-to Party
DeterminedShipToParty sdsls_sor_src determinedshiptoparty Determined Ship-to Party
DetnStrategyForSalesArea sdsls_sor_src detnstrategyforsalesarea Determination Strategy for Sales Area
DeterminedSalesOrganization sdsls_sor_src determinedsalesorganization Determined Sales Organization
DeterminedDistributionChannel sdsls_sor_src determineddistributionchannel Determined Distribution Channel
DeterminedDivision sdsls_sor_src determineddivision Determined Division
AIFMessageUUID sdsls_sor_src aifmessageuuid UUID
_SalesOrderRequest _SalesOrderRequest
_TransactionCurrency _TransactionCurrency
_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 I_SalesOrderRequestSource.
-- 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: ISORS

CREATE VIEW I_SalesOrderRequestSource AS
SELECT
  SalesOrderRequestSource.salesorderrequest AS SalesOrderRequest,
  SalesOrderRequestSource.masterdatadeterminationstatus AS MasterDataDeterminationStatus,
  SalesOrderRequestSource.languageisocode AS LanguageISOCode,
  SalesOrderRequestSource.purchaseorderbycustomer AS PurchaseOrderByCustomer,
  SalesOrderRequestSource.customerpurchaseorderdate AS CustomerPurchaseOrderDate,
  SalesOrderRequestSource.customerpurchaseorderdatetext AS CustomerPurchaseOrderDateText,
  SalesOrderRequestSource.extractedrequesteddeliverydate AS ExtractedRequestedDeliveryDate,
  SalesOrderRequestSource.requesteddeliverydatetext AS RequestedDeliveryDateText,
  SalesOrderRequestSource.customerpaymenttermstext AS CustomerPaymentTermsText,
  SalesOrderRequestSource.customerincotermstext AS CustomerIncotermsText,
  SalesOrderRequestSource.extractedsupplier AS ExtractedSupplier,
  SalesOrderRequestSource.currencyisocode AS CurrencyISOCode,
  SalesOrderRequestSource.transactioncurrency AS TransactionCurrency,
  SalesOrderRequestSource.customertotalnetamount AS CustomerTotalNetAmount,
  SalesOrderRequestSource.customersubtotalamount AS CustomerSubtotalAmount,
  SalesOrderRequestSource.soldtopartyaddressfullname AS SoldToPartyAddressFullName,
  SalesOrderRequestSource.soldtopartyname AS SoldToPartyName,
  SalesOrderRequestSource.soldtopartyadditionalname AS SoldToPartyAdditionalName,
  SalesOrderRequestSource.soldtopartypostalcode AS SoldToPartyPostalCode,
  SalesOrderRequestSource.soldtopartyhousenumber AS SoldToPartyHouseNumber,
  SalesOrderRequestSource.soldtopartystreetname AS SoldToPartyStreetName,
  SalesOrderRequestSource.soldtopartydistrictname AS SoldToPartyDistrictName,
  SalesOrderRequestSource.soldtopartycityname AS SoldToPartyCityName,
  SalesOrderRequestSource.soldtopartyregionname AS SoldToPartyRegionName,
  SalesOrderRequestSource.soldtopartycountryname AS SoldToPartyCountryName,
  SalesOrderRequestSource.soldtopartytelephonenumber AS SoldToPartyTelephoneNumber,
  SalesOrderRequestSource.soldtopartyfaxnumber AS SoldToPartyFaxNumber,
  SalesOrderRequestSource.soldtopartyemailaddress AS SoldToPartyEmailAddress,
  SalesOrderRequestSource.soldtopartytaxregisternumber AS SoldToPartyTaxRegisterNumber,
  SalesOrderRequestSource.soldtopartytaxnumber AS SoldToPartyTaxNumber,
  SalesOrderRequestSource.soldtopartybankaccount AS SoldToPartyBankAccount,
  SalesOrderRequestSource.soldtopartyiban AS SoldToPartyIBAN,
  SalesOrderRequestSource.soldtopartyextrefid AS SoldToPartyExtRefID,
  SalesOrderRequestSource.shiptopartyaddressfullname AS ShipToPartyAddressFullName,
  SalesOrderRequestSource.shiptopartyname AS ShipToPartyName,
  SalesOrderRequestSource.shiptopartyadditionalname AS ShipToPartyAdditionalName,
  SalesOrderRequestSource.shiptopartypostalcode AS ShipToPartyPostalCode,
  SalesOrderRequestSource.shiptopartyhousenumber AS ShipToPartyHouseNumber,
  SalesOrderRequestSource.shiptopartystreetname AS ShipToPartyStreetName,
  SalesOrderRequestSource.shiptopartydistrictname AS ShipToPartyDistrictName,
  SalesOrderRequestSource.shiptopartycityname AS ShipToPartyCityName,
  SalesOrderRequestSource.shiptopartyregionname AS ShipToPartyRegionName,
  SalesOrderRequestSource.shiptopartycountryname AS ShipToPartyCountryName,
  SalesOrderRequestSource.shiptopartytelephonenumber AS ShipToPartyTelephoneNumber,
  SalesOrderRequestSource.shiptopartyfaxnumber AS ShipToPartyFaxNumber,
  SalesOrderRequestSource.shiptopartyemailaddress AS ShipToPartyEmailAddress,
  SalesOrderRequestSource.detnstrategyforsoldtoparty AS DetnStrategyForSoldToParty,
  SalesOrderRequestSource.determinedsoldtoparty AS DeterminedSoldToParty,
  SalesOrderRequestSource.detnstrategyforshiptoparty AS DetnStrategyForShipToParty,
  SalesOrderRequestSource.determinedshiptoparty AS DeterminedShipToParty,
  SalesOrderRequestSource.detnstrategyforsalesarea AS DetnStrategyForSalesArea,
  SalesOrderRequestSource.determinedsalesorganization AS DeterminedSalesOrganization,
  SalesOrderRequestSource.determineddistributionchannel AS DeterminedDistributionChannel,
  SalesOrderRequestSource.determineddivision AS DeterminedDivision,
  SalesOrderRequestSource.aifmessageuuid AS AIFMessageUUID
FROM sdsls_sor_src AS SalesOrderRequestSource
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderRequest AS _SalesOrderRequest ON SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderRequestSourceImage AS _SourceImage ON SalesOrderRequest = _SourceImage.SalesOrderRequest  -- association [0..*]
;

Learn More