R_TRDGDOCBUSINESSDATABASIC

CDS View
67 Fields 1 CDS Views

Business Data of Trading Document

R_TRDGDOCBUSINESSDATABASIC is a CDS View in S/4HANA. Business Data of Trading Document. It contains 67 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_TrdgDocItem view_entity inner COMPOSITE Trading Document Item

Fields (67)

KeyField CDS FieldsUsed in Views
_Supplier _Supplier 1
CorrespncInternalReference CorrespncInternalReference 1
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 1
CustPurOrdDateByShipToParty CustPurOrdDateByShipToParty 1
DepreciationPercentage DepreciationPercentage 1
DownPaymentDueDate DownPaymentDueDate 1
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt 1
DownPaymentType DownPaymentType 1
FixedExchangeRateIsUsed FixedExchangeRateIsUsed 1
InternalFinancialDocument InternalFinancialDocument 1
IsOrderAcknRqd IsOrderAcknRqd 1
IssuingPlant IssuingPlant 1
OrderCombinationIsAllowed OrderCombinationIsAllowed 1
PaymentGuaranteeProcedure PaymentGuaranteeProcedure 1
PaymentTermsName PaymentTermsName 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
PurchaseOrderByShipToParty PurchaseOrderByShipToParty 1
PurchasingDocumentOrderDate PurchasingDocumentOrderDate 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurgDocOrderAcknNumber PurgDocOrderAcknNumber 1
PurgIncotermsClassification PurgIncotermsClassification 1
PurgIncotermsTransferLocation PurgIncotermsTransferLocation 1
QuotationSubmissionDate QuotationSubmissionDate 1
RetentionPercentage RetentionPercentage 1
SEPAMandate SEPAMandate 1
ShippingType ShippingType 1
SlsIncotermsClassification SlsIncotermsClassification 1
SlsIncotermsTransferLocation SlsIncotermsTransferLocation 1
Supplier Supplier 1
SupplierConfirmationControlKey SupplierConfirmationControlKey 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotationExternalID SupplierQuotationExternalID 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingPlant SupplyingPlant 1
TrdgDocIsRlvtPoDProcg TrdgDocIsRlvtPoDProcg 1
TrdgDocMnlPOSplit TrdgDocMnlPOSplit 1
TrdgDocPrcDetnExchRate TrdgDocPrcDetnExchRate 1
TrdgDocPurgDelivAddrCat TrdgDocPurgDelivAddrCat 1
TrdgDocPurgDeliveryDateType TrdgDocPurgDeliveryDateType 1
TrdgDocPurgDocCat TrdgDocPurgDocCat 1
TrdgDocPurgDocCndn TrdgDocPurgDocCndn 1
TrdgDocPurgDocExtReference TrdgDocPurgDocExtReference 1
TrdgDocPurgExchangeRate TrdgDocPurgExchangeRate 1
TrdgDocPurgExchangeRateType TrdgDocPurgExchangeRateType 1
TrdgDocPurgFixedValueDate TrdgDocPurgFixedValueDate 1
TrdgDocPurgIncotermsLoc1Text TrdgDocPurgIncotermsLoc1Text 1
TrdgDocPurgIncotermsLoc2Text TrdgDocPurgIncotermsLoc2Text 1
TrdgDocPurgIncotermsVersion TrdgDocPurgIncotermsVersion 1
TrdgDocPurgPaymentTerms TrdgDocPurgPaymentTerms 1
TrdgDocPurgPricingDate TrdgDocPurgPricingDate 1
TrdgDocPurgPricingProcedure TrdgDocPurgPricingProcedure 1
TrdgDocPurgReqdDeliveryDate TrdgDocPurgReqdDeliveryDate 1
TrdgDocPurgShipgInstrn TrdgDocPurgShipgInstrn 1
TrdgDocPurgValidityEndDate TrdgDocPurgValidityEndDate 1
TrdgDocPurgValidityStartDate TrdgDocPurgValidityStartDate 1
TrdgDocSalesFixedValueDate TrdgDocSalesFixedValueDate 1
TrdgDocSalesIncotermsVersion TrdgDocSalesIncotermsVersion 1
TrdgDocSalesPaymentMethod TrdgDocSalesPaymentMethod 1
TrdgDocSalesPaymentTerms TrdgDocSalesPaymentTerms 1
TrdgDocSalesPricingDate TrdgDocSalesPricingDate 1
TrdgDocSlsDeliveryDateType TrdgDocSlsDeliveryDateType 1
TrdgDocSlsIncotermsLoc1Text TrdgDocSlsIncotermsLoc1Text 1
TrdgDocSlsIncotermsLoc2Text TrdgDocSlsIncotermsLoc2Text 1
TrdgDocSlsReqdDeliveryDate TrdgDocSlsReqdDeliveryDate 1
UnderlyingPurchaseOrderItem UnderlyingPurchaseOrderItem 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.

