I_SALESDOCUMENTTYPE

CDS View

Sales Document Type

I_SALESDOCUMENTTYPE is a CDS View in S/4HANA. Sales Document Type. It contains 2 fields. 43 CDS views read from this table.

Used by 43 CDS view(s) 2 fields

CDS Views using this table (43)

ViewTypeJoinVDMDescription
A_SalesOrderType view from BASIC Sales Order type
C_CustomerReturnTypeVH view from CONSUMPTION Returns Order Type
C_DplSlsDocTypeVH view from CONSUMPTION Type of Duplicate Sales Document
C_Incompl_SalesDocTypeVH view from CONSUMPTION Sales Document Types
C_PartnerFuncBySalesDocTypeVH view from CONSUMPTION Partner Function By Sales Doc Type
C_PrdtdDelivDelaySlsDocTypeVH view from CONSUMPTION Sales Document Type
C_PrtnFuncBySlsContractTypeVH view from CONSUMPTION Partner Function By Sales Contract Type
C_SalesContractTypeValueHelp view from CONSUMPTION Sales Contract Specific Document Types
C_SalesInquiryTypeValueHelp view from CONSUMPTION Sales Inquiry specific document types
C_SalesOrderTypeValueHelp view from CONSUMPTION Sales Order Type
C_SalesOrderTypeVH_F2242 view from CONSUMPTION Sales Order Type
C_SalesQuotationTypeValueHelp view from CONSUMPTION Sales Quotation specific document types
C_SalesSchedgAgrmtTypeVH view from CONSUMPTION Sales Scheduling Agreement Types
C_SCChkSalesDocTypeVH view from CONSUMPTION Consumption VH for Sales Document Type
C_SlsDocFlfmtSlsDocTypeVH view from CONSUMPTION Sales Document Type
C_SlsDocTypeTxtDetnProcedItmVH view from CONSUMPTION Text Detn Proced Items by Sls Doc Types
I_AllwdCustRetTypePerSlsOrg view_entity inner COMPOSITE Allowed Return Type Per Sales Org
I_ARunRequirementDocumentType view from BASIC Requirement document type
I_CreditMemoRequestType view from BASIC Credit Memo Request Types
I_CustomerReturnType view from BASIC Returns Order Types
I_CustRetCpyCtrlSrceDocType view_entity inner COMPOSITE Source Document Type for Returns Order
I_DebitMemoRequestType view from BASIC Debit Memo Request Types
I_DigitalVehSalesDocumentType view_entity from BASIC Digital Vehicle Sales Document Type
I_JITSlsSchedgAgrmt view from BASIC JIT Sales Scheduling Agreement
I_JITSlsSchedgAgrmtBasic view_entity from BASIC JIT Sales Scheduling Agreement
I_SalesContractType view from BASIC Sales Contract Types
I_SalesInquiryType view from BASIC Sales Inquiry Types
I_SalesItemProposalType view from BASIC Sales Item Proposal Types
I_SalesOrderType view from BASIC Sales Order Types
I_SalesOrderWithoutChargeType view from BASIC Sales Order Without Charge Types
I_SalesQuotationType view from BASIC Sales Quotation Types
I_SalesSchedgAgrmtType view from BASIC Sales Scheduling Agreement Types
P_AllwdCustRetTypePerSlsOrg view inner CONSUMPTION
P_AutomXtrctnSalesOrderType view from COMPOSITE
P_SalesDocGeneralRjcnRsn view inner BASIC
P_SDDocumentType view union_all BASIC
R_CreditMemoRequestTextTP view_entity inner TRANSACTIONAL Credit Memo Request - Text TP
R_CustomerReturnTextTP view_entity inner TRANSACTIONAL Returns Order - Text TP
R_DebitMemoRequestTextTP view_entity inner TRANSACTIONAL Debit Memo Request - Text TP
R_SalesContractTextTP view_entity inner TRANSACTIONAL Sales Contract - Text TP
R_SalesOrderTextTP view_entity inner TRANSACTIONAL Sales Order - Text TP
R_SalesQuotationTextTP view_entity inner TRANSACTIONAL Sales Quotation - Text TP
R_SlsSchedgAgrmtTextTP view_entity inner TRANSACTIONAL Sales Scheduling Agreement - Text TP

Fields (2)

KeyField CDS FieldsUsed in Views
KEY SalesDocumentType SalesDocumentType 7
KEY TextDeterminationProcedure TextDeterminationProcedure 8 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'SalesDocumentType'
@ObjectModel.sapObjectNodeType.name: 'SalesDocumentType'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
@EndUserText.label: 'Sales Document Type'
@Analytics: { dataCategory: #DIMENSION}
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDSALESDOCTYPE'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true

define view I_SalesDocumentType
  as select from tvak

  association [0..*] to I_SalesDocumentTypeText       as _Text                        on $projection.SalesDocumentType = _Text.SalesDocumentType
  association [1..1] to I_SalesDocumentType           as _OrderTypeForBillingRequest  on $projection.OrderTypeForBillingRequest = _OrderTypeForBillingRequest.SalesDocumentType
  association [1..1] to I_DeliveryBlockReason         as _DeliveryBlockReason         on $projection.DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason
  association [0..1] to I_SDDocumentTextDetnProcedure as _TextDeterminationProcedure  on $projection.TextDeterminationProcedure = _TextDeterminationProcedure.TextDeterminationProcedure
  association [0..1] to I_PartDeterminationProcedure  as _PartDeterminationProcedure  on $projection.PartnerDeterminationProcedure = _PartDeterminationProcedure.PartnerDeterminationProcedure
  association [0..*] to I_SalesDocumentTypeLangDepdnt as _SalesDocumentTypeLangDepdnt on $projection.SalesDocumentType = _SalesDocumentTypeLangDepdnt.SalesDocumentType
{
      @ObjectModel.text.association: '_Text'
  key auart      as SalesDocumentType,

      vbtyp      as SDDocumentCategory,
      bezob      as MandatoryReferenceSDDocCat,
      vbklt      as SalesDocumentProcessingType,
      kopgr      as ScreenSequenceGroup,
      @ObjectModel.foreignKey.association: '_OrderTypeForBillingRequest'
      aufak      as OrderTypeForBillingRequest,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_DeliveryBlockReason'
      lifsk      as DeliveryBlockReason,
      sperr      as IsLocked,
      msr_active as RetsMgmtIsActive,
      itmac      as TradeComplianceIsActive,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_TextDeterminationProcedure'
      cast(txtgr as sls_doc_text_detn_head preserving type )           as TextDeterminationProcedure,   
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_PartDeterminationProcedure'
      cast(pargr as sls_doc_partner_detn_head preserving type )        as PartnerDeterminationProcedure,
      pvbsm      as SlsDocProdProposalProcedure,
      numki      as NumberRangeForIntIDAssignment,
      numke      as NumberRangeForExtIDAssignment,

      //Association

      _Text,
      _OrderTypeForBillingRequest,
      _SalesDocumentTypeLangDepdnt,
      _DeliveryBlockReason,
      _TextDeterminationProcedure,
      _PartDeterminationProcedure
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVAK"
],
"ASSOCIATED":
[
"I_DELIVERYBLOCKREASON",
"I_PARTDETERMINATIONPROCEDURE",
"I_SALESDOCUMENTTYPELANGDEPDNT",
"I_SALESDOCUMENTTYPETEXT",
"I_SDDOCUMENTTEXTDETNPROCEDURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More