I_SALESDISTRIBUTIONSTATUS

CDS View

I view for TVMS

I_SALESDISTRIBUTIONSTATUS is a CDS View in S/4HANA. I view for TVMS. It contains 17 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 17 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesDistributionStatusVH view from COMPOSITE Value Help View for Sales Distribution Status

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ProductSalesStatus ProductSalesStatus 1
AllocationTableBlock AllocationTableBlock 1
ContractBlock ContractBlock 1
CreditMemoRequestBlock CreditMemoRequestBlock 1
DebitMemoRequestBlock DebitMemoRequestBlock 1
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine 1
DeliveryBlock DeliveryBlock 1
FreeChargeDeliveryBlock FreeChargeDeliveryBlock 1
InquiryBlock InquiryBlock 1
OrderIsBlockedForCustOfSlsArea OrderIsBlockedForCustOfSlsArea 1
ProductProposalBlock ProductProposalBlock 1
QuotationBlock QuotationBlock 1
ReplenishmentBlock ReplenishmentBlock 1
ReturnsBlock ReturnsBlock 1
SchedulingAgreementBlock SchedulingAgreementBlock 1
StoreOrderBlock StoreOrderBlock 1
ValueContractBlock ValueContractBlock 1 
@AbapCatalog.sqlViewName: 'ISLSDISTRBTN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'I view for TVMS'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'ProductSalesStatus'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.sapObjectNodeType.name:'ProductSalesStatus'
@ObjectModel.alternativeKey:[{id:'OID',uniqueness:#UNIQUE,element:['ProductSalesStatusOID']}]
@ObjectModel.objectIdentifier.oidElement:'ProductSalesStatusOID'
@AbapCatalog.preserveKey:true
//@ObjectModel.oid:'ProductSalesStatusOID'

define view I_SalesDistributionStatus
  as select from           tvms as SalesDistributionStatus
    left outer to one join I_MdiOidConfiguration on I_MdiOidConfiguration.ObjectTypeCode = '5610'

{
  key 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,
      @ObjectModel.sort.enabled:false //ATC

      @ObjectModel.filter.enabled:false
      case when I_MdiOidConfiguration.Context is initial or I_MdiOidConfiguration.ComposeOid is initial then
      //Context ID is not specified

                cast( SalesDistributionStatus.vmsta as productsalesstatus_oid )
              when I_MdiOidConfiguration.Context is not initial
              and I_MdiOidConfiguration.ComposeOid is not initial then
      //Context ID is specified

                cast( concat( concat( I_MdiOidConfiguration.Context, ':' ), SalesDistributionStatus.vmsta ) as productsalesstatus_oid )
           end                      as ProductSalesStatusOID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDIOIDCONFIGURATION",
"TVMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More