P_KZ_VATRETURNMAINSECTION_RND

CDS View
37 Fields 5 CDS Views

Selection for Main Section

P_KZ_VATRETURNMAINSECTION_RND is a CDS View in S/4HANA. Selection for Main Section. It contains 37 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_KZ_VATRETSECTION1SUBTOTALS1 view from COMPOSITE Section 1: Read customer country
P_KZ_VATRETSECTION1SUBTOTALS3 view from COMPOSITE Section 1: Merge all subtotals
P_KZ_VATRETSECTION2SUBTOTALS1 view from COMPOSITE Section 2: Calculate subtotals
P_KZ_VATRETSECTION4SUBTOTALS1 view from COMPOSITE Section 4: Calculate subtotals
P_KZ_VATRETSECTION6SUBTOTALS1 view from COMPOSITE Section 6: Calculate subtotals

Fields (37)

KeyField CDS FieldsUsed in Views
_CustomerText _CustomerText 1
_SupplierText _SupplierText 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocument AccountingDocument 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
BusinessTransactionType BusinessTransactionType 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
Customer Customer 1
DebitCreditCode DebitCreditCode 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
DocumentReferenceID DocumentReferenceID 1
FiscalYear FiscalYear 1
KZ_LineItem KZ_LineItem 1
OperationCode OperationCode 1
OriginalReferenceDocument OriginalReferenceDocument 1
PostingDate PostingDate 1
Reference1InDocumentHeader Reference1InDocumentHeader 1
Reference2InDocumentHeader Reference2InDocumentHeader 1
ReferenceDocumentType ReferenceDocumentType 1
SenderLogicalSystem SenderLogicalSystem 1
StatryRptCategory StatryRptCategory 1
StatryRptgEntity StatryRptgEntity 1
StatryRptRunID StatryRptRunID 1
Supplier Supplier 1
TaxAmount TaxAmount 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCode TaxCode 1
TaxNumber3 TaxNumber3 1
TaxReportingDate TaxReportingDate 1
TransactionTypeDetermination TransactionTypeDetermination 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.

-- Selection for Main Section
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_KZ_VATRETURNMAINSECTION_RND (
    _CUSTOMERTEXT,
    _SUPPLIERTEXT,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    FISCALYEAR,
    KZ_LINEITEM,
    OPERATIONCODE,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCE1INDOCUMENTHEADER,
    REFERENCE2INDOCUMENTHEADER,
    REFERENCEDOCUMENTTYPE,
    SENDERLOGICALSYSTEM,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIER,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXNUMBER3,
    TAXREPORTINGDATE,
    TRANSACTIONTYPEDETERMINATION
);

Learn More