C_PT_SAFTSALESINVOICEHEADERC

CDS View
29 Fields 2 CDS Views

SAF-T PT Sales Invoice Header Cube

C_PT_SAFTSALESINVOICEHEADERC is a CDS View in S/4HANA. SAF-T PT Sales Invoice Header Cube. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PT_SAFTSalesInvoiceHeaderQry view from CONSUMPTION SAF-T PT Sales Invoice Header Query
C_PT_SAFTSlsInvoiceNmbrEntries view from CONSUMPTION SAF-T PT Sales Invoice Number Entries

Fields (29)

KeyField CDS FieldsUsed in Views
KEY PortugueseInvoiceNumber PortugueseInvoiceNumber 1
CashDiscount1DueDate CashDiscount1DueDate 1
CashDiscount2DueDate CashDiscount2DueDate 1
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy 1
CashDiscountAmtInTransacCrcy CashDiscountAmtInTransacCrcy 1
CompanyCode CompanyCode 2
CreatedByUser CreatedByUser 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPaymentTermsName CustomerPaymentTermsName 1
DocumentBillingStatus DocumentBillingStatus 1
DocumentTransaction DocumentTransaction 1
DocumentType DocumentType 1
ExchangeRate ExchangeRate 1
FiscalPeriod FiscalPeriod 1
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency 1
LastChangeDateTimeText LastChangeDateTimeText 1
LastChangedByUser LastChangedByUser 1
PortugueseCustomerWithVersion PortugueseCustomerWithVersion 1
PortugueseDgtlSgntrKeyVersion PortugueseDgtlSgntrKeyVersion 1
PortugueseDigitalSignature PortugueseDigitalSignature 1
PortugueseInvoiceDate PortugueseInvoiceDate 1
PTDgtlSgntrSystemDateTimeText PTDgtlSgntrSystemDateTimeText 1
ReversalReason ReversalReason 1
ReversalReasonName ReversalReasonName 1
SourceBillingDocumentType SourceBillingDocumentType 1
TotalGrossAmount TotalGrossAmount 1
TotalNetAmount TotalNetAmount 1
TotalTaxAmount TotalTaxAmount 1
TransactionCurrency TransactionCurrency 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 Sales Invoice Header Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_PT_SAFTSALESINVOICEHEADERC (
    PORTUGUESEINVOICENUMBER,
    CASHDISCOUNT1DUEDATE,
    CASHDISCOUNT2DUEDATE,
    CASHDISCOUNTAMTINCOCODECRCY,
    CASHDISCOUNTAMTINTRANSACCRCY,
    COMPANYCODE,
    CREATEDBYUSER,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPAYMENTTERMSNAME,
    DOCUMENTBILLINGSTATUS,
    DOCUMENTTRANSACTION,
    DOCUMENTTYPE,
    EXCHANGERATE,
    FISCALPERIOD,
    INVOICEAMOUNTINFRGNCURRENCY,
    LASTCHANGEDATETIMETEXT,
    LASTCHANGEDBYUSER,
    PORTUGUESECUSTOMERWITHVERSION,
    PORTUGUESEDGTLSGNTRKEYVERSION,
    PORTUGUESEDIGITALSIGNATURE,
    PORTUGUESEINVOICEDATE,
    PTDGTLSGNTRSYSTEMDATETIMETEXT,
    REVERSALREASON,
    REVERSALREASONNAME,
    SOURCEBILLINGDOCUMENTTYPE,
    TOTALGROSSAMOUNT,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (PORTUGUESEINVOICENUMBER)
);

Learn More