Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_SalesDistributionStatusVH

DDL: I_SALESDISTRIBUTIONSTATUSVH SQL: ISLSDISTVH Type: view COMPOSITE Package: VDM_SD_MD_MM
18 Fields 1 Data Sources 1 Associations 1 OData Services

Value Help View for Sales Distribution Status

I_SalesDistributionStatusVH is a Composite CDS View that provides data about "Value Help View for Sales Distribution Status" in SAP S/4HANA. It reads from 1 data source (I_SalesDistributionStatus) and exposes 18 fields with key field ProductSalesStatus. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F4584). Part of development package VDM_SD_MD_MM.

Data Sources (1)

SourceAliasJoin Type
I_SalesDistributionStatus SalesDistributionStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SalesDistributionStatusText _Text $projection.ProductSalesStatus = _Text.ProductSalesStatus

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISLSDISTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey ProductSalesStatus view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Value Help View for Sales Distribution Status view
VDM.lifecycle.status #DEPRECATED view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4584 ASQL_F4584 C2 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProductSalesStatus I_SalesDistributionStatus ProductSalesStatus Product Sales Status
InquiryBlock I_SalesDistributionStatus InquiryBlock Inquiry
QuotationBlock I_SalesDistributionStatus QuotationBlock Quotation
OrderIsBlockedForCustOfSlsArea I_SalesDistributionStatus OrderIsBlockedForCustOfSlsArea Sales Order
ProductProposalBlock I_SalesDistributionStatus ProductProposalBlock Block Product Proposal
SchedulingAgreementBlock I_SalesDistributionStatus SchedulingAgreementBlock Block Scheduling Agreement
ValueContractBlock I_SalesDistributionStatus ValueContractBlock Block value contract
ContractBlock I_SalesDistributionStatus ContractBlock Blocked for Contract
ReturnsBlock I_SalesDistributionStatus ReturnsBlock Blocked for returns
FreeChargeDeliveryBlock I_SalesDistributionStatus FreeChargeDeliveryBlock Block free charge delivery
DeliveryBlock I_SalesDistributionStatus DeliveryBlock Blocked for delivery
CreditMemoRequestBlock I_SalesDistributionStatus CreditMemoRequestBlock Block Credit memo request
DebitMemoRequestBlock I_SalesDistributionStatus DebitMemoRequestBlock Block Debit memo request
DelivBlockReasonForSchedLine I_SalesDistributionStatus DelivBlockReasonForSchedLine Delivery Block
AllocationTableBlock I_SalesDistributionStatus AllocationTableBlock Allocation table block
ReplenishmentBlock I_SalesDistributionStatus ReplenishmentBlock Replenishment block
StoreOrderBlock I_SalesDistributionStatus StoreOrderBlock Store order block
_Text _Text

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_SalesDistributionStatusVH.
-- 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: ISLSDISTVH

CREATE VIEW I_SalesDistributionStatusVH AS
SELECT
  SalesDistributionStatus.ProductSalesStatus AS ProductSalesStatus,
  SalesDistributionStatus.InquiryBlock AS InquiryBlock,
  SalesDistributionStatus.QuotationBlock AS QuotationBlock,
  SalesDistributionStatus.OrderIsBlockedForCustOfSlsArea AS OrderIsBlockedForCustOfSlsArea,
  SalesDistributionStatus.ProductProposalBlock AS ProductProposalBlock,
  SalesDistributionStatus.SchedulingAgreementBlock AS SchedulingAgreementBlock,
  SalesDistributionStatus.ValueContractBlock AS ValueContractBlock,
  SalesDistributionStatus.ContractBlock AS ContractBlock,
  SalesDistributionStatus.ReturnsBlock AS ReturnsBlock,
  SalesDistributionStatus.FreeChargeDeliveryBlock AS FreeChargeDeliveryBlock,
  SalesDistributionStatus.DeliveryBlock AS DeliveryBlock,
  SalesDistributionStatus.CreditMemoRequestBlock AS CreditMemoRequestBlock,
  SalesDistributionStatus.DebitMemoRequestBlock AS DebitMemoRequestBlock,
  SalesDistributionStatus.DelivBlockReasonForSchedLine AS DelivBlockReasonForSchedLine,
  SalesDistributionStatus.AllocationTableBlock AS AllocationTableBlock,
  SalesDistributionStatus.ReplenishmentBlock AS ReplenishmentBlock,
  SalesDistributionStatus.StoreOrderBlock AS StoreOrderBlock
FROM I_SalesDistributionStatus AS SalesDistributionStatus
LEFT OUTER JOIN I_SalesDistributionStatusText AS _Text ON ProductSalesStatus = _Text.ProductSalesStatus  -- association [0..*]
;

Learn More