FAC_DART_Z3_DOCUMENTTYPE

DDL: FAC_DART_Z3_DOCUMENTTYPE SQL: FAC_DZDOCTYPE Type: view

Document Type Master Data

FAC_DART_Z3_DOCUMENTTYPE is a CDS View that provides data about "Document Type Master Data" in SAP S/4HANA. It reads from 1 data source (t003) and exposes 23 fields with key field AccountingDocumentType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t003 t003 from

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AccountingDocumentTypeText _Text $projection.AccountingDocumentType = _Text.AccountingDocumentType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZDOCTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey AccountingDocumentType view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Document Type Master Data view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocumentType
AccountingDocumentTypeName
AccountingDocumentNumberRange numkr
AuthorizationGroup brgru
AllowedFinancialAccountTypes koars
DocumentType stbla Reverse Document Type
IndDocumentPostedNet xnetb
IndPostingFromBillingDocument xrvup
IndCanOnlyBeUsedinBatchInput xsybl
IndReferenceNumber xmref
ExchangeRateType kurst
IndNegativePostings xnegp
IndPostingstoAssets xkoaa
IndPostingstoCustomer xkoad
IndPostingstoVendor xkoak
IndPostingstoMaterialAccount xkoam
IndPostingstoGLAccount xkoas
SystemClient mandt System Client
xrvup xrvup
xsybl xsybl
kurst kurst
xkoasecc xkoasecc
_Text _Text
@AbapCatalog.sqlViewName: 'FAC_DZDOCTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'AccountingDocumentType'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #A,
  sizeCategory: #S
}
@EndUserText.label: 'Document Type Master Data'

define view FAC_DART_Z3_DOCUMENTTYPE
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from t003
  association [0..*] to I_AccountingDocumentTypeText as _Text on $projection.AccountingDocumentType = _Text.AccountingDocumentType
{
      @ObjectModel.text.association: '_Text'
  key cast ( blart as farp_blart preserving type ) as AccountingDocumentType,
      _Text[1: Language = $parameters.P_Language].AccountingDocumentTypeName,
      numkr                                        as AccountingDocumentNumberRange,
      brgru                                        as AuthorizationGroup,
      koars                                        as AllowedFinancialAccountTypes,
      @EndUserText.label: 'Reverse Document Type'
      stbla                                        as DocumentType,
      xnetb                                        as IndDocumentPostedNet,
      xrvup                                        as IndPostingFromBillingDocument,
      xsybl                                        as IndCanOnlyBeUsedinBatchInput,
      xmref                                        as IndReferenceNumber,
      kurst                                        as ExchangeRateType,
      xnegp                                        as IndNegativePostings,
      xkoaa                                        as IndPostingstoAssets,
      xkoad                                        as IndPostingstoCustomer,
      xkoak                                        as IndPostingstoVendor,
      xkoam                                        as IndPostingstoMaterialAccount,
      xkoas                                        as IndPostingstoGLAccount,

      @EndUserText.label: 'System Client'
      mandt                                        as SystemClient,
      xrvup,
      xsybl,
      kurst,
      xkoasecc,
      _Text


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"T003"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/