C_PT_SAFTWORKINGDOCITEMC

CDS View
22 Fields 2 CDS Views

SAF-T PT Working Documents Item Cube

C_PT_SAFTWORKINGDOCITEMC is a CDS View in S/4HANA. SAF-T PT Working Documents Item Cube. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PT_SAFTWorkingDocItemQry view from CONSUMPTION SAF-T PT Working Documents Item Query
C_PT_SAFTWorkingDocTotalCheck view from CONSUMPTION SAF-T PT Working Documents Total Check

Fields (22)

KeyField CDS FieldsUsed in Views
KEY DocumentItemNumber DocumentItemNumber 1
KEY PortugueseInvoiceNumber PortugueseInvoiceNumber 1
BillingDocumentItemText BillingDocumentItemText 1
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy 1
CompanyCode CompanyCode 1
CompanyCurrency CompanyCurrency 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
ExemptionReason ExemptionReason 1
ExemptionReasonText ExemptionReasonText 1
MaterialName MaterialName 1
NetPriceAmount NetPriceAmount 1
PortugueseInvoiceDate PortugueseInvoiceDate 1
PortugueseMaterialWithVersion PortugueseMaterialWithVersion 1
Quantity Quantity 1
TargetTaxCode TargetTaxCode 1
TaxAmount TaxAmount 1
TaxRate TaxRate 1
TaxReportingDate TaxReportingDate 1
TaxReturnCountry TaxReturnCountry 1
TaxType TaxType 1
UnitOfMeasureName UnitOfMeasureName 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.

-- SAF-T PT Working Documents Item Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_PT_SAFTWORKINGDOCITEMC (
    DOCUMENTITEMNUMBER,
    PORTUGUESEINVOICENUMBER,
    BILLINGDOCUMENTITEMTEXT,
    CASHDISCOUNTAMTINCOCODECRCY,
    COMPANYCODE,
    COMPANYCURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINCOCODECRCY,
    EXEMPTIONREASON,
    EXEMPTIONREASONTEXT,
    MATERIALNAME,
    NETPRICEAMOUNT,
    PORTUGUESEINVOICEDATE,
    PORTUGUESEMATERIALWITHVERSION,
    QUANTITY,
    TARGETTAXCODE,
    TAXAMOUNT,
    TAXRATE,
    TAXREPORTINGDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    UNITOFMEASURENAME,
    PRIMARY KEY (DOCUMENTITEMNUMBER, PORTUGUESEINVOICENUMBER)
);

Learn More