I_SAFTACCOUNTINGITEM

CDS View
22 Fields 9 CDS Views

SAF-T Accounting Item

I_SAFTACCOUNTINGITEM is a CDS View in S/4HANA. SAF-T Accounting Item. It contains 22 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_PT_SAFTSlsInvoiceItmRef view union CONSUMPTION SAF-T PT Sales Invoice Item References
C_PT_SAFTSlsItemRef view_entity inner CONSUMPTION Sales Invoices Line References - Cube
I_PT_SAFTAccountingItem view from COMPOSITE SAF-T PT Accounting Item
I_PT_SAFTAccountingProduct view inner COMPOSITE SAF-T Accounting Product
I_PT_SAFTAcctgDownPaymentItm view from COMPOSITE SAF-T PT Accounting DownPayment Item
I_PT_SAFTAcctgDownPaytItmAmt view_entity from COMPOSITE Accounting Down Payment Doc Items Amount
I_PT_SAFTDownPaytAcctgItem view_entity from COMPOSITE Down Payment Accounting Document Item
P_PT_SAFTPAYMENTMECHANISM view inner COMPOSITE Private Payment Mechanism
P_SAFTACCTDWNPAYPRODUCT view inner COMPOSITE SAF-T Get Downpayment Products

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY FiscalYear FiscalYear 2
_CompanyCode _CompanyCode 2
_CompanyCodeCurrency _CompanyCodeCurrency 2
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 2
AccountingDocument AccountingDocument 2
AmountInCompanyCodeCurrency NetAmount 2
BaseUnit BaseUnit 2
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCodeCurrency,CompanyCurrency 3
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DocumentItemText DocumentItemText 2
GLAccount GLAccount 2
InvoiceReference InvoiceReference 3
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 3
Material Material 2
NetPriceAmount NetPriceAmount 2
Quantity Quantity 3
SpecialGLCode SpecialGLCode 1
TaxCode TaxCode 2
UnitOfMeasure UnitOfMeasure 2

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.

-- SAF-T Accounting Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SAFTACCOUNTINGITEM (
    COMPANYCODE,
    FISCALYEAR,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _GLACCOUNTINCHARTOFACCOUNTS,
    ACCOUNTINGDOCUMENT,
    AMOUNTINCOMPANYCODECURRENCY,
    BASEUNIT,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINCOCODECRCY,
    DOCUMENTITEMTEXT,
    GLACCOUNT,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    MATERIAL,
    NETPRICEAMOUNT,
    QUANTITY,
    SPECIALGLCODE,
    TAXCODE,
    UNITOFMEASURE,
    PRIMARY KEY (COMPANYCODE, FISCALYEAR)
);

Learn More