R_TRDGDOCITEMBASIC

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.

-- Trading Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_TRDGDOCITEMBASIC (
    TRADINGDOCUMENT,
    TRADINGDOCUMENTITEM,
    _BASEUNIT,
    _BATCH,
    _BUSINESSAREA,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CREATEDBYUSER,
    _ITEMBILLINGBLOCKREASON,
    _ORIGINALLYREQUESTEDPRODUCT,
    _PLANT,
    _PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTHIERARCHYNODE,
    _PURGDOCUMENTITEMCATEGORY,
    _SALESDOCUMENTRJCNREASON,
    _SALESSPCFCPRODUCTGROUP1,
    _SALESSPCFCPRODUCTGROUP2,
    _SALESSPCFCPRODUCTGROUP3,
    _SALESSPCFCPRODUCTGROUP4,
    _SALESSPCFCPRODUCTGROUP5,
    _STORAGELOCATION,
    _TRADINGDOCUMENTSALESROUTE,
    _TRDGDOCADDLREFDOCITEM,
    _TRDGDOCADDLREFDOCUMENT,
    _TRDGDOCADDLREFDOCUMENTTYPE,
    _TRDGDOCCNDNCNSLDTNCAT,
    _TRDGDOCISHDGGRLVT,
    _TRDGDOCITEMBLOCKCODE,
    _TRDGDOCITEMCATEGORY,
    _TRDGDOCITEMISCOMPLETE,
    _TRDGDOCPRCDETNISINCMPLT,
    _TRDGDOCPRDCSSRDOCTYPE,
    _TRDGDOCPURGCURRENCY,
    _TRDGDOCPURGQUANTITYUNIT,
    _TRDGDOCPURGRSKRELEVANCY,
    _TRDGDOCPURGSHIPGCONDITION,
    _TRDGDOCPURGSHIPPINGPOINT,
    _TRDGDOCREFDOCITEM,
    _TRDGDOCREFDOCUMENT,
    _TRDGDOCREFDOCUMENTTYPE,
    _TRDGDOCSETTLEMENTMODE,
    _TRDGDOCSLSQUANTITYUNIT,
    _TRDGDOCSLSSHIPPINGPOINT,
    _TRDGDOCSLSVOLUMEUNIT,
    _TRDGDOCSLSWEIGHTUNIT,
    ACCOUNTASSIGNMENTCATEGORY,
    ALTERNATIVEBILLOFMATERIAL,
    BASEUNIT,
    BATCH,
    BATCHCLASSIFICATION,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANTUSAGE,
    BUSINESSAREA,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DOWNPAYMENTAMOUNT,
    GOODSRECEIPTLATESTCREATIONDATE,
    INTERNATIONALARTICLENUMBER,
    ISSUINGSTORAGELOCATION,
    ITEMBILLINGBLOCKREASON,
    MAXNMBROFPARTIALDELIVERY,
    ORGANIZATIONDIVISION,
    PARTIALDELIVERYISALLOWED,
    PAYMENTGUARANTEEFORM,
    PLANT,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PRODUCTTAXCLASSIFICATION1,
    PRODUCTTAXCLASSIFICATION2,
    PRODUCTTAXCLASSIFICATION3,
    PRODUCTTAXCLASSIFICATION4,
    PRODUCTTAXCLASSIFICATION5,
    PRODUCTTAXCLASSIFICATION6,
    PRODUCTTAXCLASSIFICATION7,
    PRODUCTTAXCLASSIFICATION8,
    PRODUCTTAXCLASSIFICATION9,
    PRODUCTUSEDBYCUSTOMER,
    PROFITCENTER,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURGOVRDELIVTOLLMTRATIOINPCT,
    PURGUNDRDELIVTOLLMTRATIOINPCT,
    PURGUNLMTDOVRDELIVISALLWD,
    QUANTITYISFIXED,
    SALESDOCUMENTRJCNREASON,
    SALESSPCFCPRODUCTGROUP1,
    SALESSPCFCPRODUCTGROUP2,
    SALESSPCFCPRODUCTGROUP3,
    SALESSPCFCPRODUCTGROUP4,
    SALESSPCFCPRODUCTGROUP5,
    SLSOVRDELIVTOLLMTRATIOINPCT,
    SLSUNDRDELIVTOLLMTRATIOINPCT,
    SLSUNLMTDOVRDELIVISALLWD,
    STORAGELOCATION,
    SUPPLIERPRODUCTID,
    SUPPLIERTOTALGROSSAMOUNT,
    TRADINGDOCUMENTBUSINESSITEM,
    TRADINGDOCUMENTHIGHERLEVELITEM,
    TRADINGDOCUMENTINTERNALORDER,
    TRADINGDOCUMENTPURCHASINGROUTE,
    TRADINGDOCUMENTSALESROUTE,
    TRDGDOCADDLREFDOCITEM,
    TRDGDOCADDLREFDOCUMENT,
    TRDGDOCADDLREFDOCUMENTTYPE,
    TRDGDOCASSOCIATIONGROUP,
    TRDGDOCBILLOFMATERIAL,
    TRDGDOCBOMKEYDATE,
    TRDGDOCBOMPROFILE,
    TRDGDOCBUSINESSSCENARIO,
    TRDGDOCCNDNCNSLDTNCAT,
    TRDGDOCCNDNISCNSLDTD,
    TRDGDOCCOMMODITYDEFINITION,
    TRDGDOCCURRENCY,
    TRDGDOCHDGGRLVT,
    TRDGDOCISITEMRELEVANT,
    TRDGDOCITEMBLOCKCODE,
    TRDGDOCITEMCATEGORY,
    TRDGDOCITEMISCOMPLETE,
    TRDGDOCITEMISDELETED,
    TRDGDOCITEMISEXTENDED,
    TRDGDOCITEMTEXT,
    TRDGDOCITMPRTFLODETNDATE,
    TRDGDOCORIGLREQDPROD,
    TRDGDOCPRCDETNISINCOMPLETE,
    TRDGDOCPRCGREFPRODUCT,
    TRDGDOCPRDCSSRDOCUMENTTYPE,
    TRDGDOCPREDECESSORDOCUMENT,
    TRDGDOCPREDECESSORITEM,
    TRDGDOCPRODSIZEORDIMNDESC,
    TRDGDOCPRODUSGECAT,
    TRDGDOCPURCHASEORDERITEM,
    TRDGDOCPURGBOMITMQTY,
    TRDGDOCPURGCLFNOBJINTERNALID,
    TRDGDOCPURGCURRENCY,
    TRDGDOCPURGGROSSWEIGHT,
    TRDGDOCPURGISCSHDISCGRNTD,
    TRDGDOCPURGITEMNETAMOUNT,
    TRDGDOCPURGITMEFFCTVAMOUNT,
    TRDGDOCPURGITMNETAMTINPOCRCY,
    TRDGDOCPURGNETPRICEAMOUNT,
    TRDGDOCPURGNETPRICEQUANTITY,
    TRDGDOCPURGNETWEIGHT,
    TRDGDOCPURGPRICEUNIT,
    TRDGDOCPURGQUANTITY,
    TRDGDOCPURGQUANTITYUNIT,
    TRDGDOCPURGRISKRELEVANCY,
    TRDGDOCPURGSHIPPINGCONDITION,
    TRDGDOCPURGSHIPPINGPOINT,
    TRDGDOCPURGSUBTOTAL1AMOUNT,
    TRDGDOCPURGSUBTOTAL2AMOUNT,
    TRDGDOCPURGSUBTOTAL3AMOUNT,
    TRDGDOCPURGSUBTOTAL4AMOUNT,
    TRDGDOCPURGSUBTOTAL5AMOUNT,
    TRDGDOCPURGSUBTOTAL6AMOUNT,
    TRDGDOCPURGTAXAMOUNT,
    TRDGDOCPURGTAXCODE,
    TRDGDOCPURGTAXCOUNTRY,
    TRDGDOCPURGTAXDATE,
    TRDGDOCPURGTAXJURISDICTION,
    TRDGDOCPURGTOBASEQTYDNMNTR,
    TRDGDOCPURGTOBASEQTYNMRTR,
    TRDGDOCPURGTOORDQTYDNMNTR,
    TRDGDOCPURGTOORDQTYNMRTR,
    TRDGDOCPURGVOLUME,
    TRDGDOCREFDOCITEM,
    TRDGDOCREFDOCUMENT,
    TRDGDOCREFERENCEDOCUMENTTYPE,
    TRDGDOCRELTDDOCITMVALNTYPE,
    TRDGDOCSALESCURRENCY,
    TRDGDOCSALESNETPRICEAMOUNT,
    TRDGDOCSALESQUANTITY,
    TRDGDOCSETTLEMENTMODE,
    TRDGDOCSLSBOMITMQTY,
    TRDGDOCSLSCLFNOBJINTERNALID,
    TRDGDOCSLSGROSSWEIGHT,
    TRDGDOCSLSISCSHDISCGRNTD,
    TRDGDOCSLSITEMNETAMOUNT,
    TRDGDOCSLSITMEFFCTVAMOUNT,
    TRDGDOCSLSITMNETAMTINSLSCRCY,
    TRDGDOCSLSNETPRICEQUANTITY,
    TRDGDOCSLSNETWEIGHT,
    TRDGDOCSLSPRICEUNIT,
    TRDGDOCSLSQUANTITYUNIT,
    TRDGDOCSLSRISKRELEVANCY,
    TRDGDOCSLSSHIPPINGPOINT,
    TRDGDOCSLSSUBTOTAL1AMOUNT,
    TRDGDOCSLSSUBTOTAL2AMOUNT,
    TRDGDOCSLSSUBTOTAL3AMOUNT,
    TRDGDOCSLSSUBTOTAL4AMOUNT,
    TRDGDOCSLSSUBTOTAL5AMOUNT,
    TRDGDOCSLSSUBTOTAL6AMOUNT,
    TRDGDOCSLSTAXAMOUNT,
    TRDGDOCSLSTOBASEQTYDNMNTR,
    TRDGDOCSLSTOBASEQTYNMRTR,
    TRDGDOCSLSTOORDQTYDNMNTR,
    TRDGDOCSLSTOORDQTYNMRTR,
    TRDGDOCSLSVOLUME,
    TRDGDOCSLSVOLUMEUNIT,
    TRDGDOCSLSWEIGHTUNIT,
    TRDGDOCSTOPOSTINGLOGIC,
    TRDGPORTFOLIOINTERNALID,
    VALUATIONCATEGORY,
    PRIMARY KEY (TRADINGDOCUMENT, TRADINGDOCUMENTITEM)
);