R_SalesOrderRequestTP

DDL: R_SALESORDERREQUESTTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_SOR
66 Fields 1 Data Sources 6 Associations

Sales Order Request - TP

R_SalesOrderRequestTP is a Transactional CDS View that provides data about "Sales Order Request - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderRequest) and exposes 66 fields with key field SalesOrderRequest. It has 6 associations to related views. Part of development package RAP_SD_SLS_SOR.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderRequest SalesOrderRequest from

Associations (6)

CardinalityTargetAliasCondition
[1] E_SalesOrderRequest _Extension $projection.SalesOrderRequest = _Extension.SalesOrderRequest
[0..*] R_SalesOrderRequestItemTP _Item
[0..*] R_SalesOrderRequestPartnerTP _Partner
[0..*] R_SlsOrdReqPricingElementTP _PricingElement
[0..*] R_SalesOrderRequestDerivdItmTP _DerivedItem
[0..1] R_SalesOrderRequestSourceTP _Source

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name SalesOrderRequest 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 - TP view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest SalesOrderRequest Sales Order Request
SalesOrderRequestCategory SalesOrderRequestCategory SOR Category
CompanyCode CompanyCode Receiver Company Code
SalesOrderRequestFileMimeType SalesOrderRequestFileMimeType MIME Type
SalesOrderRequestFileName SalesOrderRequestFileName File Name
UploadFileContentBinary UploadFileContentBinary Source File of Memo Records
SalesOrderRequestExtractorUUID SalesOrderRequestExtractorUUID Extractor UUID
SalesOrderReqExtractionStatus SalesOrderReqExtractionStatus Data Extraction
SalesOrderReqProcessingStatus SalesOrderReqProcessingStatus SOR Procg Status
SalesOrderReqSimulationStatus SalesOrderReqSimulationStatus Order Simulation
SalesOrderReqApprovalStatus SalesOrderReqApprovalStatus Sales Order Request Approval Status
SalesOrderType SalesOrderType Sales Order Type
SoldToParty SoldToParty Sold-to Party
SoldToPartyAddressID SoldToPartyAddressID Sold-To Address
ShipToParty ShipToParty Ship-To Party (obsolete)
ShipToPartyAddressID ShipToPartyAddressID Ship-to Party Address
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
TransactionCurrency TransactionCurrency Transaction Currency
TotalNetAmount TotalNetAmount Total Net Amount
SalesOrder SalesOrder SD Document
SDPricingProcedure SDPricingProcedure Pric. Procedure
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
usedasetagfieldRequestedDeliveryDate
LastSimulatedDateTime LastSimulatedDateTime Last Simulated On
SalesOrderRequestLogHandle SalesOrderRequestLogHandle Handle
SlsOrdReqFileContentHash SlsOrdReqFileContentHash Hash
SlsOrdReqSilentDtaMigrtnVers SlsOrdReqSilentDtaMigrtnVers SDM Version
IncotermsClassification IncotermsClassification Incoterms
IncotermsVersion IncotermsVersion Inco. Version
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
FixedValueDate FixedValueDate Fixed Val. Date
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
_Item _Item
_Partner _Partner
_PricingElement _PricingElement
_DerivedItem _DerivedItem
_Source _Source
_SalesOrderRequestCategory _SalesOrderRequestCategory
_CompanyCode _CompanyCode
_SalesOrderType _SalesOrderType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_SlsOrganizationDistrChnl _SlsOrganizationDistrChnl
_OrganizationDivision _OrganizationDivision
_SalesGroup _SalesGroup
_SalesOffice _SalesOffice
_SoldToParty _SoldToParty
_SoldToPartyAddress _SoldToPartyAddress
_ShipToParty _ShipToParty
_ShipToPartyAddress _ShipToPartyAddress
_TransactionCurrency _TransactionCurrency
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_SlsOrdReqExtractionStatus _SlsOrdReqExtractionStatus
_SlsOrdReqSimulationStatus _SlsOrdReqSimulationStatus
_SlsOrdReqApprovalStatus _SlsOrdReqApprovalStatus

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_SalesOrderRequestTP.
-- 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_SalesOrderRequestTP AS
SELECT
  SalesOrderRequest,
  SalesOrderRequestCategory,
  CompanyCode,
  SalesOrderRequestFileMimeType,
  SalesOrderRequestFileName,
  UploadFileContentBinary,
  SalesOrderRequestExtractorUUID,
  SalesOrderReqExtractionStatus,
  SalesOrderReqProcessingStatus,
  SalesOrderReqSimulationStatus,
  SalesOrderReqApprovalStatus,
  SalesOrderType,
  SoldToParty,
  SoldToPartyAddressID,
  ShipToParty,
  ShipToPartyAddressID,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  PurchaseOrderByCustomer,
  TransactionCurrency,
  TotalNetAmount,
  SalesOrder,
  SDPricingProcedure,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  LastSimulatedDateTime,
  SalesOrderRequestLogHandle,
  SlsOrdReqFileContentHash,
  SlsOrdReqSilentDtaMigrtnVers,
  IncotermsClassification,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  CustomerPaymentTerms,
  FixedValueDate,
  CustomerPurchaseOrderDate
FROM I_SalesOrderRequest AS SalesOrderRequest
LEFT OUTER JOIN E_SalesOrderRequest AS _Extension ON SalesOrderRequest = _Extension.SalesOrderRequest  -- association [1]
LEFT OUTER JOIN R_SalesOrderRequestItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderRequestPartnerTP AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsOrdReqPricingElementTP AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderRequestDerivdItmTP AS _DerivedItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderRequestSourceTP AS _Source ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More