FACRA_ACCRUAL_PO_WITHOUT_AMNT

DDL: FACRA_ACCRUAL_PO_WITHOUT_AMNT SQL: ACCRPONOAMT Type: view Package: FI_GL_POAC
63 Fields 1 Data Sources

PO Without Amount Fields

FACRA_ACCRUAL_PO_WITHOUT_AMNT is a CDS View that provides data about "PO Without Amount Fields" in SAP S/4HANA. It reads from 1 data source (C_PurchaseOrderAccrual) and exposes 63 fields with key fields AccrualEngineApplication, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject. Part of development package FI_GL_POAC.

Data Sources (1)

SourceAliasJoin Type
C_PurchaseOrderAccrual C_PurchaseOrderAccrual from

Parameters (1)

NameTypeDefault
P_KeyDate date

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ACCRPONOAMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PO Without Amount Fields view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.updateEnabled true view
AbapCatalog.preserveKey true view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineApplication AccrualEngineApplication
KEY AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccrualObject AccrualObject External Reference of Accrual Object
KEY AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
KEY AccrualItemType AccrualItemType Accrual Item Type
KEY Ledger Ledger Ledger
KEY LedgerGroup LedgerGroup Ledger Group
KEY AccrualPeriodEndDate AccrualPeriodEndDate Last Day of Period
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
GLAccount GLAccount General Ledger
GLAccountLongName GLAccountLongName Long Text
CostCenter CostCenter Cost Center
CostCenterDescription CostCenterDescription Description
ProfitCenter ProfitCenter Profit Center
ProfitCenterName ProfitCenterName Profit Center Name
InternalOrder InternalOrder Order
GoodsRecipientName GoodsRecipientName Recipient Name
BusinessArea BusinessArea Business Area
Material Material Vehicle Model
PurchaseOrderItemCurrency PurchaseOrderItemCurrency
PurchaseOrderItemNetAmount PurchaseOrderItemNetAmount
PurchasingGroup PurchasingGroup Purchasing Group
RequisitionerName RequisitionerName Requisitioner
Supplier Supplier Supplier
ProductType ProductType Product Type Group
CreatedByUser CreatedByUser User Name
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
ControllingArea ControllingArea Controlling Area
WBSElementInternalID WBSElementInternalID WBS Internal ID
AccrSubobjPauseDate AccrSubobjPauseDate
AccrSubobjSuspensionDate AccrSubobjSuspensionDate
AccrSubobjPrematureFinishDate AccrSubobjPrematureFinishDate
AccrSubobjectLifeCycleStatus AccrSubobjectLifeCycleStatus
AccrObjectLastChangeDateTime AccrObjectLastChangeDateTime
AccrSubobjectItmValdtyEndDte AccrSubobjectItmValdtyEndDte To
TotalAccrualQuantity TotalAccrualQuantity Total Qty to Accrue
UnitOfMeasure UnitOfMeasure Unit Protected Qty
AccrualCalculationMethod AccrualCalculationMethod
AccrSubobjHdrStartOfLifeDate AccrSubobjHdrStartOfLifeDate Start of Life
AccrSubobjHdrEndOfLifeDate AccrSubobjHdrEndOfLifeDate End of Life
AccrualItemIsObsolete AccrualItemIsObsolete Obsolete
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
CostCenterGroup CostCenterGroup
ProfitCenterGroup ProfitCenterGroup
_CostCenterText _CostCenterText
_ProfitCenterText _ProfitCenterText
_Posted _Posted
_PurchaseOrderAccrual _PurchaseOrderAccrual
_CompanyCode _CompanyCode
_Supplier _Supplier
_GLAccountTextInCompanyCode _GLAccountTextInCompanyCode
_WBSElement _WBSElement

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 FACRA_ACCRUAL_PO_WITHOUT_AMNT.
-- 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: ACCRPONOAMT
-- Parameters: P_KeyDate : date

CREATE VIEW FACRA_ACCRUAL_PO_WITHOUT_AMNT AS
SELECT
  AccrualEngineApplication,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  LedgerGroup,
  AccrualPeriodEndDate,
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  SalesOrder,
  SalesOrderItem,
  GLAccount,
  GLAccountLongName,
  CostCenter,
  CostCenterDescription,
  ProfitCenter,
  ProfitCenterName,
  InternalOrder,
  GoodsRecipientName,
  BusinessArea,
  Material,
  PurchaseOrderItemCurrency,
  PurchaseOrderItemNetAmount,
  PurchasingGroup,
  RequisitionerName,
  Supplier,
  ProductType,
  CreatedByUser,
  IsCompletelyDelivered,
  PurchasingDocumentItemText,
  InvoiceIsExpected,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  ControllingArea,
  WBSElementInternalID,
  AccrSubobjPauseDate,
  AccrSubobjSuspensionDate,
  AccrSubobjPrematureFinishDate,
  AccrSubobjectLifeCycleStatus,
  AccrObjectLastChangeDateTime,
  AccrSubobjectItmValdtyEndDte,
  TotalAccrualQuantity,
  UnitOfMeasure,
  AccrualCalculationMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  FiscalYear,
  FiscalPeriod,
  CostCenterGroup,
  ProfitCenterGroup
FROM C_PurchaseOrderAccrual
;

Learn More