I_SalesDistributionStatus

DDL: I_SALESDISTRIBUTIONSTATUS SQL: ISLSDISTRBTN Type: view BASIC
17 Fields 1 Data Sources

I view for TVMS

I_SalesDistributionStatus is a Basic CDS View that provides data about "I view for TVMS" in SAP S/4HANA. It reads from 1 data source (tvms) and exposes 17 fields with key field ProductSalesStatus.

Data Sources (1)

SourceAliasJoin Type
tvms SalesDistributionStatus from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISLSDISTRBTN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label I view for TVMS view
VDM.viewType #BASIC view
ObjectModel.representativeKey ProductSalesStatus view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name ProductSalesStatus view
ObjectModel.objectIdentifier.oidElement ProductSalesStatusOID view
AbapCatalog.preserveKey true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProductSalesStatus tvms vmsta Status
InquiryBlock tvms spvba Inquiry
QuotationBlock tvms spvbb Quotation
OrderIsBlockedForCustOfSlsArea tvms spvbc Sales Order
ProductProposalBlock tvms spvbd Prod Proposal
SchedulingAgreementBlock tvms spvbe Skd Agreement
ValueContractBlock tvms spvbf Value Contract
ContractBlock tvms spvbg Contract
ReturnsBlock tvms spvbh Returns
FreeChargeDeliveryBlock tvms spvbi Free Delivery
DeliveryBlock tvms spvbj Delivery
CreditMemoRequestBlock tvms spvbk Credit Memo Req
DebitMemoRequestBlock tvms spvbl Debit Memo Req
DelivBlockReasonForSchedLine tvms lifsp Delivery Block
AllocationTableBlock tvms wauft Alloc tbl block
ReplenishmentBlock tvms wrepl Replenish. block
StoreOrderBlock tvms wstor Store order block

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_SalesDistributionStatus.
-- 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: ISLSDISTRBTN

CREATE VIEW I_SalesDistributionStatus AS
SELECT
  SalesDistributionStatus.vmsta AS ProductSalesStatus,
  SalesDistributionStatus.spvba AS InquiryBlock,
  SalesDistributionStatus.spvbb AS QuotationBlock,
  SalesDistributionStatus.spvbc AS OrderIsBlockedForCustOfSlsArea,
  SalesDistributionStatus.spvbd AS ProductProposalBlock,
  SalesDistributionStatus.spvbe AS SchedulingAgreementBlock,
  SalesDistributionStatus.spvbf AS ValueContractBlock,
  SalesDistributionStatus.spvbg AS ContractBlock,
  SalesDistributionStatus.spvbh AS ReturnsBlock,
  SalesDistributionStatus.spvbi AS FreeChargeDeliveryBlock,
  SalesDistributionStatus.spvbj AS DeliveryBlock,
  SalesDistributionStatus.spvbk AS CreditMemoRequestBlock,
  SalesDistributionStatus.spvbl AS DebitMemoRequestBlock,
  SalesDistributionStatus.lifsp AS DelivBlockReasonForSchedLine,
  SalesDistributionStatus.wauft AS AllocationTableBlock,
  SalesDistributionStatus.wrepl AS ReplenishmentBlock,
  SalesDistributionStatus.wstor AS StoreOrderBlock
FROM tvms AS SalesDistributionStatus
;

Learn More