P_SettlementUnitHeader

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SettlementUnitHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSTLUNITHEADER

CREATE VIEW P_SettlementUnitHeader AS
SELECT
  stl_header_guid AS SettlementUnitUUID,
  tkonn AS ContractNum,
  tposn AS ContractItem,
  tposn_com AS ContractCommodityItem,
  appl_guid AS ContractApplicationUUID,
  appl_version AS ContractApplicationVersion,
  header.created_on AS SettlementCreatedOn,
  settl_cat AS SettlmtCat,
  concat('XS', concat(settl_doc, settl_yr) ) AS SettlementStatusObject,
  /accgo/effdate AS EffectiveDate,
  /accgo/rate_type AS RateType,
  /accgo/stl_curr AS SettlementCurrency,
  accrual_acct_doc_type AS AccrualDocumentType,
  accrual_act_doc_no AS AccrualDocumentNumber,
  accrual_fiscal_year AS AccrualFinancialYear,
  accrual_gl_account AS AccrualGLAccount,
  accrual_posting_date AS AccrualPostingDate,
  accrual_rev_act_doc_no AS AccrualReveralDocNum,
  accrual_rev_fiscal_year AS AccrualReveralFinancialYr,
  accrual_rev_gl_account AS AccrualReversalGLAccount,
  accrual_reversal_date AS AccrualReversalDate,
  accrue_storage_fees AS AccrualStorageFees,
  adj_stl_hdr AS SettlementAdjustmentUUID,
  apconfirm_flag AS APConfirmIndicator,
  header.appldoc AS ContractApplicationDocument,
  appldoc_item AS ApplicationDocumentItem,
  arconfirm_flag AS ARConfirmFlag,
  bukrs AS CompanyCode,
  cancl_guid AS ContractQtyCancellationUUID,
  header.changed_by AS ChangedBy,
  header.changed_on AS ChangedOn,
  cparty_split AS CounterpartySplitIndicator,
  header.created_by AS CreatedBy,
  delv_terms AS IncotermsPart1,
  doc_curr AS DocumentCurrency,
  doc_typ AS DocumentType,
  dpqs_accruals_recalc AS IsDPQSAccrualsRecalled,
  dpqs_adj_amt AS DPQSAdjustmentAmount,
  dpqs_in_settlement AS DPQSInSettlementIndicator,
  fx_relevant AS FXRelevantIndicator,
  gl_amount AS GLAmount,
  gl_currency AS GLAmountCurrency,
  gm_ind_sent AS GoodsMovementEvent,
  gross_amount AS GrossAmount,
  gsber AS BusinessArea,
  inco2 AS IncotermsPart2,
  invoicing_party AS InvoicingParty,
  isw_applied AS ISWUsageFlag,
  kunag AS SoldToParty,
  kunre AS BillToParty,
  land1 AS CountryKey,
  lfsnr AS ExternalDeliveryNoteNumber,
  lien_flag AS LienIndicator,
  header.lifnr AS Vendor,
  mirror_stl_hdr AS SettlementMirrorUUID,
  mm_thres AS MMThresholdInPercentage,
  net_amount AS NetAmount,
  netwr AS ABDNetValue,
  operation_id AS OperationID,
  po_amount AS PurchaseOrderAmount,
  po_currency AS PurchaseOrderCurrency,
  posnr AS ABDItemNumber,
  post_date AS SettlementPostingDate,
  prctr AS ProfitCenter,
  pstl_active AS IsProvisionalSettlmtActive,
  pterm AS PaymentTerms,
  ref_appldoc AS ReferenceApplicationDocument,
  ref_item AS ReferenceApplicationItem,
  ref_payer AS ReferencePayer,
  ref_plant AS ReferencePlant,
  ref_settl_cat AS ReferenceSettlementCategory,
  ref_side AS ReferenceApplicationSide,
  ref_stl_hdr AS ReferenceSettlemtUUID,
  ref_strg_agreement AS ReferenceStorageAreement,
  ref_strg_agreement_item AS ReferenceStorageAreementItem,
  ref_sub_item AS ReferenceApplicationSubItem,
  ref_vendor AS ReferenceVendor,
  run_date AS RunDate,
  sd_thres AS SDPayementThresholdPercentage,
  settl_doc AS SettlmtDoc,
  settl_scenario AS SettlementScenario,
  settl_type AS SettlementType,
  settl_yr AS SettlmtDocYear,
  header.side AS Side,
  split_flag AS SplitFlag,
  storage_end_date AS StorageEndDate,
  storage_start_date AS StorageStartDate,
  threshold_perc AS ThresholdPercentage,
  underfill_amount AS UnderfillAmount,
  wbeln AS ABDNumber,
  header.werks AS Plant,
  z_regio AS Region
FROM /accgo/t_stlhead AS header
;