I_SettlementDocumentHeader

DDL: I_SETTLEMENTDOCUMENTHEADER SQL: ISTLDOCHDR Type: view BASIC

Interface for Settlement Unit Header Data

I_SettlementDocumentHeader is a Basic CDS View that provides data about "Interface for Settlement Unit Header Data" in SAP S/4HANA. It reads from 1 data source (/accgo/t_stlhead) and exposes 34 fields with key field SettlementDocHeaderUUID.

Data Sources (1)

SourceAliasJoin Type
/accgo/t_stlhead /accgo/t_stlhead from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISTLDOCHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Interface for Settlement Unit Header Data view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SettlementDocHeaderUUID stl_header_guid
SettlmtDoc settl_doc
SettlmtDocYear settl_yr
ContractApplicationUUID appl_guid
ContractApplicationVersion appl_version
ACMSettlementDocumentType doc_typ
ACMReferenceSettlementCategory settl_cat
SettlementScenario settl_scenario
Side side
TradingContractNumber tkonn
TradingContractItem tposn
ABDNumber wbeln
SettlementPostingDate post_date
ContractApplicationDocument appldoc
SuccessorItem appldoc_item
SoldToParty kunag
PayerParty kunrg
BillToParty kunre
ReferenceVendor lifnr
ReferencePayer invoicing_party
CustomerCountryKey land1
Region z_regio
SettlementCurrency doc_curr
ACMSettlementUnitGrossAmount gross_amount
ACMSettlementUnitNetAmount net_amount
ThresholdPercentage threshold_perc
DPQSinSettlementIndicator dpqs_in_settlement
ACMSettlementUnitIsIgnoreDPQS ignore_dpqs
ACMSettlmtIsFnlSeparateInvcFee final_si_fee_stl
ACMSettlmtIsPrvsnlPostgActive pstl_active
clientNULLasApplItemCreatedOnDateTime
PrepaymentStopIntrstDate stopinterestdate
PrepaymentSuspendIntrstFromDte suspendfromdate
PrepaymentSuspendIntrstToDte suspendtodate
/*---------------------------------------------------------------------*
* Copyright  2012 SAP AG. All rights reserved                          *
*----------------------------------------------------------------------*
* CDS Name                : I_SettlementDocumentHeader                 *
* CDS Description         : Private View For Fetching Settlement Unit  *
*                           Data                                       *
*---------------------------------------------------------------------*/
@AbapCatalog.sqlViewName: 'ISTLDOCHDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@ObjectModel.supportedCapabilities:#CDS_MODELING_DATA_SOURCE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Interface for Settlement Unit Header Data'
define view I_SettlementDocumentHeader
  as select from /accgo/t_stlhead
{
  key stl_header_guid           as SettlementDocHeaderUUID,
      settl_doc                 as SettlmtDoc,
      settl_yr                  as SettlmtDocYear,
      appl_guid                 as ContractApplicationUUID,
      appl_version              as ContractApplicationVersion,
      doc_typ                   as ACMSettlementDocumentType,
      settl_cat                 as ACMReferenceSettlementCategory,
      settl_scenario            as SettlementScenario,
      side                      as Side,
      tkonn                     as TradingContractNumber,
      tposn                     as TradingContractItem,
      wbeln                     as ABDNumber,
      post_date                 as SettlementPostingDate,
      appldoc                   as ContractApplicationDocument,
      appldoc_item              as SuccessorItem,
      kunag                     as SoldToParty,
      kunrg                     as PayerParty,
      kunre                     as BillToParty,
      lifnr                     as ReferenceVendor,
      invoicing_party           as ReferencePayer,
      land1                     as CustomerCountryKey,
      z_regio                   as Region,
      @Semantics.currencyCode: true
      doc_curr                  as SettlementCurrency,
      @Semantics.amount.currencyCode: 'SettlementCurrency'
      gross_amount              as ACMSettlementUnitGrossAmount,
      @Semantics.amount.currencyCode: 'SettlementCurrency'
      net_amount                as ACMSettlementUnitNetAmount,
      threshold_perc            as ThresholdPercentage,
      dpqs_in_settlement        as DPQSinSettlementIndicator,
      ignore_dpqs               as ACMSettlementUnitIsIgnoreDPQS,
      final_si_fee_stl          as ACMSettlmtIsFnlSeparateInvcFee,
      pstl_active               as ACMSettlmtIsPrvsnlPostgActive,
      tstmp_to_dats( created_on,
                       abap_system_timezone( $session.client,'NULL' ),
                       $session.client,
                       'NULL' ) as ApplItemCreatedOnDateTime,
      stopinterestdate          as PrepaymentStopIntrstDate,
      suspendfromdate           as PrepaymentSuspendIntrstFromDte,
      suspendtodate             as PrepaymentSuspendIntrstToDte

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ACCGO/T_STLHEAD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/