I_AROACCTPOSTINGLINEITEMDATA

CDS View
15 Fields 2 CDS Views

ARO Account Posting Line Item Data

I_AROACCTPOSTINGLINEITEMDATA is a CDS View in S/4HANA. ARO Account Posting Line Item Data. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AstRtrmtOblgnAssetData view inner COMPOSITE Asset Information of ARO
I_AstRtrmtOblgnOneTmePostgData view from COMPOSITE One Time Posting Data for ARO

Fields (15)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AROAssetClass AROAssetClass 1
AROPostingDocumentDate AROPostingDocumentDate 1
AROPostingItemText AROPostingItemText 1
AROPostingPeriodAmount AROPostingPeriodAmount 1
AROTransactionCurrency AROTransactionCurrency 1
AssetRtrmtOblgnAssetNumber MasterFixedAsset 1
AssetRtrmtOblgnAssetSubNumber FixedAsset 1
CompanyCodeCurrency CompanyCodeCurrency 1
FiscalYearVariant FiscalYearVariant 1
PostingPeriod PostingPeriod 1
SourceLedger SourceLedger 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- ARO Account Posting Line Item Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_AROACCTPOSTINGLINEITEMDATA (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    AMOUNTINCOMPANYCODECURRENCY,
    AROASSETCLASS,
    AROPOSTINGDOCUMENTDATE,
    AROPOSTINGITEMTEXT,
    AROPOSTINGPERIODAMOUNT,
    AROTRANSACTIONCURRENCY,
    ASSETRTRMTOBLGNASSETNUMBER,
    ASSETRTRMTOBLGNASSETSUBNUMBER,
    COMPANYCODECURRENCY,
    FISCALYEARVARIANT,
    POSTINGPERIOD,
    SOURCELEDGER,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More