P_ALLWDCUSTRETTYPEPERSLSORG

CDS View

Allowed Return Type Per Sales Org

P_ALLWDCUSTRETTYPEPERSLSORG is a CDS View in S/4HANA. Allowed Return Type Per Sales Org. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_RetsReferenceDocumentUnion view_entity inner CONSUMPTION Returns Reference Document
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PALWDORDTPSO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_AllwdCustRetTypePerSlsOrg
  as select distinct from I_AllwdOrdTypPerSlsOrg as AllowedReturnType
  inner join     I_SalesDocumentType    as SalesDocumentType on AllowedReturnType.SalesDocumentType = SalesDocumentType.SalesDocumentType
{

  key AllowedReturnType.SalesOrganization,
  key AllowedReturnType.DistributionChannel,
  key AllowedReturnType.Division,
  
      //Associations

      AllowedReturnType._SalesOrganization,
      AllowedReturnType._DistributionChannel,
      AllowedReturnType._Division
}
where SalesDocumentType.RetsMgmtIsActive   = 'X'
  and SalesDocumentType.SDDocumentCategory = 'H'