_RETURNITEM

_RETURNITEM is an SAP database table in S/4HANA. It contains 69 fields.

Fields (69)

KeyField CDS FieldsUsed in Views
KEY CADocumentNumber CADocumentNumber 1
KEY CompanyCode CompanyCode 1
KEY CompanyCodeCountry CompanyCodeCountry 1
KEY TaxCode TaxCode 1
_BillingDocumentBasic _BillingDocumentBasic 1
_BPLine _BPLine 1
_BusinessPartner _BusinessPartner 1
_CADoc _CADoc 1
_CAInvcgDocHeader _CAInvcgDocHeader 1
_CompanyCode _CompanyCode 1
_CompanyCodeCountry _CompanyCodeCountry 1
_GLLine _GLLine 1
_TaxCode _TaxCode 1
BusinessPartner BusinessPartner 1
BusinessPlace BusinessPlace 1
CA1stCountrySpecificReference CA1stCountrySpecificReference 1
CAApplicationArea CAApplicationArea 1
CAClearingDocumentNumber CAClearingDocumentNumber 1
CADocumentOriginCode CADocumentOriginCode 1
CADocumentType CADocumentType 1
CADocumentTypeForGLTransfer CADocumentTypeForGLTransfer 1
CAExchangeRate CAExchangeRate 1
CAFirstCountrySpecificDate CAFirstCountrySpecificDate 1
CAGLItemNumber CAGLItemNumber 1
CAInvoicingDocument CAInvoicingDocument 1
CAOfficialDocumentNumber CAOfficialDocumentNumber 1
CAPostingDate CAPostingDate 1
CAReconciliationKey CAReconciliationKey 1
CAReferenceDocument CAReferenceDocument 1
CARepetitionItemNumber CARepetitionItemNumber 1
CAReversalDocumentNumber CAReversalDocumentNumber 1
CAReversedDocumentNumber CAReversedDocumentNumber 1
CARptgSrceReference CARptgSrceReference 1
CARptgSrceRefType CARptgSrceRefType 1
CARptgTaxItemOriginType CARptgTaxItemOriginType 1
CASubItemNumber CASubItemNumber 1
CATaxAmountInLocalCurrency CATaxAmountInLocalCurrency 1
CATaxAmountInTransCurrency CATaxAmountInTransCurrency 1
CATaxBaseAmountInLocalCurrency CATaxBaseAmountInLocalCurrency 1
CATaxDate CATaxDate 1
CATaxRate CATaxRate 1
CATransactionKeyAccountDetn CATransactionKeyAccountDetn 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionType ConditionType 1
ContractAccount ContractAccount 1
CreationDate CreationDate 1
DocumentDate DocumentDate 1
GLAccount GLAccount 1
IsReversal IsReversal 1
IsReversed IsReversed 1
LedgerGroup LedgerGroup 1
LogicalSystem LogicalSystem 1
OriginalReferenceDocument OriginalReferenceDocument 1
ReferenceDocumentType ReferenceDocumentType 1
ReportingCountry ReportingCountry 1
ReportingCurrency ReportingCurrency 1
Segment Segment 1
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 1
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCalculationProcedure TaxCalculationProcedure 1
TaxCountry TaxCountry 1
TaxFulfillmentDate TaxFulfillmentDate 1
TaxJurisdiction TaxJurisdiction 1
TaxReportingDate TaxReportingDate 1
TaxType TaxType 1
TransactionCurrency TransactionCurrency 1
TransToTaxCntryCrcyCnvrsnFctr TransToTaxCntryCrcyCnvrsnFctr 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _RETURNITEM (
    CADOCUMENTNUMBER,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    TAXCODE,
    _BILLINGDOCUMENTBASIC,
    _BPLINE,
    _BUSINESSPARTNER,
    _CADOC,
    _CAINVCGDOCHEADER,
    _COMPANYCODE,
    _COMPANYCODECOUNTRY,
    _GLLINE,
    _TAXCODE,
    BUSINESSPARTNER,
    BUSINESSPLACE,
    CA1STCOUNTRYSPECIFICREFERENCE,
    CAAPPLICATIONAREA,
    CACLEARINGDOCUMENTNUMBER,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CADOCUMENTTYPEFORGLTRANSFER,
    CAEXCHANGERATE,
    CAFIRSTCOUNTRYSPECIFICDATE,
    CAGLITEMNUMBER,
    CAINVOICINGDOCUMENT,
    CAOFFICIALDOCUMENTNUMBER,
    CAPOSTINGDATE,
    CARECONCILIATIONKEY,
    CAREFERENCEDOCUMENT,
    CAREPETITIONITEMNUMBER,
    CAREVERSALDOCUMENTNUMBER,
    CAREVERSEDDOCUMENTNUMBER,
    CARPTGSRCEREFERENCE,
    CARPTGSRCEREFTYPE,
    CARPTGTAXITEMORIGINTYPE,
    CASUBITEMNUMBER,
    CATAXAMOUNTINLOCALCURRENCY,
    CATAXAMOUNTINTRANSCURRENCY,
    CATAXBASEAMOUNTINLOCALCURRENCY,
    CATAXDATE,
    CATAXRATE,
    CATRANSACTIONKEYACCOUNTDETN,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    CONTRACTACCOUNT,
    CREATIONDATE,
    DOCUMENTDATE,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LEDGERGROUP,
    LOGICALSYSTEM,
    ORIGINALREFERENCEDOCUMENT,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    SEGMENT,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCALCULATIONPROCEDURE,
    TAXCOUNTRY,
    TAXFULFILLMENTDATE,
    TAXJURISDICTION,
    TAXREPORTINGDATE,
    TAXTYPE,
    TRANSACTIONCURRENCY,
    TRANSTOTAXCNTRYCRCYCNVRSNFCTR,
    PRIMARY KEY (CADOCUMENTNUMBER, COMPANYCODE, COMPANYCODECOUNTRY, TAXCODE)
);