-- Business Data of Trading Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_TRDGDOCBUSINESSDATABASIC (
    _SUPPLIER,
    CORRESPNCINTERNALREFERENCE,
    CUSTOMERPURCHASEORDERDATE,
    CUSTPURORDDATEBYSHIPTOPARTY,
    DEPRECIATIONPERCENTAGE,
    DOWNPAYMENTDUEDATE,
    DOWNPAYMENTPERCENTAGEOFTOTAMT,
    DOWNPAYMENTTYPE,
    FIXEDEXCHANGERATEISUSED,
    INTERNALFINANCIALDOCUMENT,
    ISORDERACKNRQD,
    ISSUINGPLANT,
    ORDERCOMBINATIONISALLOWED,
    PAYMENTGUARANTEEPROCEDURE,
    PAYMENTTERMSNAME,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    PURCHASINGDOCUMENTORDERDATE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCORDERACKNNUMBER,
    PURGINCOTERMSCLASSIFICATION,
    PURGINCOTERMSTRANSFERLOCATION,
    QUOTATIONSUBMISSIONDATE,
    RETENTIONPERCENTAGE,
    SEPAMANDATE,
    SHIPPINGTYPE,
    SLSINCOTERMSCLASSIFICATION,
    SLSINCOTERMSTRANSFERLOCATION,
    SUPPLIER,
    SUPPLIERCONFIRMATIONCONTROLKEY,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATIONEXTERNALID,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGPLANT,
    TRDGDOCISRLVTPODPROCG,
    TRDGDOCMNLPOSPLIT,
    TRDGDOCPRCDETNEXCHRATE,
    TRDGDOCPURGDELIVADDRCAT,
    TRDGDOCPURGDELIVERYDATETYPE,
    TRDGDOCPURGDOCCAT,
    TRDGDOCPURGDOCCNDN,
    TRDGDOCPURGDOCEXTREFERENCE,
    TRDGDOCPURGEXCHANGERATE,
    TRDGDOCPURGEXCHANGERATETYPE,
    TRDGDOCPURGFIXEDVALUEDATE,
    TRDGDOCPURGINCOTERMSLOC1TEXT,
    TRDGDOCPURGINCOTERMSLOC2TEXT,
    TRDGDOCPURGINCOTERMSVERSION,
    TRDGDOCPURGPAYMENTTERMS,
    TRDGDOCPURGPRICINGDATE,
    TRDGDOCPURGPRICINGPROCEDURE,
    TRDGDOCPURGREQDDELIVERYDATE,
    TRDGDOCPURGSHIPGINSTRN,
    TRDGDOCPURGVALIDITYENDDATE,
    TRDGDOCPURGVALIDITYSTARTDATE,
    TRDGDOCSALESFIXEDVALUEDATE,
    TRDGDOCSALESINCOTERMSVERSION,
    TRDGDOCSALESPAYMENTMETHOD,
    TRDGDOCSALESPAYMENTTERMS,
    TRDGDOCSALESPRICINGDATE,
    TRDGDOCSLSDELIVERYDATETYPE,
    TRDGDOCSLSINCOTERMSLOC1TEXT,
    TRDGDOCSLSINCOTERMSLOC2TEXT,
    TRDGDOCSLSREQDDELIVERYDATE,
    UNDERLYINGPURCHASEORDERITEM
);

Learn More