P_CN_TAXINPUTINVC
P_CN_TAXINPUTINVC is a CDS View in S/4HANA. It contains 59 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CN_TaxInputInvc | view | from | BASIC | Incoming VAT Invoice |
| I_CN_TaxInputInvcMng | view | from | BASIC | Incoming VAT Invoice |
Fields (59)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CN_TaxInvcUUID | CN_TaxInvcUUID | 2 |
| CN_BlueInvoiceNumber | CN_BlueInvoiceNumber | 1 | |
| CN_GoldenTaxSystemResultString | CN_GoldenTaxSystemResultString | 1 | |
| CN_GoldenTaxSystemRiskLevel | CN_GoldenTaxSystemRiskLevel | 1 | |
| CN_InvoiceLatestPostingDate | CN_InvoiceLatestPostingDate | 1 | |
| CN_InvoicePostingPeriod | CN_InvoicePostingPeriod | 1 | |
| CN_InvoicePostingType | CN_InvoicePostingType | 1 | |
| CN_InvoiceSpecificElement | CN_InvoiceSpecificElement | 1 | |
| CN_TaxDeclnMonth | CN_TaxDeclnMonth | 2 | |
| CN_TaxDeclnTime | CN_TaxDeclnTime | 2 | |
| CN_TaxDeclnYear | CN_TaxDeclnYear | 2 | |
| CN_TaxEntityID | CN_TaxEntityID | 2 | |
| CN_TaxInvcCode | CN_TaxInvcCode | 2 | |
| CN_TaxInvcComment | CN_TaxInvcComment | 2 | |
| CN_TaxInvcCrcy | CN_TaxInvcCrcy | 2 | |
| CN_TaxInvcDate | CN_TaxInvcDate | 2 | |
| CN_TaxInvcDeductAmtInInvcCrcy | CN_TaxInvcDeductAmtInInvcCrcy | 1 | |
| CN_TaxInvcDeductionType | CN_TaxInvcDeductionType | 2 | |
| CN_TaxInvcDiscNetAmtInInvcCrcy | CN_TaxInvcDiscNetAmtInInvcCrcy | 2 | |
| CN_TaxInvcDiscTaxAmtInInvcCrcy | CN_TaxInvcDiscTaxAmtInInvcCrcy | 2 | |
| CN_TaxInvcGldnTxSystSts | CN_TaxInvcGldnTxSystSts | 2 | |
| CN_TaxInvcGldnTxSystStsSyncTme | CN_TaxInvcGldnTxSystStsSyncTme | 2 | |
| CN_TaxInvcInptProcgSts | CN_TaxInvcInptProcgSts | 2 | |
| CN_TaxInvcIsElectronic | CN_TaxInvcIsElectronic | 2 | |
| CN_TaxInvcNetAmtInInvcCrcy | CN_TaxInvcNetAmtInInvcCrcy | 2 | |
| CN_TaxInvcNmbr | CN_TaxInvcNmbr | 2 | |
| CN_TaxInvcTaxAmtInInvcCrcy | CN_TaxInvcTaxAmtInInvcCrcy | 2 | |
| CN_TaxInvcType | CN_TaxInvcType | 2 | |
| CN_TaxInvcVehTotAmtInInvcCrcy | CN_TaxInvcVehTotAmtInInvcCrcy | 1 | |
| CN_TaxInvoiceDataSource | CN_TaxInvoiceDataSource | 1 | |
| CN_TaxInvoiceExpenseReportNmbr | CN_TaxInvoiceExpenseReportNmbr | 1 | |
| CN_TaxInvoiceUsage | CN_TaxInvoiceUsage | 1 | |
| CN_TaxInvoiceVehFactoryModel | CN_TaxInvoiceVehFactoryModel | 1 | |
| CN_TaxInvoiceVehicleCertNumber | CN_TaxInvoiceVehicleCertNumber | 1 | |
| CN_TaxInvoiceVehicleEngineNmbr | CN_TaxInvoiceVehicleEngineNmbr | 1 | |
| CN_TaxInvoiceVehicleInspNumber | CN_TaxInvoiceVehicleInspNumber | 1 | |
| CN_TaxInvoiceVehicleNumber | CN_TaxInvoiceVehicleNumber | 1 | |
| CN_TaxInvoiceVehicleProdnPlace | CN_TaxInvoiceVehicleProdnPlace | 1 | |
| CN_TaxInvoiceVehicleTonnage | CN_TaxInvoiceVehicleTonnage | 1 | |
| CN_TaxInvoiceVehicleType | CN_TaxInvoiceVehicleType | 1 | |
| CN_TaxInvoiceVehImportCertNmbr | CN_TaxInvoiceVehImportCertNmbr | 1 | |
| CN_TaxInvoiceVehPassengerLimit | CN_TaxInvoiceVehPassengerLimit | 1 | |
| CN_TaxInvoiceVehTxnRecordNmbr | CN_TaxInvoiceVehTxnRecordNmbr | 1 | |
| CN_TaxSellerName | CN_TaxSellerName | 2 | |
| CompanyCode | CompanyCode | 2 | |
| CreatedByUser | CreatedByUser | 2 | |
| CreationUTCDateTime | CreationUTCDateTime | 2 | |
| FiscalYear | FiscalYear | 2 | |
| IsDeleted | IsDeleted | 2 | |
| IsPostedOnAccount | IsPostedOnAccount | 1 | |
| LastChangeDateTime | LastChangeDateTime | 2 | |
| LastChangedByUser | LastChangedByUser | 2 | |
| PurchasingGroup | PurchasingGroup | 2 | |
| PurchasingOrganization | PurchasingOrganization | 2 | |
| Supplier | Supplier | 2 | |
| TaxCategory | TaxCategory | 2 | |
| TaxInvoiceDeclarationTypeCode | TaxInvoiceDeclarationTypeCode | 1 | |
| TaxInvoiceIsTaxRebate | TaxInvoiceIsTaxRebate | 1 | |
| TaxRate | TaxRate | 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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CN_TAXINPUTINVC (
CN_TAXINVCUUID,
CN_BLUEINVOICENUMBER,
CN_GOLDENTAXSYSTEMRESULTSTRING,
CN_GOLDENTAXSYSTEMRISKLEVEL,
CN_INVOICELATESTPOSTINGDATE,
CN_INVOICEPOSTINGPERIOD,
CN_INVOICEPOSTINGTYPE,
CN_INVOICESPECIFICELEMENT,
CN_TAXDECLNMONTH,
CN_TAXDECLNTIME,
CN_TAXDECLNYEAR,
CN_TAXENTITYID,
CN_TAXINVCCODE,
CN_TAXINVCCOMMENT,
CN_TAXINVCCRCY,
CN_TAXINVCDATE,
CN_TAXINVCDEDUCTAMTININVCCRCY,
CN_TAXINVCDEDUCTIONTYPE,
CN_TAXINVCDISCNETAMTININVCCRCY,
CN_TAXINVCDISCTAXAMTININVCCRCY,
CN_TAXINVCGLDNTXSYSTSTS,
CN_TAXINVCGLDNTXSYSTSTSSYNCTME,
CN_TAXINVCINPTPROCGSTS,
CN_TAXINVCISELECTRONIC,
CN_TAXINVCNETAMTININVCCRCY,
CN_TAXINVCNMBR,
CN_TAXINVCTAXAMTININVCCRCY,
CN_TAXINVCTYPE,
CN_TAXINVCVEHTOTAMTININVCCRCY,
CN_TAXINVOICEDATASOURCE,
CN_TAXINVOICEEXPENSEREPORTNMBR,
CN_TAXINVOICEUSAGE,
CN_TAXINVOICEVEHFACTORYMODEL,
CN_TAXINVOICEVEHICLECERTNUMBER,
CN_TAXINVOICEVEHICLEENGINENMBR,
CN_TAXINVOICEVEHICLEINSPNUMBER,
CN_TAXINVOICEVEHICLENUMBER,
CN_TAXINVOICEVEHICLEPRODNPLACE,
CN_TAXINVOICEVEHICLETONNAGE,
CN_TAXINVOICEVEHICLETYPE,
CN_TAXINVOICEVEHIMPORTCERTNMBR,
CN_TAXINVOICEVEHPASSENGERLIMIT,
CN_TAXINVOICEVEHTXNRECORDNMBR,
CN_TAXSELLERNAME,
COMPANYCODE,
CREATEDBYUSER,
CREATIONUTCDATETIME,
FISCALYEAR,
ISDELETED,
ISPOSTEDONACCOUNT,
LASTCHANGEDATETIME,
LASTCHANGEDBYUSER,
PURCHASINGGROUP,
PURCHASINGORGANIZATION,
SUPPLIER,
TAXCATEGORY,
TAXINVOICEDECLARATIONTYPECODE,
TAXINVOICEISTAXREBATE,
TAXRATE,
PRIMARY KEY (CN_TAXINVCUUID)
);
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