C_PT_SAFTPRELIMDOCUMENTCUBE

CDS View

Inf SAFT PT Workig Doc Hd - Cube

C_PT_SAFTPRELIMDOCUMENTCUBE is a CDS View in S/4HANA. Inf SAFT PT Workig Doc Hd - Cube. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PT_SAFTWrkgDocumentQuery view from CONSUMPTION SAFT PT Working Doc Hd - Qry

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY PortugueseInvoiceDate PortugueseInvoiceDate 1
KEY PT_SAFTDocumentNumber PT_SAFTDocumentNumber 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentBillingStatus DocumentBillingStatus 1
DocumentTransaction DocumentTransaction 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
PTDgtlSgntrSystemDateTimeText PTDgtlSgntrSystemDateTimeText 1
ReversalReasonName ReversalReasonName 1
SourceBillingDocumentType SourceBillingDocumentType 1
TotalGrossAmount TotalGrossAmount 1
TotalNetAmount TotalNetAmount 1
TotalTaxAmount TotalTaxAmount 1
TransactionCurrency TransactionCurrency 1
WorkTypeName WorkTypeName 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.

-- Inf SAFT PT Workig Doc Hd - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_PT_SAFTPRELIMDOCUMENTCUBE (
    COMPANYCODE,
    PORTUGUESEINVOICEDATE,
    PT_SAFTDOCUMENTNUMBER,
    COMPANYCODECURRENCY,
    DOCUMENTBILLINGSTATUS,
    DOCUMENTTRANSACTION,
    EXCHANGERATE,
    FISCALPERIOD,
    INVOICEAMOUNTINFRGNCURRENCY,
    LASTCHANGEDATETIMETEXT,
    LASTCHANGEDBYUSER,
    PORTUGUESECUSTOMERWITHVERSION,
    PORTUGUESEDGTLSGNTRKEYVERSION,
    PORTUGUESEDIGITALSIGNATURE,
    PTDGTLSGNTRSYSTEMDATETIMETEXT,
    REVERSALREASONNAME,
    SOURCEBILLINGDOCUMENTTYPE,
    TOTALGROSSAMOUNT,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY,
    WORKTYPENAME,
    PRIMARY KEY (COMPANYCODE, PORTUGUESEINVOICEDATE, PT_SAFTDOCUMENTNUMBER)
);