P_MY_TXITMWITHSLSDEDUCTIONAMT

CDS View
21 Fields 1 CDS Views

P_MY_TXITMWITHSLSDEDUCTIONAMT is a CDS View in S/4HANA. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MY_TxItmWithSlsDeductionProd view from COMPOSITE

Fields (21)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY TaxCode TaxCode 1
KEY TransactionTypeDetermination TransactionTypeDetermination 1
AccountingDocumentType AccountingDocumentType 1
AdditionalCurrency1 AdditionalCurrency1 1
AdditionalCurrency2 AdditionalCurrency2 1
BusinessPlace BusinessPlace 1
CAReconciliationKey CAReconciliationKey 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
FiscalPeriod FiscalPeriod 1
GLAccount GLAccount 1
PostingDate PostingDate 1
ReferenceDocumentType ReferenceDocumentType 1
StatryRptRun StatryRptRun 1
TaxJurisdiction TaxJurisdiction 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
TaxType TaxType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MY_TXITMWITHSLSDEDUCTIONAMT (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    TAXCODE,
    TRANSACTIONTYPEDETERMINATION,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    BUSINESSPLACE,
    CARECONCILIATIONKEY,
    COMPANYCODECURRENCY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    FISCALPERIOD,
    GLACCOUNT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    STATRYRPTRUN,
    TAXJURISDICTION,
    TAXRATEVALIDITYSTARTDATE,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, TAXCODE, TRANSACTIONTYPEDETERMINATION)
);

Learn More