I_ASTRTRMTOBLGNONETMEPOSTGDATA
One Time Posting Data for ARO
I_ASTRTRMTOBLGNONETMEPOSTGDATA is a CDS View in S/4HANA. One Time Posting Data for ARO. It contains 18 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ARO_DDL_OneTmePostgAmt_Subproc | view | from | One time posting amt with Sub Processes | |
| C_AstRtrmtOblgnOneTmePostgData | view | from | CONSUMPTION | ARO OTP Data Page |
Fields (18)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 1 |
| KEY | AssetRetirementObligationUUID | AssetRetirementObligationUUID | 1 |
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | FiscalYear | FiscalYear | 1 |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 1 | |
| AROAccountingPrinciple | AROAccountingPrinciple | 1 | |
| AROPostingDocumentDate | AROPostingDocumentDate | 1 | |
| AROPostingDocumentNumber | AROPostingDocumentNumber | 1 | |
| AROPostingItemText | AROPostingItemText | 1 | |
| AROPostingObjectKey | AROPostingObjectKey | 1 | |
| AROPostingPeriodAmount | AROPostingPeriodAmount | 1 | |
| AROTransactionCurrency | AROTransactionCurrency | 1 | |
| AssetRetirementOblgnNumber | AssetRetirementOblgnNumber | 1 | |
| AssetRetirementObligationType | AssetRetirementObligationType | 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.
-- One Time Posting Data for ARO
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASTRTRMTOBLGNONETMEPOSTGDATA (
ACCOUNTINGDOCUMENT,
ASSETRETIREMENTOBLIGATIONUUID,
COMPANYCODE,
FISCALYEAR,
AMOUNTINCOMPANYCODECURRENCY,
AROACCOUNTINGPRINCIPLE,
AROPOSTINGDOCUMENTDATE,
AROPOSTINGDOCUMENTNUMBER,
AROPOSTINGITEMTEXT,
AROPOSTINGOBJECTKEY,
AROPOSTINGPERIODAMOUNT,
AROTRANSACTIONCURRENCY,
ASSETRETIREMENTOBLGNNUMBER,
ASSETRETIREMENTOBLIGATIONTYPE,
COMPANYCODECURRENCY,
FISCALYEARVARIANT,
POSTINGPERIOD,
SOURCELEDGER,
PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETRETIREMENTOBLIGATIONUUID, COMPANYCODE, FISCALYEAR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA