I_SAFTACCOUNTINGITEM

CDS View
22 Fields 6 CDS Views

SAF-T Accounting Item

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_PT_SAFTSlsInvoiceItmRef view union CONSUMPTION SAF-T PT Sales Invoice Item References
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
P_PT_SAFTPAYMENTMECHANISM view inner COMPOSITE
P_SAFTACCTDWNPAYPRODUCT view inner COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
_CompanyCode _CompanyCode 2
_CompanyCodeCurrency _CompanyCodeCurrency 2
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 2
AccountingDocument AccountingDocument 2
AmountInCompanyCodeCurrency NetAmount 2
BaseUnit BaseUnit 2
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCurrency 2
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DocumentItemText DocumentItemText 2
FiscalYear FiscalYear 2
GLAccount GLAccount 2
InvoiceReference InvoiceReference 2
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 2
Material Material 2
NetPriceAmount NetPriceAmount 1
Quantity Quantity 2
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,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _GLACCOUNTINCHARTOFACCOUNTS,
    ACCOUNTINGDOCUMENT,
    AMOUNTINCOMPANYCODECURRENCY,
    BASEUNIT,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINCOCODECRCY,
    DOCUMENTITEMTEXT,
    FISCALYEAR,
    GLACCOUNT,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    MATERIAL,
    NETPRICEAMOUNT,
    QUANTITY,
    SPECIALGLCODE,
    TAXCODE,
    UNITOFMEASURE,
    PRIMARY KEY (COMPANYCODE)
);

Learn More